Aggregation Based on Dimensions

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.