Empty Drillthrough result when unrelated dimension attribute has a default member
Whenver a dimension attribute that is unrelated to a measure group has a default member which is not �All�, and the measure group has IgnoreUnrelatedDimensions set to false, no rows are ever returned when drilling through on the MeasureGroup (even if the value of the unrelated dimension is explicitly set to �All� at the cell from which the drillthrough takes place).
Upvotes: 6<=-=Oct 2 2006 12:55PM=-=>
This issue got reported twice – keeping the first report.<=-=Mar 1 2011 12:24PM=-=>
I can repro the same issue with 2008 SP2. In my case, drillthrough on some cells returns no rows when it should or returns repeating rows. I think after four years it’s time for a fix. The only workaround I have is to set IgnoreUnrelatedDimensions back to True.