My current blog looks at the logical or business model. In particular how to connect fact tables so that you can get numbers from more than one fact in the same report – and actually show results. This aspect of OBIEE seems to cause a fair...
Read MoreOBIEE conditional format using arrows was sought. Let’s start with the basic report: Calculate the delta: Add two conditional formats: Add the correct images: Set it to image only: There you go: ...
Read MoreThe newest release of Oracle Business Intelligence 11.1.1.7 shows Oracle's continued efforts in trying to integrate its Oracle Business Intelligence Platform with big data technologies such as Hadoop and Hive. Specifically, I'm talking about OBIEE 11g's ability to integrate with a Hadoop Data source. What is...
Read MoreSome times the data model does not allow you to create a single query to get the results you need. then we are forced to do a Union. (actually they are 4 possible operations Union, Union All, Minus and Intersect). The default is Union. I...
Read MoreOBIEE 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 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 More