OLAP cubes are great for summarizing data very fast – I love them . In certain environments, HIPAA compliance for personally identifiable data might be a concern. Even at the lowest grain of a cube it might be possible to identify the specific detail data beneath the surface if the summarized number is small...
Read More »
If you have never worked with OLAP code – then you might be curious how it works and what it looks like. Some developers use SAS OLAP Cube Studio to start their cube building process since it saves some of the typing required. Let’s review some of the code. [Adv Users: check out Steve's...
Read More »
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...
Read More »
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...
Read More »
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 “..” AS ‘( ...
Read More »
Building Business Intelligence Using SAS Book SAS Business Intelligence (BI) package provides an interface for multiple audiences to dissect, discover, and decide on what the data means to their organization. This book shows you the SAS business intelligence capabilities, features, and contains the most sought after tips and tricks to bring a novice user up...
Read More »
