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, General

SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide

Submitted by on 2012-05-07 – 7:06 AM

As a follow-up to my earlier post on taking advantage of OLAP member properties, you can also display OLAP member properties through the Add-in for Microsoft Office as well as SAS Enterprise Guide.  I’m a huge fan of Enterprise Guide, so it’s nice to have that ability but even nicer when the more common information consumer can display member properties through a Pivot Table in Excel.

One Click to More Information

In Excel, when you have the SAS Add-In for Microsoft Office installed you can quickly add more information. Simply right-click the level and select Show Properties in Report.  From there you can check the properties you have defined. In this example I added Gross Margin and Retail Price.

Enable Member Properties in Excel PivotTable

I like the way the Pivot Table displays member properties as each column in Excel.  This information gives the user a little more insight into the data.

Showing OLAP Member Properties in Excel

Also Works in SAS Enterprise Guide

To display member properties through SAS Enterprise Guide the approach is similar, right-click the level and select Show Member Property. From there you can check the ones you want to display.

 Display OLAP Member Properties in Enterprise Guide

More about OLAP Member Properties

Check out my earlier post to see how these same OLAP member properties are defined and displayed in SAS Web Report Studio.

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.

Tags: , ,