Whitepaper:
Slowly Changing Dimensions

How to deal with Slowly Changing Dimensions in Jedox

Slowly Changing Dimensions are a recurring topic in Business Intelligence and Data Warehousing in general. The term describes the unpredictable change of dimension tables over the life-cycle of a data model and the approaches used to capture and document historical data for future reference.

Table of Contents: 

1. Introducing Slowly Changing Dimensions
2. Update → Actual Data
3. Parallel Hierarchies → Historical Data + Rare change + compact dimension
4. Split information over different dimensions → Historical data
5. Historical Cube → Historical Data + Frequent changes + large dimensions
6. Control Cube → Historical Data
7. In a nutshell