SAS OLAP Cube Aggregations Storage

Reply
Contributor
Posts: 33

SAS OLAP Cube Aggregations Storage

Hi,

I have a questions regarding different storage options available for Cube Aggregations.

I want to know whether we have to specify the Agggregation form as MOLAP / ROLAP / HOLAP in  OLPA Cube wizard or SAS by itself decides the storage form based on the way Cube is built.

Like:

if we specify some Aggregations in Aggregation dialog box  and no NWAY Aggregation then it is HOLAP.

if both Aggregations and NWAY Aggregation is specified then  MOLAP

and if none of then is mentioned then ROLAP.

Can someone through some light on how storage mechanism is decided by SAS OLAP Server?

Regards,

Vishal

Super User
Posts: 5,441

Re: SAS OLAP Cube Aggregations Storage

Posted in reply to vishal_prof_gmail_com

I think this explains the general concepts in necessary detail:

SAS(R) 9.4 OLAP Server: User's Guide, Second Edition

Data never sleeps
Contributor
Posts: 33

Re: SAS OLAP Cube Aggregations Storage

Hi ,

Thanks for the comment.  I had actually gone through the document , it very clearly explains the concepts of different storage however how do we specify the storage options is still missing. Is it a part of Cube designing process or is it interpreted by the OLAP server from the cube design ?

Vishal

Super User
Posts: 5,441

Re: SAS OLAP Cube Aggregations Storage

Posted in reply to vishal_prof_gmail_com
Ask a Question
Discussion stats
  • 3 replies
  • 199 views
  • 3 likes
  • 2 in conversation