Forum Discussion
Responsive ResidentHow to show records without historical data?
Check out your example file here:
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
I'd also suggest you make consideration about where certain attributes belong. Is the product group an attribute of the sale or is it an attritube of the product? Is the customer type and attribute of the sale of is it an attribute of the customer?
In the provided example i moved the customer type into the customer table. Consider removing the separate customer type table and the customer type id from the sales table.
Solution SageCheck out your example file here:
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
I'd also suggest you make consideration about where certain attributes belong. Is the product group an attribute of the sale or is it an attritube of the product? Is the customer type and attribute of the sale of is it an attribute of the customer?
In the provided example i moved the customer type into the customer table. Consider removing the separate customer type table and the customer type id from the sales table.
Responsive ResidentNickolajJessen That works. Thank you so much for your help!
You are 110% right on the number of attributes in the fact table by the way. I am aware of that but I do appreciate that you try to warn me for it.