Articles by Steve Overton
Steve Overton works for Zencos Consulting.
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 …
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 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 …
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
, [Measures].[SalesSum]) = 0
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 …