Whitepaper:
Slowly Changing Dimensions (EN)

Resource Image

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

 

By | 2017-04-07T14:08:19+00:00 Juli 5th, 2016|
X