TM1 Forum

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

You cannot create an empty dynamic subset. Make sure that the MDX expression actually returns a set.