MDX Subset in TI Process

Post Reply
dharav9
Posts: 72
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 »

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: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: MDX Subset in TI Process

Post by gtonkin »

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|'*"';
tomok
MVP
Posts: 2831
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 »

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

Thank You
Post Reply