Forum Discussion
Snowflake Schema to Handle Different Fact Table Grains
Hi There, Is it bad practice to snowflake a dimension to handle different grains on fact tables? For example, I have two fact tables: fact_sales, and fact_sales_targets. The first is at the day g...
In general, I think it is a good practice. The additional DimMonth table may take some but very limited storage but it saves the DAX code, saving the processing CPU.
FreemanZ
Super User
Super UserIn general, I think it is a good practice. The additional DimMonth table may take some but very limited storage but it saves the DAX code, saving the processing CPU.
Thank you. I expected this, but every example I could find online had bad examples only for why you should not snowflake the model. This situation was not included.