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

      Hello

       

      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.