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: Why does the data item show as scientific notation?

Submitted by on 2011-09-08 – 1:00 PM

When a data item is created in SAS Information Map Studio, the defaults are assigned for classifications and aggregations.  If the data item is a percentage, this defaults may not make sense.  For instance, the following figure shows the Gross Margin in scientific notation instead of a percentage.

sas bi information map studio

When the data item was imported, the default aggregation method was SUM, which does not work in this case.  The gross margin is your profit from this sale and it should remain constant or in other words.

So how do you fix it?

You need to change the default measurement for the data item. For a value like Gross Margin, there is not reason to aggregate this data item – when is a sum of all Gross Margins for a customer or product used?

For this item, the gross margin is associated with the Product data item.  Any product no matter to which customer in any region, the gross margin remains constant.  You have to select a default aggregation method, so I chose Average.  I thought it would make the most sense to the end user.  I could have also used Minimum.  In the following figure, minimum would have set the value to 70% for the non-aggregated figure.


sas bi information map 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.
Spread the love

Tags: , ,

No Comment »

1 Pingbacks »