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...
Read More »
To pick the winners of the 50 Keys to Learning SAS Stored Processes book, my first thought was to print the list and then put everyone’s name in a hat. Angela brilliantly suggested that we use one of the SAS Random functions. However, since there was a list of names I really needed a...
Read More »
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...
Read More »
Often I refer to SAS Stored Processes as the workhorse of the SAS BI tools … you can use these little devils everywhere sometimes as Band-Aid, sometimes as the star, and sometimes as a background player. In a past post, I showed you how to use a stored process to add dashboard dials to...
Read More »
If you use SAS Add-In to Microsoft Office – specifically Excel, then you already know how awesome it is to link to the SAS data on the server. First, if you are using data that needs to be refreshed – just a click of the button brings you the new rows and your report...
Read More »
SAS OLAP Cubes are a great way to quickly aggregate and summarize data that can be used in the other SAS Business Intelligence tools. Learn more about creating relative time based dimensions today. Adding Relative Time Dimensions to OLAP Cubes Dimensions and measures are the two major components of a cube. To effectively report...
Read More »
Recently while setting up a report in SAS Add-In for Microsoft Excel, I was going to create a graph using an information map. When trying to assign the chart values, I realized I had several very confusing variable names. When the information map was created, I know I had everything neat looking due to...
Read More »
Building Business Intelligence Using SAS Book SAS Business Intelligence (BI) package provides an interface for multiple audiences to dissect, discover, and decide on what the data means to their organization. This book shows you the SAS business intelligence capabilities, features, and contains the most sought after tips and tricks to bring a novice user up...
Read More »
