Hi
Is it possible to have mdx subsets filter by cube data?
mdx filter by cube data
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: mdx filter by cube data
Check out this MDX "handbook" (http://www.bihints.com/creating_dynamic ... x_a_primer). It has a lot of excellent information, including a section about filtering based on cube values.
-
lotsaram
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: mdx filter by cube data
This can be applied to great effect in active forms as all element names, operators and values can be parameterised. This is infinitely more powerful in active forms than in the cube viewer. Once you have a decent grasp of MDX it is also very quick and easy to implement, I have no idea why everyone isn't doing it, people seem to think it's difficult but it's not 
-
Gregor Koch
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: mdx filter by cube data
Another good starting point for beginners is the inbuilt "Filter" functionality in Subset Editor.
Whilst recording an expression check how far "Tools-Filter" can take you. It allows basic MDX functions and will give you a working example.
Note that if you want to use the recorded expression in Active Forms you will have to replace TM1SubsetBasis() with another expression as it is only valid on the subset itself and stored in the .sub file.
Whilst recording an expression check how far "Tools-Filter" can take you. It allows basic MDX functions and will give you a working example.
Note that if you want to use the recorded expression in Active Forms you will have to replace TM1SubsetBasis() with another expression as it is only valid on the subset itself and stored in the .sub file.