Subset Create With Mdx

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

Subset Create With Mdx

Post by chewza »

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: 146
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 »

PS

Paste into expression editor WITHOUT the double quotes works fine
chewza
Posts: 146
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 »

Ps

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