Calculating measures from two dimension tables in a Fact table
I have two dimension tables (say Dim A and Dim B) and a fact table (say Fact). Both dimension tables are linked through it's own keys.
There is another look-up table that is used to filter the data on the fact table. (For e.g. Region and country to filter country specific data)
The data is filtered nicely on Dim A measures although not on Dim B and I'm sure I'm missing something in the FACT table Load.
Unfortuantely, I won't be able to upload any qvw or show any fields due to data security reasons, but has anyone built a fact table with measures from multiple tables linked to a look-up table so that this look up table can filter data on both measures.