BookmarkSubscribeRSS Feed
metalray
Calcite | Level 5
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
4 REPLIES 4
TSBruce
SAS Employee
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
Calcite | Level 5
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
Calcite | Level 5
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
SAS Employee
There are estimators for SPDE. A quick search returned this pdf:
http://support.sas.com/rnd/scalability/spde/spde_setup.pdf


~ Angela

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 740 views
  • 0 likes
  • 3 in conversation