All Questions
Tagged with star-schema ssas
2 questions
4
votes
1
answer
1k
views
What known strategies, if any, can I use to validate a Slowly Changing Dimension?
I have a customer dimension in our data warehouse (SSAS 2014 Multidimensional). It is set up as a Type II SCD, with just Start and End Date fields to track changes. (null end date = current).
As our ...
- 663
5
votes
2
answers
2k
views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
- 231