Multiples OLAP Cubes in the Project Server database ?

[Newbie]

Hello,
Is it possible to have several OLAP Cubes on the same Project Server
database, with different calculation options each ?
Thanks

 

[Gary L. Chefetz [MVP]]

It's certainly possible to have multiple cubes, however I don't know what
you mean by "different calculations."

 

[Newbie]

Gary,

I built an S-Curve which shows cumulative Work, cumulative Baseline Work,
cumulative Actual Work.
In the Update Resources Table and OLAP Cube, in the "Range of dates"
section, I selected "From the earliest Start Date to the latest Finish
Date". I have data in 2005, 2006... Everything works fine but when I select
the year 2006, the S Curves don't start from zero. Normal indeed.
I would like to build a second cube which should show only the data for
2006, so I would use the option : "From one specific date to another
specific date" in the calculation options

Is it possible ?

Thanks, and Happy New Year

 

[Gary L. Chefetz [MVP]]

Sure it is. Build another cube using a different name, and build another
view pointing to it.

 

[Newbie]

Thanks Gary, it works fine !

Sure it is. Build another cube using a different name, and build another
view pointing to it.