Integrating BI Publisher with OBIEE

Integrating BI Publisher with OBIEE Presentation Service

1)      Login to BI Publisher using ‘Administrator’ / ‘Administrator’ and go to ‘Admin’ tab .

2)      Go to ‘Security Configurations’ .

3)      Check the option ‘ Enable Local Superuser’ and put the superuser name as ‘admin’ and password as ‘admin’ . This will make a option open so that you need not to change the SECURITY_MODEL parameter value to ‘XDO’ and ‘BI_SERVER’ to switch from local BI Publisher and BI Server based security.

4)      Now change the Security model as per the below so that BI Publisher can talk with Presentation Services i.e Oracle BI Server . After changing click on Apply.

Integrating Publisher1

5)      Restart the OC4J daemon.

6)      Sign-In to BI Publisher once again and you can get the below connection created under Admin-) JDBC -) Oracle BI EE .

Integrating Publisher2

7)      Now you can able to see the file has been modified with configuration parameters ‘D:\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml’

Integrating Publisher3

8.)  Now try to login using BI Server Administrator password . In my case it is ‘newpass9’ and you can get below screen. Note that here ‘Admin’ tab is missing which we will make visible after some more configuration settings.

Integrating Publisher4

9)      You can get the same screen once you come from ‘BI Publisher’ option of Presentation Administrator. So now it is integrated but no Subject area no Shared Folder has been created and nothing has been setup it .Lets do that in next step.

Integrating Publisher5

Integrating Publisher6

10)      Create a User group called ‘ XMLP_ADMIN’ in repository and assign the permission to be  ‘Administrator’ .

11)      Now Sign-In to BI Publisher using BI Server login credentials like ‘Administrator’/newpass9 .Here you go with Admin tab visible with the folders as well.

Integrating Publisher7

12)      Click on any of the shared folder and you can get the option to create new report .Here I am creating a new report based on existing subject area is ‘testdeba’ .

Integrating Publisher8

13)      Edit ‘testdeba’ and create a new datamodel with default datasource set as ‘Oracle BI EE’ .

Integrating Publisher9

14)      Click on ‘Query Builder’ and select the Schema i.e. the Subject area and select region.

15)      Click on Save , then View and then Analyzer which will show below report after drag and drop left pane columns to respective regions .

Integrating Publisher10

16) So now the OBIEE Publisher is ready to work and details of how publisher would work is out of scope of this post. More more details refer the BI publisher Admin and User guide from Oracle.

N.B : Some of this configuration task has been already done by Oracle in latest release onwards so there will no more manual interaction to handle the config parameters which is indeed good for newbies and pretty cool for experienced .Yet I think this will be helpful specially to know how the interaction managed behind the screen 🙂

One thought on “Integrating BI Publisher with OBIEE

  1. Hi Debashi,

    Very Nice Article and its a very timely help for me. While doing the integration till 8th step I am OK. But after that I couldn’t proceed.
    I can login into BI Publisher as BI Admin. But I cannot access the BI publisher through BI answer.I am getting this error

    Oracle BI Publisher Enterprise
    Reporting Login: java.lang.NumberFormatException: For input string: “”


    Oracle BI Publisher Enterprise
    Reporting Login: Connection reset
    Error Details
    Error Codes:

    Please advise me for the above issues

    Here is My Mail ID


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s