Report Portal

Parent-child dimensions, historical values (SCD) and keys

Usually working with historical values in an SSAS cube is not really complicated. Think of a customer whose ZIP code changed over time which is modeled as a slowly changing dimension of type 2:

IDCustomerZIPCurrent
1John Doe10000false
2John Doe10200false
3John Doe13041true

If we don't include the ZIP-code in the MDX query, we just see the sales. For example, let's take a look at the following query:

Read more...

Tags: parent-child

 

2007-2015 VidasSoft Systems Inc.