Hi,
how to model changes (I've read R.Kimball) in dimensions and (more
important) how to implement them in OLAP e.g. MS AS ?
I read some papers from scientists but they are not based on commercial
solutions - I don't know how to show changes in MOLAP and how to solve
the problem.
can you give me any suggestions, links etc. ?

thx in advance
Joel

"Joel" <dmrozek99 (AT) poczta (DOT) onet.pl> wrote

A little background for you - I am currently in the process of developing a
prototype for a Kimball-based data warehouse. I have experienced your
challenges but found Kimball's methodology very practical and beneficial.

To answer your questions:

1. Links: Your best bet would be www.rkimball.com, select the articles and
Ralph's Classic Favorites. You should also buy his book "Data Warehouse
Lifecycle Toolkit".

2. Modeling changes in dimensions: this is a very important topic. Once
again, this is addressed in Kimball's articles on slowly changing
dimensions.

For more specific answers, please provide specific questions.

HTH