topic Re: Calculating OLAP Cube size in SAS Web Report Studio

Calculating OLAP Cube size

metalray — Tue, 09 Nov 2010 16:04:31 GMT

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

Re: Calculating OLAP Cube size

TSBruce — Wed, 10 Nov 2010 19:13:21 GMT

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.

Re: Calculating OLAP Cube size

metalray — Thu, 11 Nov 2010 08:36:23 GMT

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.

Re: Calculating OLAP Cube size

metalray — Thu, 11 Nov 2010 09:29:05 GMT

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

Re: Calculating OLAP Cube size

AngelaHall — Thu, 11 Nov 2010 14:55:07 GMT

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

~ Angela