In a cross-tab with column members from multiple dimensions, When I drill down on a dimension how can I drill up back and retain other dimensional members. Essentially, I want to drill down on a dimension and come back to the same view where I was when I drill up.
Example: Consider 'year' and 'type' dimensions as columns, 'product' as rows and 'sales' as measure.
when I drill down on a 2016(year) I am getting to months(children of 2016) and when I drill up on month I am getting to 2016 but I am losing 'type' dimension which I initially added to the cross-tab. Is there a property or work around to retain 'type' dimension upon drilling up?
Any help is appreciated, thanks
-VJ
This behavior is only seen in WSA preview mode. When run in HTML, the other members are retained.