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

    Dimensional Hierarchy & different fact levels

    Dafnis X



      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.





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




      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.