locked
Create New Dimension Member RRS feed

  • Question

  • I have a dimension with the following members:

    Dim1

    Dim2

    Dim3

    I need to create a new member that equals Dim1 + Dim2.

    So with the new member the dimension would look like this:

    Dim1

    Dim2

    Dim3

    DIM1_and_Dim2.

    Thursday, November 10, 2011 7:21 PM

Answers

  • you can create a calculated dimension member for this. For example,

    with member Geography.Country.Other as
    Aggregate({ [Geography].[Country].&[Canada], [Geography].[Country].&[France]} )
    
    select [reseller sales amount] on 0,
    Geography.Country.Other on 1
    from [adventure works]

     




    Javier Guillen
    http://javierguillen.wordpress.com/
    • Proposed as answer by Lola Wang Friday, November 11, 2011 9:57 AM
    • Marked as answer by Challen Fu Thursday, November 24, 2011 10:19 AM
    Thursday, November 10, 2011 8:23 PM