TM1 Forum

Hi there

I am struggling with this

My process below fails:
vMdx1 = '{TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [Customer] )}, "';
vMdx2 = vCustomer;
vMdx3 = '")}, ALL, RECURSIVE )}';
vMdxTotal = vMdx1 | vMdx2 | vMdx3;
SubsetCreateByMdx('SYS - Dynamic Mdx', vMdxTotal);


So instead to troubleshoot, I commented this out, and did asciioutput in order to check out the vMdxtotal variable.
Text file result:
"{TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [Customer] )}, "Export Rollup")}, ALL, RECURSIVE )}"

Note the double quotes in the text file
So the issue seems to be the double quotes. If copy this text, and paste it directly into the subset editor expression window, it works fine.

Any ideas?

Regards
Chris

PS

Paste into expression editor WITHOUT the double quotes works fine

Ps

Not to worry - All sorted. Found my issue.Thx!!!!!!