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 » BI Tools

Web Report Studio: Recognize these 2 Gotchas?

Submitted by on 2012-07-23 – 7:56 AM 2 Comments

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 a Web Report Studio and she  noticed the change still was not made days later.  Shri inquired and the co-worker told her she had made the change several times but the application would not save the changes. This sounded odd and frustrating! She observed the change being made and this is how the Gotcha was discovered! When using an application like MS Excel or MS Word, when you exit the application a sanity check window appears asking if you want to keep the changes.  However, the Web Report Studio sanity check explains you are discarding the changes.  So – read closely or fail victim to the GOTCHA!

To save the changes to the report, use the File > Save menu choice or click the Save icon.

web report studio and excel sanity checks

Gotcha 2: Why Can’t I Create or Remove a Rank? 

This gotcha comes from Brent Whitesel, who supports a SAS BI team for his company.  Recently a user complained that he could not edit an existing rank to a report object.  Upon opening the report, Brent found the cause.  Here’s some background first – the way the permissions are setup for this report, you must have permission to see the sensitive data, thus if the user does not have the proper permission, then only the Edit mode is available.

However, notice what the window says when you attempt to create a rank rule in Edit mode – it reminds you that it can only create a rank when in View mode.  You cannot do it from Edit mode!

 

See – when you are in View mode you can easily create a filter or rank!  However, you may also need permissions to do so based on how your SAS Administrator has the site setup.

 

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

    

 

 

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.
Spread the love

Tags: ,

2 Comments »

  • I suppose you found this out the hard way! 🙂

  • Another “Gotcha” users may want to keep in mind in WRS comes in to play when working with OLAP cube data. If a user drills through various levels of the report hirarchies they will not be able filter the drilled dimension while report is is that drill state.

    Return your dimension to its highest level and the ability to filter will be restored!