I have a common dimension (custom hierarchy) for various fact tables. The Fact tables (Fact1, Fact2) are unrelated. say I have build 2 different reports with same dimension (Dim) and measures from 2 fact tables respectively, When I click on drillthrough, due to the nature of the tool, it shows both Detail1 and Detail2 reports belonging to 2 different datasets. My question is if I will be able to show only selected drillthrough and hide others. So when I click from Fact1, show option to drillthrough to only Detail1, hide detail2,3,..n.
I don't want to duplicate the dimension columns to differ as I have so many reports with the same dimension.