TM1 Forum

Hello,

I would like to create a MDX subset in my TurboIntegrator process, with an attribute variable. But I have a quote issue.
Let's illustrate with an example:

***************************************************************

This code works well:

vMDX = '{FILTER(TM1SubsetAll([vDimension1].[vDimension1]), ([vDimension1].[vDimension1].CURRENTMEMBER.PROPERTIES("vAttribute1") = "vValue"))}';
vSubsetName1='zSubSet_' | vDimension1;
SubsetCreatebyMDX(vSubsetName1,vMDX);
SubsetMDXSet(vDimension1,vSubsetName1,'');

DataSourceType='SUBSET';
DatasourceNameForServer=vDimension1;
DatasourceDimensionSubset=vSubsetName1;

***************************************************************

Now, I would like to use a variable on my "vValue", so i wrote:
vMDX = '{FILTER(TM1SubsetAll([vDimension1].[vDimension1]), ([vDimension1].[vDimension1].CURRENTMEMBER.PROPERTIES("vAttribute1") = ' | vValue | ' )}';

But the result is wrong, because my code does not have the vValue between quotes. It generates: {FILTER(TM1SubsetAll([vDimension1].[vDimension1]), ([vDimension1].[vDimension1].CURRENTMEMBER.PROPERTIES("vAttribute1") = vValue))}

I guess there is a simple solution, but I don't have it. Do you have any clue?
Have a nice day.
sblot

Change the syntax to this

vMDX = '{FILTER(TM1SubsetAll([vDimension1].[vDimension1]), ([vDimension1].[vDimension1].CURRENTMEMBER.PROPERTIES("vAttribute1") = "' | vValue | '" )}';

Notice the double quote before the single quote before vvalue and a double quote after the following single quote

Another approach to consider is using Expand() - This makes these MDX queries easier to read by limiting all the quotes needed:

+1 I would also always use Expand for such cases. It's just easier.

Thank you burnstripe, it is working well now.

I did not know this expand function. I will try it so, thanks for the tip.

I did not know this expand function.

My advice, learn it!

Always use EXPAND() as well. Makes parsing more complex MDX easier to read vs. concatenations to me.

Just pay attention to 2 things:
- Expand with numbers gives you a certain format with 3 decimal digits
- Expand of an Expand whereby the inner Expand resolves to something that contains a % character will cause you headaches.