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.
After another successful ClearPeaks Academy training in Zurich, Switzerland, we would like to share with you our experiences and some feedback from the training itself.This training workshop covered Oracle 11g Advanced topics where Sergi Guiñon, a ClearPeaks BI consultant, introduced the technology and delved deeper by sharing his real world experiences and by giving the attendees the opportunity to have hands-on practice with it. The attendees enjoyed the combination of the theory and practical lab examples, the competency of the course and the material along with the overall assistance and knowledge of the trainer.
Dynamically changing the information displayed in a dashboard should be one major objective for the developers. This flexibility reduces the number of requests to be developed and increases the user experience.A common way of achieving this flexibility is by using the Column Selector view. This view allows the user to select a subject area column dynamically and to get results based on that selection (e.g. Revenue by Year/Region/Product).The ChallengeUnfortunately, using the Column Selector view has some limitation. An important one is that every time a new subject column is selected, a new query is executed to refresh the data. So in the case that we need to change multiple columns, we will be executing multiple intermediate useless queries.In this blog article we will show a way of simulating the Column Selector view when we need to change multiple columns in a report.The ScenarioThe requirement is to be able to switch between two reports that differ only in some columns (in this case, a set of measures). The user does not want to have them in separate Dashboard Pages but in one single dashboard page, displaying one report or the other based on a “Measure Selector”.