How to filter the table dynamically with another table?

[unalyigit]

I have 1 fact and 3 dimension table and source system is BW.

L1,L2 and L3 are hierarchy table between them. I don't combine these tables, because i add new fact tables with different granularity. however i want to select a value from L1, then L2 is filtered by L1 table selected value.

How can i do this?

Regards.

[Greg_Deckler]

Remove your relationship between L1 and R87, this will make the relationship between L1 and L2 active, which in turn filters R87.

I feel like these tables are named after droids...

[unalyigit]

Hi, 

The Real scneario is below, i have 3 fact table table has 3 different graniluty,

DimAltGrup, DimGrup and DimAnaGrup tables have hierachy between them. 

At the presentation layer,i have 3 dropdown list and i want to have relation between them. 

The model below, Dim Group DropDownList is not filtered by when i select a value from DimAnaGrup

[v-jiascu-msft]

Hi @unalyigit,

Your two snapshots are quite different. If it's the latter, you just need to establish proper relationships among "DimAnaGrup", "DimGrup" and "DimAltGrup". 

Best Regards,
Dale