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 [...]
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 [...]
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 [...]
