TM1 Forum

I wrote an mdx statement
sMDX= '{ DRILLDOWNMEMBER( { DRILLDOWNMEMBER( { DRILLDOWNMEMBER( {TM1FILTERBYLEVEL( {TM1Subsetall()}, 2)}, {[Category_Test].[category director]} ) }, {[Category_Test].[category 2]} ) }, {[Category_Test].[category 3]} ) }';
if(SUBSETEXIST(sDim,sMDX)=1;
subsetdestroy(sDim,sMDX);
endif;
SubsetCreate ( 'Category_Test' , 'sMDX');

Basically I have three drop downs, each being the child of the previous. How would i loop this so that it can create a new dynamic subset for each element i choose(the dynamic subset would contain the children of the chosen element)

Hi,
You need to use the StrToMember function to pull the reference from the previous selection into the next MDX subset.

There are some examples on this thread