Subset Create With Mdx
Posted: Fri Feb 09, 2018 3:53 pm
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
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