BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

OLAP Cube Studio: Looking at PROC OLAP Code

Submitted by on 2012-03-05 – 7:00 AM

If you have never worked with OLAP code – then you might be curious how it works and what it looks like. Some developers use SAS OLAP Cube Studio to start their cube building process since it saves some of the typing required. Let’s review some of the code. [Adv Users: check out Steve’s posts about OLAP Code]

Exporting PROC OLAP Code

There are two methods to export your cube to a SAS program from SAS OLAP Cube Studio.

  • Use Method 1 after you have added custom measurements. Click cube name > Export Code. The Export Code window appears.
  • Use Method 2 after you have completed the Cube Designer wizard. Click the Export Code button. The Export Code window appears.

From the Export Code window you can select if you want standard (long) OLAP procedure code or the shorten code. Either way – just add the path and program name. [More at SAS Support about when to use short/long form. ]

Under the Hood

After opening the program in Enterprise Guide, you see how the OLAP procedure code appears. You can learn to code your own cubes, just by reviewing how the OLAP wizard wrote the code. For instance, this shows how the Segmentation Dimension appears in OLAP Cube Designer and how the code looks.

There is a Dimension > Hierarchy > Levels. You can see code has a statement for each of those and indicates the members – just as shown in the GUI.


Here’s how the Measure statement looks. You can see how the default measure is declared. Also I highlighted where the BouncesSum and BouncesAvg measures are defined. [Learn more about writing PROC OLAP in SAS 9.2.] 

In this example, the MDX code was created by using select cube name > Maintain > Calculated Members. This callout shows how the MDX looks. To learn more about writing MDX code, see these entries or refer to the SAS 9.2 OLAP Server: MDX User Guide. Also check out Steve’s post about Letting SAS EG write your MDX code.


Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.
Spread the love


No Comment »

1 Pingbacks »

  • Use SAS Enterprise Guide to quickly understand a new data set | Best Analytics says:

    […] of writing code’ example? I know my co-author Tricia Aanderud posted a note this week about generating PROC OLAP code. What trick do you […]