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@.poczta.onet.pl> wrote in message
news:4005442F.3060307@.poczta.onet.pl...
quote:
> 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. ?
>
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
