Using a loop to check an mdx

[samiamsz]

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)

[Steve Rowe]

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