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

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.

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

Simply right-click the level and select Show Properties in Report.  From there you can check the properties you have defined.

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

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.

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

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 member properties you want to display.

 enable in eg SAS OLAP Cubes: Viewing Member Properties in Excel and 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.

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.