topic OLAP in SAS Programming

OLAP

Grandhi4 — Sun, 26 Aug 2012 11:54:10 GMT

Hi All,

What is the difference between ROLAP, HOLP, MOLAP ?

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

Thanks,

Suresh

Re: OLAP

TomKari — Sun, 26 Aug 2012 15:08:48 GMT

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

Re: OLAP

lacrefa — Mon, 27 Aug 2012 11:45:53 GMT

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