Tag: Information Map Studio

Information Maps: Quick Tips for Your Data Items

Here’s a few quick tips to use when creating information maps that are used with Web Report Studio. Tip #1: Order Data Items How They Are Displayed You may not always know how data items are used in the reports, but sometimes you do! For instance…

Web Report Studio: Update Resources to Fix Your Report

Is there a worse way to start your day than someone calling to tell you that your marvelous Web Report Studio report is not working? Yes, this means the world is being denied a viewing of your stunning visual design efforts about last quarter’s s…

Web Report Studio: Adding Drill-Down Filter Based on a Date

When I was creating the Summary and Detailed reports for the SAS Global Forum paper, I was demonstrating how to link from the weekly chart to the detailed report about the week.  On my first try with my Week Filter based on the date value – it just would not work.  Eeek!  To fix the problem I made a new data item that was a character value.  This posts talks about my strategy.  [You can read our paper “Get Your Fast Pass to Building Business Intelligence with SAS and Google Analytics”.  The presentation goes into more detail, but here’s some past articles about Google Analytics. ] What Should Happen When you click on the bar that represents the week – you actually drill-down to the Weekly Detailed report. You cannot use a date value as this filter – you must use a character based filter for this prompt.  If you need help setting up the filter or creating the link – just refer to the  ”Get Your Fast Pass to Building Business Intelligence with SAS and Google Analytics” paper. Creating the Proper Filter in the Information Map First you need to create a data item based on the date variable.  I used a CASE statement to test if the week was […]

What Can I Do With a Stored Process?

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 Web Report Studio and Linking to a Stored Process from Web Report Studio. Add-In for MS Office – View Reports or Data Use the stored process to deliver a report or maybe just a dataset (using Proc Print) to the Add-In for Microsoft Office (AMO). In the past, I set up several stored processes that only contained a PROC PRINT to display a data set. Then I added a prompt for Product, which allowed the user to query product inquiries based on the product of interest. Here’s how you access the stored process from AMO 4.3. This works similarly in prior versions of AMO. Open MS Excel (or Word/PowerPoint). On the SAS ribbon, click the Reports icon. Navigate to the stored processes storage location and click the stored process name. < Optional> This stored process has two prompts: Visitor Type and ODS Style. Your stored process […]