MDX Subset in TI Process

Post Reply
dharav9
Posts: 6
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

MDX Subset in TI Process

Post by dharav9 » Mon Aug 20, 2018 4:36 pm

Hi, All

I was getting following error while creating MDX based subset.

Business Case:

V1='34440';

Element to search (wildcard search) is =*34440* and output i should receive =34440-ABC

vDataSet='*'|v1|'*';

vMDX='{TM1FILTERBYPATTERN ({TM1FilterbyLevel({TM1Drilldownmember({(['|cDim|'].['|cElement|'])}, All,Recursive)}, 0)},'|vDataSet|'}';

SubsetCreateByMDX(sSub,vMDX);

Error:

could not create dynamic subset
136 character error
{TM1FILTERBYPATTERN ({TM1FilterbyLevel({TM1Drilldownmember({(['|cDim|'].['|cElement|'])}, All,Recursive)}, 0)},*34440*}';

(should the output comes in double quote "*34440*" , like this?)


Any thoughts?

Thank You

User avatar
gtonkin
MVP
Posts: 638
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: MDX Subset in TI Process

Post by gtonkin » Mon Aug 20, 2018 5:51 pm

dharav9 wrote:
Mon Aug 20, 2018 4:36 pm
...
(should the output comes in double quote "*34440*" , like this?)
...
Try change: vDataSet='*'|v1|'*';
To: vDataSet='"*'|v1|'*"';

User avatar
tomok
MVP
Posts: 2493
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: MDX Subset in TI Process

Post by tomok » Mon Aug 20, 2018 5:52 pm

The string you are filtering for must be enclosed in quotation (") marks.

Code: Select all

vDataSet='"*'|v1|'*"';
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

dharav9
Posts: 6
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Re: MDX Subset in TI Process

Post by dharav9 » Mon Aug 20, 2018 6:10 pm

Thank You

Post Reply