Dynamic Subset on two attributes

jinanday

I??m struggling with a dynamic subset and filtering on two attributes in 3 dimension at the same time.
I have 3 dimension , Account, SalesMan and Category
??Account?? has two attributes : SPCode,CatCode
??SalesMan?? has one Attributes : SPCode
??Category?? has one attributes : CatCode
I am trying with filter, but it??s not working .
{FILTER ({TM1subsetAll ([Accounts] )},(( [Accounts].[SPCode] = [SalesMan].[SPCode])
AND ([Accounts].[CatCode] =[Category].[CatCode])))}

Any body can help me please.

fuanxx

Have you tried recording this in the subset editor?

wquyhytuoy

yes, but not working . Any idea pls.

jsyyrs

You can do this very easily without using MDX. Using a while statement in TI loop through the account dimension from 1 to the dimsiz and only insert elements in to the subset if they meet your criteria. Would this work or does the subset have to be more dynamic? For me you could do this every time you update the account dimension or update the attributes on either of the other 2 dimensions. This does however only work if the attributes are being updated via TI and not being done manually. Saying that if you use an excel template to edit the attributes you could add an action button to the sheet,

Jim.

sunnypure

I suspect you will need to look at your use of the AND condition.

What results are you getting from your original query?