Last week, ClearPeaks held their Academy training session on Advanced OBI EE 11g in Saudi Arabia. The attendees of the course varied from Applications Consultants, Senior Developers, Technical Consultants to BI Analysts who were trained by, Sergi Guiñon, a Consultant at ClearPeaks bringing with him hands-on knowledge and experience on real world issues.The attendees of the course were taught the features on BI with a special focus on the advanced features of 11g. The training topics were covered through the course material and hands-on lab work, which gave the attendees the opportunity to learn and experience the technology on their own by installing, administering and developing the BI tool. The feedback was positive including comments such as useful knowledge gained and further interest into more in-depth knowledge and lab work, interest in further technical knowledge and a great first impression to the new Oracle solution. The trainees will take with them the skills and techniques to perform BI projects in their company.Have a look at the feedback provided by the training attendees:
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”.