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

SAS OLAP Cube Studio 9.3: New screen layouts

Submitted by on 2012-11-02 – 7:40 AM 6 Comments

I installed the updated SAS Business Intelligence package (version 9.3), but mostly I have been playing with the stored process interface where there were some major changes (more about that in future posts).  This morning I opened SAS OLAP Cube Studio to create a sample cube and the screen layouts have changed. I like the new layouts and think it is more intuitive than before. In the upcoming Building Business Intelligence with SAS book, OLAP cube theory, creation and maintenance are discussed in a more detail. [Sign up to have SAS Press send you an email when it’s ready!] 

For this post, I just wanted to walk your through the SAS OLAP Cube Wizard 9.3 screens so you can see how the process has changed. If you have never seen this product, then you can see how easy it is to create a cube. Many developers use the wizard for the initial cube setup and then export the cube code to SAS Enterprise Guide where they can update and control the PROC OLAP code more.

Note: Click on any picture for a closer look at it.

Wizard – Step 1 Start the Cube Building or Editing Process

Nothing major changed on this screen just wanted to provide a little context for where I am in the process. 
I’m using the SAS OLAP Wizard to help me build a cube from the sample CANDY data set.


sas bi olap cube studio step 1

Wizard – Step 2 Select the Data Sources

 This use to be 2 different screens.  Now you can set the Base and Drill-through tables from the same screen.
Makes it a little easier to understand and I appreciate that it is more compact.

sas bi olap cube studio step 2

 Wizard – Step 3 Build the Dimensions

There were not any major layout changes in this area.  This screen is just for context.

sas bi olap cube studio step 2a

 

 

 

Wizard – Step 4 Select the Measures

This was two different screen before.  Again, this layout gives you more control on a single screen. You can select the measure and change the measure names.

sas bi olap cube studio step 3

 

If you need to make some changes to the label name, just click the button to increase the screen size.

 sas bi olap cube studio step 3a

 

Wizard – Step 5 Taaa-Dah! Build Your Cube

And we’re done!  The pop-up asking what you want to do is an improvement. It’s more clear what you need to do as the next step.

sas bi olap cube studio step 4

 

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.

Tags: ,

6 Comments »

  • I don’t know of any free resources for SAS BI. I believe most new people learn at school, through SAS coursework, or through their employer. SAS BI toolset it intended for an enterprise installation and dependent on many circumstances so I cannot quote a reliable price. I can say it’s much more than $10000.

  • Debojyoti Sinha says:

    Thanks for your reply tricia.
    Could you please help me out with the approximate cost of SAS BI software?
    Is it not freely accessible from the net for learners?

  • Contact the SAS Institute and a sales representative can assist you in getting a license for the SAS EBI software. The SAS BI book is available from the SAS Press bookstore as an e-book.

  • Debojyoti Sinha says:

    Hi Tricia,
    It will be very kind of you if you can send me the link to download SAS/BI software and a SAS/BI pdf. I am trying to learn the software by my own.

  • Tricia says:

    Oh .. good question.

    Let me find out. I may not have access to the tools that I need. More on this later.

  • Harsh Gajjar says:

    Really helpful when explaing the clients the difference between SAS OLAP Cube studio 9.2 and 9.3. Really helpful..

    One Personal request . I’m really eager to know how once can use GIS Maps in this OLAP cube studio