MDX filter for two dimensions
Posted: Wed Feb 22, 2023 8:54 pm
Hi all,
Just looking to confirm if the following situation is possible. I don't believe it is, but would like to confirm and maybe get some thoughts on what is possible.
I have a dynamic report created from a 3 dimensional cube:
Order #
Line
Measures
In the rows I have Order #, Line, and several measures and would like to filter based on a cube value.
The measure I am trying to filter on is a Flag which determines whether the transaction is active or not (see screenshot below).
In this example I'd need the 2 yellow shaded cells to be hidden on this report.
So I'd have to hide the intersection of Order# 001 and Line 2 as well as the elements within those dims.
Cell security achieves only hiding the data but the dimension elements are still displayed.
Looking forward to hearing any thoughts if there is any way this can be achieved.
Thanks in advance!
Just looking to confirm if the following situation is possible. I don't believe it is, but would like to confirm and maybe get some thoughts on what is possible.
I have a dynamic report created from a 3 dimensional cube:
Order #
Line
Measures
In the rows I have Order #, Line, and several measures and would like to filter based on a cube value.
The measure I am trying to filter on is a Flag which determines whether the transaction is active or not (see screenshot below).
In this example I'd need the 2 yellow shaded cells to be hidden on this report.
So I'd have to hide the intersection of Order# 001 and Line 2 as well as the elements within those dims.
Cell security achieves only hiding the data but the dimension elements are still displayed.
Looking forward to hearing any thoughts if there is any way this can be achieved.
Thanks in advance!