JipingWang
Programmer
For a slowly changing dimesion, say Customer, the ID is the business key, and Name SCD attribute.
SurrogateKey BusinessKey Name Current
1001 1 William 0
1002 1 Bill 1
Question: when do analysis, how Cognos decides which Name to show? I don't see settings for this in Framework Manager Project
SurrogateKey BusinessKey Name Current
1001 1 William 0
1002 1 Bill 1
Question: when do analysis, how Cognos decides which Name to show? I don't see settings for this in Framework Manager Project