We have an Organisation dimension. It contains a department code and a department name. It is a type 2 SCD. THe code stays the same but the name changes over time.
In my cube dimension I want to use the code as the key column and the name as the Name column but I want to use the most current name, the one where RowIsCurrent = 'Y'
What is the easiest way to do this?
View Complete Post