Business Intelligence Notes for SAS BI Users | Business Intelligence Notes for SAS® BI Users | Providing tips, tricks and other resources for SAS® Business Intelligence Users

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

May 7, 2012

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...
Read More »

SAS OLAP Cubes: Taking Advantage of OLAP Member Properties

By Steve Overton

May 2, 2012

Have you ever had a requirement to display additional details about data in a report but couldn’t find a good way to do so? Showing OLAP Member Properties in a SAS Web Report could be a useful way to sneak more details about data into a crosstab table. Crossing Multiple Dimensions with High Cardinality Creates Data Headaches I recently ran into a data challenge with a large OLAP cube (NWAY of about 12 million records) where I needed to summarize a simple count by a “group ID” crossed with a “group name” crossed with another insignificant dimension. There were a...
Read More »

Excel and OLAP Viewer: Not enough room for the Cube!

By Tricia Aanderud

February 29, 2012

Excel and OLAP Viewer: Not enough room for the Cube!

When you use the OLAP Viewer in Microsoft Excel you may have run into the window borders – literally. Your cube and analysis needs more space! Scroll, Scroll, and Scroll to See the Cube Data When you open the OLAP cube in the MS Excel OLAP Viewer the default cube size dictates the area used. You may get 20 rows by 20 columns or you might get 2 rows by 2 columns. So when you want to do some analysis, you expand a dimension and scroll, scroll this way and then scroll, scroll that way to see the...
Read More »

SAS Stored Processes: 3 Tips to Improve Your Prompts

By Tricia Aanderud

May 16, 2012

SAS stored processes are similar to SAS programs in that they use the same programming language. Many of my SAS programs I created early on were only used by me, so I could live with a little uncertainty and it was easy enough to check the logs for any...
Read More »

Stored Processes: 3 Ways to Edit a Stored Process

By Tricia Aanderud

May 4, 2012

Some may not realize that you can edit a SAS Stored Process in multiple ways (depending on your permissions). Today I show you three different ways to reach the stored process code. By the way, I’m using SAS Enterprise Guide 4.3 and SAS Management Console 9.3 – so your...
Read More »

Peek Inside: The 50 Keys to Learning SAS Stored Processes Book Available!

By Tricia Aanderud

April 15, 2012

In the midst of writing our first book, Angela and I argued over the stored process chapter content. After we wrote the chapter outline, we then wrote the outline for this book. The first title was the 25 Best Tips for Writing Stored Processes. Our idea for the tips, which...
Read More »