MS Project Server OLAP Architecture

[johannes_II]

Hello Forum,

i´m trying to figure out some details about the olap architecture of
msps 2007, maybe someone can help me with this questions.

1. It seems to me that there ist a core-datawarehouse, in which the
data is stored via ETL process. On top of this dwh there are several
data marts(one for each real cube). Is that correct so far?
2. The data warehouse schema is a star schema?

Looking forward to your ideas.

Greetings
Johannes

 

[Mike Glen]

Hi johannes,

Try posting on the microsoft.public.project.server newsgroup (forum).
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP