Subset Create With Mdx

Post Reply
chewza
Posts: 55
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Subset Create With Mdx

Post by chewza » 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

chewza
Posts: 55
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Subset Create With Mdx

Post by chewza » Fri Feb 09, 2018 3:54 pm

PS

Paste into expression editor WITHOUT the double quotes works fine

chewza
Posts: 55
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Subset Create With Mdx

Post by chewza » Fri Feb 09, 2018 3:57 pm

Ps

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

Post Reply