Calculating OLAP Cube size

[metalray]

Hello,
I wonder if there is a tool that would help me to calculate
how long the OLAP Cube build will take and how much space would be required to
aggregate e.g. 4000 GB worth of data currently stored in an Oracle database.

Thanks

[TSBruce]

I would suggest with a white paper written for Global Forum. You can find the link at http://support.sas.com/resources/papers/proceedings09/319-2009.pdf.

[metalray]

Hi Bruce,

Thanks for that. Its an interesting paper but it does not give me an estimate about aggregated MOLAP data. I think this has to get down to the efficency of SAS OLAP data structure storage. How efficent (reduce in size maybe?) does SAS OLAP store data that is now aggreagted to 7 TB in an Oracle database?.
Will I need more or less. I am at the planning stage of a server environment.

[metalray]

I noticed that MOLAP uses the SAS Scalable Performance Data Engine to
store the data. Maybe there is an estimator around for this engine....

[AngelaHall]

There are estimators for SPDE. A quick search returned this pdf:
http://support.sas.com/rnd/scalability/spde/spde_setup.pdf


~ Angela