Posts tagged ‘OLAP’

Divide and Conquer OLAP Cubes with High Volumes of Data

Zencos will also be presenting a paper at SAS Global Form this year on best practices for loading OLAP cubes with high volumes of data. Stephen Overton will be presenting paper number 431-2012 Monday April 23 at 3pm.

High volumes of data can be summarized most efficiently using OLAP technology. As volumes of data approach the …

Effective BI Reporting at SAS Global Form 2012

Information Path

Zencos will also be presenting another paper at SAS Global Forum this year on best practices for developing a guided-analysis using SAS Web Report Studio. Stephen Overton will be presenting paper number 020-2012 Monday April 23 at 11:30am.

The paper will be about ways to use the SAS Enterprise business intelligence platform to consume business information. …

Using the MDX Editor in SAS Enterprise Guide

Video tutorial on how to create a SAS Process that exploits data out of an OLAP cube without have to write MDX code from scratch using the MDX editor.

Creating Custom OLAP Measures

OLAP Cubes are powerful tools when dealing with large data volumes.  I frequently find the need to create custom measures to meet specific business needs.  Many times their is a need to aggregate non standard data, some of which are simple and others that are complex.   Here are a couple examples:

Net Profit = (Revenue – Expenses)
Revenue in Millions …

Test Feature Functionality Before Deploying Changes

Being a longtime SAS programmer; I’ve had extensive experience with the software platform but have just started using version 9.2, specifically the Business Intelligence suite.   I was anxious and excited to learn about new features and the software’s empowering and more stabilized capabilities.

My learning curve began during the design and development phase of a recent …