Using Sliding Averages in MDX

multiple-avg

When looking at time series that exhibit strong deviations, it is sometimes hard to get the general picture of the development. A practical approach is to smooth out the values by calculating a sliding average. To illustrate, I’d like to look at the example cube from the article about date dimensions, and select the sales per . . . → Read More: Using Sliding Averages in MDX

Creating Top-N Reports using MDX

top_5_and_others

Many organizations have the requirement to monitor the best performing assets. These might be top selling salespeople, products, stores or even days. It often necessary to also aggregate the remaining assets into a single entry representing all other assets, effectively creating an entry to represent the performance of all “others”. This post shows how this is . . . → Read More: Creating Top-N Reports using MDX

A Simple Date Dimension for Mondrian Cubes

cube

Date dimensions are among the most important dimensions of many Mondrian cubes. The usefulness of a cube often depends on the way the date dimension has been modeled. This post shows how to create a basic date dimension and how it can be augmented with properties to suit specific analysis needs. If at some point you . . . → Read More: A Simple Date Dimension for Mondrian Cubes

Using Named Sets in Mondrian

When working with Mondrian cubes I often find myself wanting to look at a time series chart. Say I want to look at some KPIs’ development in the last 60 days. So I write an MDX query that dynamically determines the last 60 days and selects them together with the KPIs to produce the chart. Most . . . → Read More: Using Named Sets in Mondrian