0 Replies Latest reply: Aug 11, 2017 5:44 PM by Julio Arriaga RSS

    Sales and cost granular récords in a single fact table

    Julio Arriaga



      Thanks in a advance for your help. I am not sure if I should merge a sales tables that have Customers and Products as Dim with Cost records, that have Plant and Products as Dim. Both have the same level of granularity but there are many fields in sales that do not apply to Costs (such as Distict, routes) and viceversa (such as shifts and lines)