If i write some MDX to compare values between 2 months in a cube with 5 dimensions, what does the code use to evaluate the subset when some dimensions are not specified in the MDX? For example, i have a cube of headcount data and i want to write MDX on the employees dimension that looks for a change between 2 months. It might be department, site, resource type etc. So my code might look like;
Code: Select all
{FILTER (
{TM1SUBSETALL( [Employees] )}
, ([actuals].([MonthYear].[Feb - 2009], [Actuals Measures].[Actual Headcount]) = 1) AND
([actuals].([MonthYear].[Jan - 2009], [Actuals Measures].[Actual Headcount]) = 0)
)}
So the type of filter i'm looking for appears to be impossible using MDX. Ideally i'd like the MDX to evaluate the selections the user has made in their cube view, and reselect its elements accordingly. I don't think i can do that, but does anyone know any different?