TM1 Forum

Hi,

I have 2 dimensions: DimA and DimB,
one attribute of DimB, DimB_Attr has values of elements in DimA.

Is it possible to create a dynamic subset which takes elements of DimA informed in DimB_Attr?

Something like
{ FILTER( { TM1FILTERBYLEVEL( { TM1SUBSETALL( [ DimA] ) }, 0 ) },
[ DimB].[DimB_Attr] = [DimA].CurrentMember
)}

regards

Are you saying you tried that and it didn't work, or have you not bothered to try it yet?

I tried it and it doesnt work,
I tried also somethings like:

{ FILTER( { TM1FILTERBYLEVEL( { TM1SUBSETALL( [ DimA ] ) }, 0 ) },
[ }ElementAttributes_DimB].( [ DimB].AllMembers
, [}ElementAttributes_DimB].[ DimB_Attr ]) = [ DimA ].CurrentMember
)}

I tried to replace AllMembers by Members, CurrentMember, Item(x)...
In some case the syntaxe is not correct, in others I got all level 0 elements without filter, in some others nothing.