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: Web Report Studio

Web Report Studio: Changing a Style to Your Colors

2012-07-25 – 8:00 AM
Web Report Studio Changing the bar colors

On a recent project, we needed to change the colors of the bars to match the customer’s website style.  I had heard this was a daunting task requiring lots of white magic and prayer. Turns out what is difficult is if you want to completely re-do a style but it’s fairly simple if you just want to make a few changes.
Changing the Style Color 
First my …

Web Report Studio: Recognize these 2 Gotchas?

2012-07-23 – 7:56 AM
wrs_gotcha_02a_rank_will_not_set

If you aren’t paying close attention to the messages in Web Report Studio, you may run into some puzzling issues.  The messages that SAS produces may not be obvious enough if you are expecting a different behavior, thus making troubleshooting a bit difficult.
Gotcha 1: Why Won’t My Changes Save?
This reminder comes from Shri Sastry.  She had asked a co-worker to make a simple change to …

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

2012-05-21 – 8:04 AM
Linked Reports

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. …

SAS OLAP Cubes: Taking Advantage of OLAP Member Properties

2012-05-02 – 6:30 AM
Select Member Properties

Have you ever had a requirement to display additional details about data in a report but couldn’t find a good way to do so?  Showing OLAP Member Properties in a SAS Web Report could be a useful way to sneak more details about data into a crosstab table.
Crossing Multiple Dimensions with High Cardinality Creates Data Headaches
I recently ran into a data challenge with a large OLAP …

Web Report Studio: Adding a Confidentiality Disclaimer

2012-04-26 – 8:09 AM
Disclaimer Message

Adding disclaimers to SAS Web Report Studio tables and graphs is sometimes necessary for confidentiality purposes.  You can do this easily by using the Configuration Manager available in SAS Management Console 9.2 and up.  This is shown to the right.
 
Adding a Table Disclaimer Through SAS Management Console
SAS Support provides official documentation for adding disclaimers in SAS 9.3 as well as SAS 9.2.  To add the …