this is my current query:
Select non empty (
DrillDownMember(
[ Incident].[Incident Date Year - Incident Date Month].[Incident Date Year],
[ Incident].[Incident Date Year - Incident Date Month].[Incident Date Year].&[2009]
, RECURSIVE),
DrillDownMember(
[Tree Master].[Parent Id],
[Tree Master].[Parent Id],
RECURSIVE),
{[Measures].[Incident Count],[Measures].[IncidentRate]})
On Columns
From [Gx2];
there are also data for 2010, 2011
in this case, 2009 is drilled down, and of course it will also show the total of 2010, 2011
In the 2nd drilldownmember, i have the TreeMaster drilled down, but this drilled down is applied to all years
Is it possible to apply the 2nd drilldownmember to only a subset of the first?
What i want to see is to see a drill down of 2009, and a drill down of TreeMaster in 2009, but i would like to keep 2010, 2011 undrilled
thx