Forum Discussion
Multiple fact tables into one dimension
Hey guys, I have created one dimension through two different fact tables. The column I needed was Addresses and both the fact tables have them and I just wanted to have one new dimension table instea...
so, i am trying to filter dimension tables with other dimension tables and this is causing the problem.
johnt75
Super User
Super UserLets say you've got the situation
DimA -> DimB -> FactA
so that you put a filter on DimA and want it to reach FactA. All the values you filter for in DimA must appear in DimB otherwise the filter won't reach FactA.
A better option would be to consolidate both dimensions into a single table.