locked
Help with the Report? RRS feed

  • Question

  • hi all,

    i am not having luck with this.  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] )

     

    any ideas?

     

     

     

    Tuesday, April 1, 2008 3:03 PM

Answers

  • The charts will show the axis labels and the same level of detail that you are displaying in the chart. That is why when you select minute level in your chart, the labels reflect minute label as well.  I will note this as a feature suggestion for a future release.

    Thanks,

    Alyson

     

     

    Wednesday, April 2, 2008 2:25 PM