TM1 Forum

Posted: **Thu May 24, 2012 2:32 pm**

Good day!

Please help me, who knows.
I want to create a dynamic subset in the TM1 with MDX commands.
For example, there is a cube with dimensions CFR, MyParam. I need to create a subset of all the values of CFR, if the intersection [CFR] and [MyParam].[MyType] =15. Can I write a query such a structure?:

Code: Select all

SubsetCreatebyMDX('MyCFR','SELECT FILTER({[CFR]}, ([Measures].[MyParam].[MyType])= 15) ON ROWS, {[Measures].[MyParam].[MyType]} ON COLUMNS FROM [TestCube]');

Posted: **Thu May 24, 2012 4:42 pm**

it is possible to create what you want but that particular syntax is not going to work for a subset because it is going to return a tuple. You need something like:

Code: Select all

{FILTER({[TestCube].([Dim_1].[ElementFromDim_1],[Dim_2].[ElementFromDim_2],.....[Dim_x].[ElementFromDim_x]) > 15 )}

TM1 Forum

How can to create a dynamic MDX subset in TM1?

How can to create a dynamic MDX subset in TM1?

Re: How can to create a dynamic MDX subset in TM1?