This is my OBIEE 11g reference note; hopefully this will be helpful for you as well. OBIEE 11.1.1.5.0 Download OBIEE 11g installation on Windows XP Oracle Business Intelligence Enterprise Edition Plus Samples Oracle Business Intelligence Documentation New Features for Oracle Business Intelligence Users New Features for Oracle BI Metadata Repository…

Last week, one of my consultant asked, how to set the default output type as EXCEL for one of the EBS report. I found out, client was not on the latest patchset and thats why , the Default Output Type field on Template Definition UI was not there. This…

If you have installed OBIEE 11g successfully, lets try to explore some of the new features and tools available with BI Publisher 11g. Unlike 10g, where Report is a single entity and data sets are the part of Report definition, in 11g, Data Sets (which termed as Data Model in…

Next: Exploring BI Publisher 11g : DataModel Editor Just finished my OBIEE 11g successful installation on Windows XP Professional – SP3 with 2GB Memory and 50 GB available disk space. I have my local Oracle instance is running on the same machine as well. Before writing this article, I tested…

Bursting is one of the most widely implemented features of BI Publisher. Over the period of our BI Consultancy, Adiva consultants implemented around 10 implementation of Bursting Reports, that’s include the EBS bursting which is control file based bursting and the Enterprise Bursting Reports. Our implementation includes the Invoice, Purchase…

Today one of my consultants shared his problem on submitting the Concurrent Program to run XML Publisher report. They are customizing EBS functionality and it requires submitting the concurrent program programmatically. The request was submitted and completed successfully but the report output was XML instead of PDF and what I…

In this article, I would like to talk about BI Publisher debugging, logging and how to set and get the debug log. For Enterprise Release the debug level can be set from Admin > Server Configuration UI. Setting value as “Debug” from the LOV turns on the…

This article is in continuation to my previous article, XML generation using BI Publisher Data Template. PL/SQL support within Data Template separate the data extraction logic and XML generation in two separate layers. We can hook the PL/SQL logic to implement the Business rules, Data extraction or post processing logic.…