15
July
OBIEE Deployment Options
July 15, 2017
In BI
[embeddoc url="http://ids-sol.co.uk/wp-content/uploads/2017/07/Cloud-Computing-and-OBIEE-v3.pdf" download="all"]...
Read More
OBIEE Tag
06
June
MULTIPLE FACT TABLES
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 More
03
June
OBIEE conditional format using arrows
OBIEE 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 More
14
May
Hadoop Integration with OBIEE 11g
The 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 More
07
May
06
May
Displaying External Documents on an OBIEE Dashboard
May 6, 2017
Recently 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 More
06
May
analysis in Excel using SmartView and save in OBIEE catalog
May 6, 2017
Create 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 More
04
May
Custom No Data found Message in OBIEE 11g
May 4, 2017
When 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
03
May
OBIEE 11g Hide/Show Sections based on Dashboard Prompt
May 3, 2017
Recently 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
03
May
OBIEE and tiles without Narrative
May 3, 2017
How was it done? I created a basic report: The last column has no meaning, we just need something to be in the measures part. In my case I decided to have a column of NULLs with space as a label. So I create a Pivot: And rearrange it: Now...
Read More