Forum Discussion
How to filter the table dynamically with another table?
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.
3 Replies
- Greg_Deckler
Community Champion
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...
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-msftMicrosoft Employee
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
