Tag: OLAP

Moving OLAP Cubes (Part 1 – It’s all between the schemas)

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…

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…