OBIEE with Key / Name / Value table, the Union solution A customer asked me to create an analysis on top of a Name - Value table. A table where instead of having one row for each key, there are multiple rows with the structure of...
Read MoreIn one of our projects we had a requirement of putting tooltip on column header without losing the data format of the column values. Below are the steps: Open an analysis in OBIEE 11g Go to column format of the column where tooltip is required Put...
Read More‘Custom links’ are a way of embedding external content into the OBIEE home page and main header at the top of the webpage. This can be very useful to a user as it allows all the external content they require to be located in 1...
Read MorePerformance Tiles are easy to create, but a little supporting code can improve their effectiveness. Legends define the ranges clearly and give context to the metrics. With the logic exposed, the description can contain information on underlying calculations or data lineage. The original tiles from the...
Read MoreRecently a client came up with a requirement to host externally-generated PDF reports in OBIEE and have them display alongside their other OBI content. They also wanted these files to be searchable by name like the rest of elements comprising the web catalog. To achieve...
Read MoreCreate an analysis in Excel using SmartView and save in OBIEE catalog Using SmartView add-in, we can create OBIEE reports from Excel/Word and save in OBIEE catalog.And we can see those reports within OBI Presentation services and can use it for further analysis. To create an OBIEE...
Read MoreCustom Sorting to Column values in Pivot table Custom Sorting In Pivot Table: We have order status and the transactional amount. The requirement is to show the transactional amount across the three different order status: 1.Booked 2.Cancelled 3.Closed User wants the order status to be sorted in the report as below: 1.Closed 2.Cancelled 3.Booked By...
Read MoreWhen the results of an analysis return no data, the following default message is displayed to users: We can modify the No Results view, by adding custom message or more explanation on the use of report or hints on how to filter values. We can also change...
Read MoreRecently I came across a customer requirement to allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly’ or ‘Monthly’ and the appropriate sections of a dashboard would be shown. To achieve this I...
Read More