Monthly Archives: December 2012

7 reasons why you should prefer SCD 1 over SCD 2+

dimensional modeling When it comes to dimension design a common question is about dealing with attributes that are changing over time. A frequently used pattern for such attributes was developed by Ralph Kimball with his concept of slowly changing dimensions … Continue reading

Posted in Allgemein | Leave a comment

Hierarchies with text fields (attribute relationship)

SQL Server 2005-2012 When setting up hierarchies for multidimensional SSAS attribute relationships between the levels are highly recommended. There might be scenarios in which the source data breaks those attribute relationships and usually this can be solved by choosing a … Continue reading

Posted in Allgemein | Tagged , | Leave a comment