Hi,
Im sure most of you would have come acrossed this issue while reporting on a Cube. I have a issue here, In a crosstab report im taking Level's from 2 different Hierarchies of the Same Dimension as Rows. It has measure and a column as Selected Year_Month from prompt.
For example my Report is like this
Column1
Row1 Row 2 Measure
Row1 im able to filter on Measure > 0
But Row2 need to filter on Row1
How to do this? I tried using a tuple, currentMember, filter etc...nothing is working for me. Is it not working due to 2 different hierarchies? Please help.