MDX in one dimension based on the subset of another dimension

[EP_explorer]

I have 2 dimensions with the same elements (Dim1 and Dim2)

First dimension Dim1 using in Setup_Cube where put some flags on some elements. Exist subset Sub1 which filter elements in Dim1 based on flags.

Is it possible to create MDX subset Sub2 in Dim2 which contains the same elements as Sub1 in Dim1?
May be based on flags on Setup_Cube - but it contain Dim1.

[burnstripe]

Yes it's possible, you could use the Generate function to do this. I'm not at a pc today but if noone comes back I can post an example tomorrow

[MarenC]

Hi,

a non dynamic example would be:

{GENERATE(TM1SUBSETTOSET([Dim1], 'Sub1' ), {StrToMember("[Dim2].[" + [Dim1].currentmember.name + "]")})}

Maren

[EP_explorer]

Thank you
It works

[MarenC]

Hi,

Though this one might be better just in case an element doesn't exist in the dimension:

{GENERATE(TM1SUBSETTOSET([Dim1], 'Sub1' ), FILTER(TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dim2] )}, 0), [Dim1].Currentmember.name = [Dim2].Currentmember.name ))}

Maren

[Elessar]

Heeey, that was one of my quiz questions! Maren could have earned another point

[EP_explorer]

Heeey, that was one of my quiz questions! Maren could have earned another point

You can give me a point for the good question