changing dimensions - 01-14-2004 , 07:29 AM
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
can you give me any suggestions, links etc. ?
thx in advance
Re: changing dimensions - 01-14-2004 , 11:19 AM
"Joel" <dmrozek99 (AT) poczta (DOT) onet.pl> wrote
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
2. Modeling changes in dimensions: this is a very important topic. Once
again, this is addressed in Kimball's articles on slowly changing
For more specific answers, please provide specific questions.