mdx filter by cube data
Posted: Fri Feb 11, 2011 12:51 pm
Hi
Is it possible to have mdx subsets filter by cube data?
Is it possible to have mdx subsets filter by cube data?
TM1 Forum
Discussing all things TM1, Planning Analytics, PAx and PAW
https://www.tm1forum.com/
mdx filter by cube data
Page 1 of 1
Re: mdx filter by cube data
Posted: Fri Feb 11, 2011 1:07 pm
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.
Re: mdx filter by cube data
Posted: Fri Feb 11, 2011 9:59 pm
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 
Re: mdx filter by cube data
Posted: Mon Feb 14, 2011 12:31 am
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.