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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.