MDX Connection formula RRS feed

  • Question

  •  how can i use Case validate multiple selection from the filter like CASE WHEN <<Unique Name>>.Name="Cycle" And "Car" that if he selected these to value 
    Wednesday, July 18, 2012 1:51 AM

All replies

  • I believe the filter sends out multi selected values as a set like { [dim item].&[Cycle], [dim item].&[Car] }. Nested IIF should be sufficient.

    IIF ( EXISTS( <UniqueName>, [dim item].&[Cycle])
      , IIF ( EXISTS( <UniqueName>, [dim item].&[Car])
        , Condition met do something
        , Condition not met )
      , Condition not met )
    You might want to check what UniqueName contains using SQL Profiler.

    Wednesday, July 18, 2012 1:53 PM