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

Information Maps: Quick Tips for Your Data Items

Submitted by on 2012-12-26 – 1:02 PM

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, a recent customer wanted the same 25 measures used in over 20 different data tables – the only thing that changed was the category.  So sometimes it was broken out by region, sometimes by management chain, and so on.

To save time, we ordered the data items in the information map so when the table was created in Web Report Studio – the  measures were already in the correct order.  Here’s an example of what I’m describing:

Quick Tip #2: Make Your Filters and Prompts Clear

Name your filters and prompts so the report builders can easily determine what kind of filter it is in Web Report Studio.

 

 

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.

Tags: , ,