I have cube with versions, time, stores, departments, and metrics dimensions.
I am trying to use a dynamic set on the rows to show only those department/store combinations where the margin 5 (shown on the column) is less than 5%. So departments and stores should be nested
Simple MDX would look like:
Code: Select all
FILTER({TM1FILTERBYLEVEL(TM1SUBSETALL([Departments_PLAN].[Departments_PLAN]) , 0)},
[PLANCube].([SalesLines].[Margin%])<0.05)
- both dimension use an MDX filter
- only the outer dim, and then only the inner dim uses the filter
Any idea how is it possible to write a cube-value based FILTER condition in an MDX statement that would work with nested dimensions?
Thank you for your help!