2 Replies Latest reply: Jul 7, 2016 6:08 AM by susant Kumar swain RSS

    Calculating measures from two dimension tables in a Fact table

    Kash Jani



      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.


      Many Thanks for your help.