Hi,
Was just wondering if anybody could provide any books or weblinks that discuss how to implement slowly changing dimensions.
I am using SQL Server 2000 and Analysis services.
Basically, a lot of our customers have an organisation hierachy of many levels such as Manager > Supervisor > Team leader and so on. What I want to be able to do is have the ability to track when one person moves from one team to another.
So in the dimension it would say something like "Fred Blogs Until YYYYmmdd" and somewhere else it would have Fred Bloggs.
The first case would point to data upto and including YYYYmmdd but after this data Fred moves to a different team e.g. this would be the current data.
We have an implementation but am trying to simplify the process and was looking for examples to learn from.
Regards,
MrPeds
Was just wondering if anybody could provide any books or weblinks that discuss how to implement slowly changing dimensions.
I am using SQL Server 2000 and Analysis services.
Basically, a lot of our customers have an organisation hierachy of many levels such as Manager > Supervisor > Team leader and so on. What I want to be able to do is have the ability to track when one person moves from one team to another.
So in the dimension it would say something like "Fred Blogs Until YYYYmmdd" and somewhere else it would have Fred Bloggs.
The first case would point to data upto and including YYYYmmdd but after this data Fred moves to a different team e.g. this would be the current data.
We have an implementation but am trying to simplify the process and was looking for examples to learn from.
Regards,
MrPeds