locked
How to Filter Dimensions With "or" instead of "and"? RRS feed

  • Question

  • Is it possible to apply filtering so that the statements work as a series of "ors" instead of "ands"?  The specific issue I'm having, you can see below, is that I have many years worth of data.  I want my reports to focus on the Current Year and Prior Year.  When I apply either my current or prior year filter, it works as expected.  When I apply both, it returns no years, because of the "And" problem...

    Wednesday, May 22, 2013 3:19 PM

Answers

  • Hi there,

    It may be possible using MDX operator in the browser, or you would probably need to create a set of the members you want to see.  The solution I would propose would be to modify the MDX.  Switch to MDX mode and try the suggestions at the link below.

    http://thatmsftbiguy.com/mdxorfunctionality/

    cheers,

    Andrew


    Andrew Sears, T4G Limited, http://www.performancepointing.com

    • Proposed as answer by Elvis Long Friday, May 31, 2013 6:56 AM
    • Marked as answer by Elvis Long Friday, May 31, 2013 6:57 AM
    Wednesday, May 22, 2013 4:17 PM