Post reply

How to apply a filter to decide which formula is used in a calculated measure

  • May 8, 2015 at 8:38 am

    #148892

    Hi colleagues,

    I am just wondering what could be the best way to meet this requirement:

    The user wants to be able, using excel, to apply a filter to all measures in every measure group.

    I though that I can create a dimension with a single level with two members, let´s say "on" and "off" and depending on the selected member and using an IIF statement decide which formula applies to the calculated measures.

    I have serious doubts about the performance and for this technique because I am thinking as a .Net developer and not as a cube developer. Maybe it is better to resolve it scoping the measures but I cannot figure it out.

    Any comment will be appreciated.

    Kind Regards.

    Paul Hernández

  • May 11, 2015 at 6:46 am

    #1796941

    If someone is interested I found this post:

    MDX Scope with an If Then statement[/url]

    The combination of both, the measure to switch on or off let´s say the path or to decide which formula should be applied to a calculated measure and the usage of scope assignments to overwrite the value of the measure in a specific context.

    Hope someone find it useful.

    Paul Hernández

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply