none
Aggregations only for specific dimensions? RRS feed

  • Question

  • Hi

    I have a cube name Orders and have many dimensions like Territory, Month,D1,D2.

    Now I have added a calculated measure to make one of the measure getting aggregated for only these two dimensions - Territory and Month. For this I have written a MDX query...

    CREATE MEMBER CURRENT CUBE.[Measures].[Target Val]

    AS(

    ROOT ([Territory].[Territory Name].currentmember),

    ROOT([Month].[Calendar].[Month].currentmember),

    Root([D1]),

    Root([D2]),

    [Measures].[target Value]),

    FORMAT_STRING = "Currency"

    VISIBLE = 1;

    Now, My question is how can I make a simple query to make aggregation of Target Val for all the attributes available in Territory and Month dimensions other than Territory name and month as in above code.

    Thanks In advance,

    BI

    Wednesday, January 4, 2012 1:02 PM

Answers

  • Hi ursdelight,

     

      You can just remove the Month and territory currentmembers from the above code.

     

    CREATE MEMBER CURRENT CUBE.[Measures].[Target Val]

    AS(

    Root([D1]),

    Root([D2]),

    [Measures].[target Value]),

    FORMAT_STRING = "Currency"

    VISIBLE = 1;


    Ram
    • Marked as answer by SQL2012BI Thursday, January 5, 2012 10:01 AM
    Wednesday, January 4, 2012 4:29 PM