| 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.
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 member properties 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.
| This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post. |