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 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.