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
MDX Subset in TI Process
-
- MVP
- Posts: 2832
- 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
The string you are filtering for must be enclosed in quotation (") marks.
Code: Select all
vDataSet='"*'|v1|'*"';
-
- 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
Thank You