Tag Archives: OLAP

SAS OLAP Server Names

By | October 5, 2009

SAS OLAP Server names for cubes, dimensions, hierarchies, measures, and member properties follow these general rules: can be up to 32 characters in length can contain embedded blanks If the name has embedded blanks or characters other than letters of the Latin alphabet, numbers, or underscores, then PROC OLAP formats the name as a name… Read More »

SAS Information Map Studio 3.1 Truncates OLAP Measure Names

By | March 12, 2009

I created some nice data cubes using SAS Data Integration Studio recently.  I had a local, regional, and state-level hierarchy for my geographical dimension as well as a monthly, quarterly, and annual hierarchy for my time dimension.  I had eight measures which were vital for assessing where the organization was through time.  I added drill-through… Read More »

OLAP Tips from a SAS e-Learning Class

By | February 26, 2009

I recently took the opportunity to sit through a SAS e-Learning course titled Creating OLAP Cubes.  It was a pretty detailed walkthrough for individuals creating OLAP cubes using SAS OLAP Cube Studio or Data Integration Studio.  Dimensions, levels, and hierarchies were described thoroughly, but measures were inadequately addressed.  Overall, it was a fine course for… Read More »