MDX Expression Help For Calculated MEASURE in SSAS RRS feed

  • Question

  • Hi,

    I need a help to make an expression for SSAS Calculated Measure definition.I have 2 definitions for the same calculated measure, but they need to be applied on DATE filter. That is before a certain date the expression needs to be calculated using a different definition, and after the date the Calculated Measure will be calculated using the different expression.

    Any Suggestions on how to achieve that?

    for example if i have the two expressions


    ([ActionTag].[Actions Hierarchy].[Campaign].&[Atlas].&[etools Confirmation],[Measures].[Conversions])


    ( {
       [ActionTag].[Action Tag].&[526284]
    ,[ActionTag].[Action Tag].&[526283]


    PS- If i am addressing it at the wrong location, please guide me . Thanks.


    Friday, February 1, 2013 10:40 AM


All replies