TM1 Forum

hi,

is it possible to create an MDX passing a variable containing the dimension name instead of a dimension name?

I mean:

SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([Variable] )},0)}');
instead of
SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([DimensionName] )},0)}');

SubSetCreateByMDX(vSub,'{TM1FILTERBYLEVEL({TM1SUBSETALL([' | Variable | '] )},0)}');

should do the trick, or you can separate:

MDXStr = '{TM1FILTERBYLEVEL({TM1SUBSETALL([' | Variable | '] )},0)}'
SubSetCreateByMDX(vSub,MDXStr);

it worked.

thanks for the help.