问题 MDX Query for showing totals

  • 2012年3月29日 20:55
     
     

    Below is a simplied version of the query. I try to get the top line with the total for all, but it's including the area manager.

    with

    member

    [Measures].[MOverallExp]

    as ([Version].[Version].&[1], [Metric].[Parent Metric].[Overall Experience], [Measures].[Rating 5 Pct], [Timeframe].[Timeframe].[Rolling 3 Periods]) set

    [Top]

    as  [Restaurant].[Restaurant].[All Restaurants] TopPercent(Exists([Restaurant].[Restaurant].[Restaurant].Members), 10, [Measures].[MOverallExp])

         +


    select

      [Measures].[MOverallExp]    on COLUMNS,


    non empty [Top] * { [Restaurant].[Area Manager].[Area Manager] }

    DIMENSION PROPERTIES MEMBER_CAPTION on ROWS

    from

    PGE
    where

    ( [Time].[Time].[Fiscal Period].&[2012]&[2], [Restaurant].[Restaurant By Brand].[Brand].&[SWI])

    CELL

    PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS;                   

    • 已编辑 P D Brent 2012年3月30日 20:33 Simpler query
    •