SAS recommends building OLAP Cubes on a separate ‘non-production schemas’ because cube building can be resource intensive and time consuming. Each OLAP Server can be defined to one & only schema at a given time, therefore you will need to setup the…
Tag: OLAP
Special Request for Star Schema OLAP Cubes
When creating an OLAP Cube from a Star Schema table, the Dimensions / Hierarchies created must be free of all blanks. This is because the name is used as a table alias in the SQL Join.
The obvious error in the resulting code example below:
proc sql; c…
Creating a Relational OLAP Cube (ROLAP)
SAS allows for three different cube storage mechanisms:
1. MOLAP
The traditional SAS OLAP Cube will all aggregations / nway stored on a physical file structure accessible by the SAS OLAP Cube Server.
2. ROLAP
A relational OLAP cube – where no aggregati…