How We Apply Drill Through Filter for a Dimension to Target Cube

[MacintoshF16]

Hi Amigos

If we have one Cube with the drill thru link and if we drill thru to the target after applying the filter to one dimension,then how do we ensure that in target cube only that filtered level in that dimension along with its child levels will be shown and its sibling will be hidden.

Thank for u all in advance.


Macintosh.

 

[DoubleD]

There is no way to ensure columns will be hidden when you drill through. The only thing drill through will do is filter to the data you are passing.