PowerPivot and the Slowly Changing Dimensions

User Rating: 0 / 5

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Slowly changing dimensions are very common in the data warehouses and, basically, they store many versions of the same entity whenever a change happens in the columns for which history needs to be maintained. For example, the AdventureWorks data warehouse has a type 2 SCD in the DimProduct table. It can be easily checked for the product code "FR-M94S-38" which shows three different versions of itself, with changing product cost and list price.

Read more...

Tags: dax, excel, design

 

2007-2015 VidasSoft Systems Inc.