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: SAS Information Maps

SAS Info Map: I want an Average not a Sum!

2011-09-14 – 3:00 AM
sas web report studio data item aggregations

In SAS Information Map Studio, you can easily set the default measure for a data item in the Properties area.  This advise will not apply to information maps based on a SAS OLAP Cube.
 Change your Data Item Aggregation Defaults
(1)  Use the Default aggregate function drop-down to select the default.  When you set this item to AVERAGE, the data item defaults to Average in SAS Web …

SAS Information Map Studio: Why does the data item show as scientific notation?

2011-09-08 – 1:00 PM
imap_set default value

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.

When the data item was imported, the default aggregation method was SUM, which does not work in this …

SAS Business Intelligence Tools Overview

2011-09-07 – 6:00 AM
Building BI Using SAS Book Cover

SAS Enterprise Business Intelligence (BI)  is a suite of applications that allows you to prepare and display data.  Here is a quick overview to help you learn the SAS BI product names and purposes. 

 
Prepare Data
Your data may be in a relational database (Oracle, Teradata, MySQL, etc).  The data is then placed in OLAP cubes, information maps, or in some cases a SAS dataset so it …

SAS BI: Sample Data Sources

2011-09-06 – 2:00 AM

As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore.  Here is a list of free sources that I have found that can help as you learn and want to challenge yourself.
Simple Data Tables
Here are some sources for simple data tables.  These are datasets with all of the data contained …