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
Subset Create With Mdx
Re: Subset Create With Mdx
PS
Paste into expression editor WITHOUT the double quotes works fine
Paste into expression editor WITHOUT the double quotes works fine
Re: Subset Create With Mdx
Ps
Not to worry - All sorted. Found my issue.Thx!!!!!!
Not to worry - All sorted. Found my issue.Thx!!!!!!