topic Sales and cost granular récords in a single fact table in QlikView https://community.qlik.com/t5/QlikView/Sales-and-cost-granular-r%C3%A9cords-in-a-single-fact-table/m-p/1391573#M820210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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)</P><P>‌</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT julioarriaga 2020-11-25T16:16:04Z Sales and cost granular récords in a single fact table https://community.qlik.com/t5/QlikView/Sales-and-cost-granular-r%C3%A9cords-in-a-single-fact-table/m-p/1391573#M820210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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)</P><P>‌</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sales-and-cost-granular-r%C3%A9cords-in-a-single-fact-table/m-p/1391573#M820210 julioarriaga 2020-11-25T16:16:04Z