Traditional web-based reporting with SAS BI tools

Calculating OLAP Cube size

Reply
Regular Contributor
Posts: 207

Calculating OLAP Cube size

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
SAS Employee
Posts: 37

Re: Calculating OLAP Cube size

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.
Regular Contributor
Posts: 207

Re: Calculating OLAP Cube size

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.
Regular Contributor
Posts: 207

Re: Calculating OLAP Cube size

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

Re: Calculating OLAP Cube size

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


~ Angela
Ask a Question
Discussion stats
  • 4 replies
  • 235 views
  • 0 likes
  • 3 in conversation