BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Tags

Articles tagged with: Creating Effective Reports

Web Report Studio: I need a better date than this one …

2011-10-24 – 7:00 AM
481_WRS_006_format result

In SAS Web Report Studio, I was trying to create a bar chart that showed the total payments by month. However, the Payment Date was the actual date the company received the payment and as a result the chart had a “play-by-play” action instead of overall results.  Turns out that October 16th was a big payment day as you can see below. …

Web Report Studio: Who stole my pie (chart)?

2011-09-27 – 5:00 AM
411_WRS_pie chart ex 5

Ok – I”ll just say it.  I hate pie charts.  If there are more than a few categories – then the user has to interpret the ranking order, it slows them down, and they may loose interest in the report that you so lovingly prepared.  Maybe you say – “Tricia, add the numbers! Geez – you’re so dramatic!”  Then I will calmly reply to your dramatic outburst, …

Web Report Studio: Chops off the columns and rows …

2011-09-22 – 3:00 AM
WRS_02_ugly reports_part2

Do you get a little frustrated by not having all the screen real estate you want when displaying your report?  There may be times when you have 13 columns you want to display.  The following figure shows an example report where I extended the columns.  Before it showed the navigation bar at the top of the report – but I wanted the viewer to see …

Ugly Web Report Studio Reports?

2011-09-21 – 1:00 AM
WRS_05_ugly reports

If you only use the default settings when building Web Report Studio report, the results may not be very attractive.   For instance in the following report the graphs are different sizes and the spacing between them is awkward.

To change the image size, you have to change the settings in the Image Properties.

Right-click the graph and select Properties from the pop-up menu.

Change …

Building Business Intelligence Using SAS Book

2011-09-01 – 10:24 AM
SAS BI Book Reviewer Comments

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 to speed quickly!
SAS BI Book Overview
Each chapter highlights a specific SAS business …