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…
Tag: Information Map Studio
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 […]
Peek Inside SAS BI Book: Building Business Intelligence with SAS
You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write this book, one of the first things we discussed was how new users get access to the SAS BI toolset and have no idea of its astonishing capabilities. This book guides you through each one so you understand it. Intermediate and advanced users will also find this book as a valuable reference. Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique. This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component with step-by-step examples along with hundreds of tips and techniques to make you successful! SAS Institute offers over nine SAS BI courses to cover all the topics we have jammed packed into this book. Making this an excellent study guide for those planning to take the SAS BI Content Development Exam. Your SAS […]
Using a prompted filter as a general prefilter in SAS® Information Map Studio
Using a prompted filter as a general prefilter in SAS® Information Map Studio
SAS Info Map: Change Source Table Names from Klingonese to English
I love the way some data tables get named. After a while you begin to learn the patterns – but geez sometimes I think a true alien was involved. The names are cryptic and when the tables are…
[[ This is a content summary only. Visit my web…
SAS Info Map: Change Source Table Names from Klingonese to English
I love the way some data tables get named. After a while you begin to learn the patterns – but geez sometimes I think a true alien was involved. The names are cryptic and when the tables are…
[[ This is a content summary only. Visit my web…