SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide
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.
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.
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.
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.
Latest posts by Steve Overton (see all)
- BulkLoading with PostgreSQL available in SAS 9.4 - 2013-10-22
- Everything Still Starts and Ends with Data in SAS Visual Analytics - 2013-07-30
- Describe Your Table in SAS to Write the SQL Code - 2013-05-22
- Update Table Metadata Using Base SAS Code - 2012-12-19
- SAS Administration: Fetch Data Faster across ODBC - 2012-11-01