its seems to me its really not possible to implement SCD2 changing hierarchy in analysis services such the hierarchy is properly displayed in excel.
for instance if scd2 changes happen on leaf level then excel correctly shows the data but if they happen on branch level analysis services picks up one parent
eg
at time 1 hierarchy looks like this
A->B
at time 2 hierarchy is
A->C
when hierarchy is displayed in excel 2007 it shows
time
1 2
C 100 200
A 100 200
but this not a correct display of hierarchy changing over time
the correct display is this
time
1 2
B 100
A 100
C 200
A 200
View Complete Post