The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

usbrandon (3) [Avatar] Offline
Is there a discussion about using slowly changing dimensions in a Mondrian model? If the authors have encountered any scenarios, it would be nice to know generally what they were and what techniques there are to expose versions of rows using MDX queries, Mondrian models and the engine itself.

SCD is one of the most popular topics in dimensional modeling, yet I have never seen a schema in the last few years take advantage of it. All the schema I have seen take the latest technical key against a technical key in the fact table with a given measure.

Thanks for considering this topic.

william.back (28) [Avatar] Offline
Re: Working with slowly changing dimensions in Mondrian
Chapter 3 has a discussion on slowly changing dimensions (types I, II, and III).

However, keep in mind that the original work done by Kimball dealt with only databases. IMO, the correct approach is to have the fact table link to the version of the dimension row via surrogate keys that represents the true state at the time the fact occurred.