11 Replies Latest reply: Aug 23, 2017 2:21 AM by Dafnis X RSS

    Dimensional Hierarchy & different fact levels

    Dafnis X

      Hi,

       

      In the attached model I have a dimensional hierarchy in a flat table (Delivery_Offer_Item).

      Delivery > Offer > Item

       

      the 2 facts tables are linked to it with different fields and to different levels.

      The request is to be able to display a delivered or returned item per customer.

       

      Data_Model.png

       

       

      I would like to concatenate the 2 fact tables but i receive a synthetic key.

       

      Syntetic_Key.png

       

      My question is which is the right way to handle it.

      Should I outer join the items in the dimension to Customer_Deliveries ?

      In reality, the The Customer Deliveries have tens of millions of records of deliveries only.

       

      I would appreciate very  much your help here.

       

      Thanks!