Mr & Ms 500,

Well, I have seen the datamodel used for SCD 2 (for example: http://blogs.microsoft.co.il/blogs/barbaro/archive/2007/09/08/Slowly-Changing-Dimension-type-2-in-SSAS.aspx)

But how is the Dimension defined? Which attributes do we define for this example?

And how is it consulted then?

Sure I'm missing something that seems obvious for others. But that can be hard to find :w00t:

thanks

Jan