Hi All,
What is the difference between ROLAP, HOLP, MOLAP ?
And is there any option for 'Automatic refresh' for OLAP CUBE.
Thanks,
Suresh
1. I suggest you look up the definitions on Wikipedia. The entries there are quite informative. SAS supports both with its OLAP server.
2. SAS OLAP stores are created and updated by running PROC OLAP. Therefore, anything that you can do with this procedure can be automated with scheduling software. Therefore, the answer is "yes", but it does require some work.
Tom
Dear
LE MOLAP is default format of OLAP used by SAS. If I understand well the process of SAS :
The most difference is define by the Storage.
The MOLAP stored all information on the server (physical). From a Star Schema or not, you build the definition of the Cube and create it, refresh modifiy etc ....
The ROLAP is the most of time used with RDBMS, the data are inside the RDBMS, all request on the cube SAS transform the MDX query into SQL RDBMS.
Look at this document, it is very good :
http://support.sas.com/resources/papers/proceedings09/103-2009.pdf
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: