Hello,
I want to create a dynamic subset with an MDX-statement within a TI-process.
The following code works:
VMDX= '{TM1FILTERBYPATTERN({TM1SUBSETALL( [L_User] )},"*")}';
cNewUsersSubset = 'mdxsubset2';
SubsetDestroy('L_User', cNewUsersSubset);
SubsetCreateByMdx(cNewUsersSubset, vMDX);
Now I want to change the string-pattern, in order to get all users which name starts with GL. So I thought I just need to change the first line:
VMDX= '{TM1FILTERBYPATTERN({TM1SUBSETALL( [L_User] )},"GL*")}';
But then I get the Error message "Can not create dynamic subset"
Do you have a hint why it does nto work?
Thanks a lot!
Toto
Wrong MDX-Statement
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Wrong MDX-Statement
You cannot create an empty dynamic subset. Make sure that the MDX expression actually returns a set.