Saturday, November 15, 2014

BI Publisher and OBIEE Dashboards

The most complicated skill is to be simple.

There are multiple ways to invoke BIP reports in siebel. You can go for Symbolic URLs or Browser scripts or if reports are IO based, standard menu based invocation is the option. However one more interesting way is to invoke BIP reports from OBIEE dashboards. Usually OBIEE dashboards are configured in the system to display analytical reports. If you want to blend your BIP reports into the dashboards, it can be easily done in one click. The advantage here is you don't have to touch siebel environment for anything. Build your BIP report and pull it in the existing dashboard in OBIEE.


The only catch here is if your BIP report is parameter based and if you use BI Publisher section in your dashboard page, you will loose your parameters. Parameter section doesn't come in the BIP reports displayed in OBIEE dasboard. As an alternate you have to use "Embedded Content" section in your dashboard page and need to use link of the BIP report With "No Header" option. Specify height and width of the pane and you are ready to go.  As simple as it can be.

Happy Reporting!!

1 comment:

Static Variable said...

Good one.

Just wished to point out that in most implementations, OBIEE uses a different database (OLAP) instead of the primary Siebel database (OLTP). These are synced at least once a day, to how frequently business requires it. So having a realtime dashboard and report there might not reflect latest data entered in Siebel.

Off course OBIEE can also be reconfigured to use the OLTP system.

Siebel BIP reports work right on the Siebel database ,so latest data can be accessed.