locked
Proclarity vs PPS RRS feed

  • Question

  • Hi all,

    I do need the scoreboard capability but at the same time , i need complex reports as below -- similar to stock reports

    should i install Proclarity and give it a try or are there any better reporting tools?

     

     

     

    My time dimension tables has the following fields

    TimeID  Hour  Min  HHMM (calculated)  and the data is collected per Minute

     

    the Report  when i select HHMM as x-axis  looks like this

     

     

    |  .   .   .

    |----------------------------------

    12.06  12.08  12.10   HHMM

     

    i want the report to look like this

     

    |  the chart here should be minute data ( NOT aggregated per hour)

    |-----------------------------------------------

    12              1                2   Hour

     

    MDX query

    SELECT
    { [Tbl Dim Time].[HHMM].[HHMM].ALLMEMBERS }
    ON COLUMNS,
    NON EMPTY
    { [Tbl Dim Application].[Application Name].[Application Name].ALLMEMBERS } * { [Tbl Dim Server].[Server Name].[Server Name].ALLMEMBERS }
    ON ROWS

    FROM [PerMinDW]

    WHERE ( [Measures].[Availability] )

    Wednesday, April 2, 2008 9:18 PM