July 18th, 2011.
Axel
Sometimes because of the nature of the data in our system we need to have different types of aggregations (sum, max, last…) for one single measure. Therefore the aggregation type needs to be different depending on the dimensions (Date, Product…).
One clear example of this is in dealing with stocks. Stocks have different kinds of aggregations depending on how you look at it.
The aim of this article is to know how to deal with these different aggregation level measures and implementing a solution in the OBI repository to solve the issues that those measures bring.
Continue reading this post >
September 29th, 2010.
Axel
An effective way of measuring any business process is to compare its performance during two periods of time. This comparison reveals the effectiveness of the decisions made during the second period. Therefore the results of that comparison are key to justify and support the decisions made.
This article describes the steps needed to build a dashboard showing the average order amount for the last months. The actual number of months will be chosen by the user when refreshing the dashboard.
Continue reading this post >
May 12th, 2010.
Axel
When reviewing sales data, sometimes there is a need to show not only the data that exists, but also the data that does not exist. For instance, in the tables below we can see that no revenue was generated in the month of April and also that no revenue was generated from customer JKL between January and June.
Continue reading this post >
