| PowerPivot and the Slowly Changing Dimensions |
| Written by Alberto Ferrari |
| Wednesday, 09 February 2011 20:06 |
|
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... |
Author articles
- Clever Hierarchy Handling in DAX
- Understanding Circular Dependencies in Tabular and PowerPivot
- Video - Many-to-Many Relationships in DAX
- KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets
- Tabular Parent/Child Dimensions: SumOfLeaves and the CALCULATE wall
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
