As per a best practice documentation, the best way to implement SCD in AS2000,
is to introduce a business key in addition to the surrogate key to keep track
of the changing dims.

The document goes on to suggest that we create a dimension of current members
by using a current = 'TRUE' condition, a dimension of all members and a cube
from a view that includes the surrogate key as well as the business key.

But no measures appear against the inactive members in the all member
dimension - because the surrogate key corresponding to this has been removed
by the view used for the current dimension.

Please let me know where I am going wrong!

thank you!


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200511/1