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

SAS Information Map Studio: Data items with same name

Submitted by on 2011-11-09 – 7:00 AM

In SAS Information Map Studio, you may notice that some data items have similar names with a numeric after the name. When you use the data items from various tables they may use similar names. When you add the variables to the information map, SAS adds a number to the duplicate name.  It can be difficult for the end user to understand what the data contains.  

Solve Your Information Map Issues!

For example, in the following figure – in the Before side – addressline1 can be the Customer address or it can be the Regional office address. This is going to be confusing to an end user – actually it confuses me!

sas bi information map studio 1

 

Use Folders to Assist with Organization

If you use folders to organize your data items, the users can quickly determine the data source  to build their report.  To add the folders, do this:

  1. Right click the information map name and select New Folder from the pop-up menu.
  2. Type the folder name.
  3. Drag and drop the items you want into the folder.

Hint: It is easier to create the folders before adding any data item to the map.  Then drag and items from the Selected Resources panel into the desired folders.

sas bi information map studio add folders

 

 

 

 

 

 

 

 

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: ,