OLAP

[Grandhi4]

Hi All,

What is the difference between ROLAP, HOLP, MOLAP ?

And is there any option for 'Automatic refresh' for OLAP CUBE.

Thanks,

Suresh

[TomKari]

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

[lacrefa]

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