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 Author

Articles by Steve Overton

Steve Overton works for Zencos Consulting.

Best Practices: Letting SAS Enterprise Guide Write MDX Code

2012-01-04 – 8:00 AM
MDX Editor

SAS Enterprise Guide is a VERY useful client tool for SAS development and data analysis.  One the best features is the ability to see the SAS code generated from different tasks.  In addition to viewing the Base SAS code used to perform different tasks, you can also view MDX code written to create certain measures, members, and sets in OLAP Cubes.
Adding Simple Measures from SAS …

Best Practices: To Write or Not to Write PROC OLAP… That is the Question

2011-12-28 – 7:00 AM
SAS OLAP CODE

There are 2 ways to develop OLAP cubes in the SAS EBI platform: using SAS OLAP Cube Studio or by writing the PROC OLAP statement by hand and submitting the SAS program.  There are pros and cons for both that I will go through in this post.  Personally I prefer writing the PROC OLAP statement(s) myself but I will use SAS OLAP Cube Studio from …

SAS OLAP Cubes: Tailing Time-Based Data for Dynamic Results

2011-12-07 – 6:43 AM
Information Map Contents

SAS OLAP Cubes are a great way to quickly aggregate and summarize data that can be used in the other SAS Business Intelligence tools.  Learn more about creating relative time based dimensions today.
Adding Relative Time Dimensions to OLAP Cubes
Dimensions and measures are the two major components of a cube.  To effectively report time-based data from a cube, it is beneficial to report measures using relative …

SAS OLAP Cubes: Percent of Total MDX Calculation

2011-12-06 – 7:00 AM
Example Output

MDX is a powerful tool for building custom calculations in SAS OLAP cubes.  Here is a good example of computing the percent of total for a given measure and given hierarchy in a dimension.  This code is written as part of the PROC OLAP procedure.
DEFINE Member “[SGF].[Measures].[Percent of Total Sales]” AS
‘(
  [Product].[Product].CurrentMember, [Measures].[SalesSum])/
  if(([Product].[Product].CurrentMember.Parent
       , [Measures].[SalesSum]) = 0
  OR   ([Product].[Product].CurrentMember.Parent
    …

SAS OLAP Cubes: Tips for Building OLAP Cube Aggregations Effectively

2011-11-30 – 7:00 AM
sas bi olap cube code

 
As promised, this is a guest post by Steve Overton, who was one of the external reviewers on the Building Business Intelligence with SAS.  Steve works as a SAS BI consultant in the Raleigh-Durham, NC area and is sharing some of his SAS OLAP Cube wizardry with us today!

Building OLAP Cube Aggregations Effectively
Let me start by saying that I follow a general practice of building …