Tag: BI Tools

Using an Autocall Macro Library in SAS BI

Macro Library

Author:

 a SAS programmer, I am dependent on my SAS autocall macro library.  It stores a bunch of utility macros that I use on a daily basis. When I started learning about stored processes and other BI tools, one of my first thoughts was “How can I access all of my …

Post Using an Autocall Macro Library in SAS BI appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

Web Report Studio: Switch Report Sections to Tabs in Snap!

web report studio tabs management console

One of my gripes with Web Report Studio is that it is not always obvious that a report contains more sections. When demonstrating a report with …

The post Web Report Studio: Switch Report Sections to Tabs in Snap! appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

Quick Tip for Using OLAP Cube Results in the Your Stored Process

Stored processes with OLAP Cubes

Sometimes the data you want for your stored process is already neatly located and summarized – but it is in an OLAP cube.  While you can probably recreate the data with some of your fancy coding, it does take time, testing and later creates maintenance issues.  If the data you …

The post Quick Tip for Using OLAP Cube Results in the Your Stored Process appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

SAS Stored Processes: Querying a Stored Process from Excel without the Add-In

Stig Eide

What do I have in common with a guy in Norway?  Well, if you look at my last name Aanderud – you might think he is a family member.  Turns out Stig Eide and I both use SAS Stored Processes to solve issues!  Recently this SAS platform administrator asked if he …

The post SAS Stored Processes: Querying a Stored Process from Excel without the Add-In appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

Don’t worry about Your Web Report Studio Style When Including a Stored Process

Web Report Studio Style Change

When you need to add or link a stored process  to your Web Report Studio report, you might be worried that it will not look the same.  For instance – here’s a simple stored process that I created where I declare the style as Banker.  [You can also use a SAS supplied …

The post Don’t worry about Your Web Report Studio Style When Including a Stored Process appeared first on Business Intelligence Notes for SAS® BI Users. Written by .