Configure “BI Publisher Enterprise Reports” in Oracle Enterprise Manager 12cR4

Hi All,

This blog explain what BI Publisher is all about some advantage over Information Publisher also, I’ll show you step by step procedure “How we can configure “BI Publisher Enterprise Reports” in EM12cR4.

Just a brief introduction about BI Publisher, which was introduced in 12.1.0.1.  We all know that BI Publisher is used as an Enterprise Reporting Solution to generate highly formatted documents. Eg. Operational Reports, not only that it can also helps   developers to design data models. We can generate custom reports which can help us leverage existing Infrastructure of our company.

In Previous release “EM12c R1 Cloud Control” the installation and configuration of BI Publisher required more hard work. Separate download of software and an additional 10Gb of space at file system were of few mandatory requirements. However, in EM12c R4 no additional software download is required, it already comes as a package, all you need is to configure it.

Before we go further lets discuss some benefits of this enhanced reporting module.

  • It reduces the complexity and lowers the cost.
  • Has capability to use data from out resource as well.
  • BI Publisher is integrated to use familiar desktop products and other developer tools.

Advantages of BI Publisher over Information Publisher

  • User can create report in different formats like PDF, EXCEL, WORD, HTML etc
  • Users can develop their own custom reports against EM Repository
  • BI Publisher has been integrated with EM Security
  • Access can be granted to administrators on the basis of hierarchy level
  • BI Publisher has been enhanced with scheduling & delivery mechanism like email or FTP.

We can also say the BI Publisher Enterprise Reports is the replacement for deprecated Information Publisher Reporting Capability.

How to confirm if BI Publisher is already configured in EM?

Navigate to “Monitoring -> Reports -> BI Publisher Enterprise Reports”

If BI Publisher is not configured you will get a message displayed “BI PUBLISHER IS NOT CONFIGURED”.

Image0

So the first thing now we have to do is configure BI Publisher.

Steps to follow:

Login to your OMS server and check the status for BI Publisher.

    1. [oracle@hanoemap1 ] $  cd  /app/oracle/product/middleware/OMS12cR4/oms/bin
    2. [oracle@hanoemap1 bin] $  ./emctl status oms –bip_only

Now we since the BI Publisher is not configured, we have to set it up first.

Go to OMS/bin directory and run “congifureBIP” script

Image1

The First time you will run “configureBIP.sh” script, you will be prompted to take backup of OMS.

Image2

Image3

Run “./emctl exportconfig oms” to take the backup of OMS.

Image4

Enter the password of SYSMAN user when prompted.

Image5

You will be notified once the backup is finished.

Image6

Once the backup of OMS is complete execute “configureBIP.sh” script again and type “YES” when prompted.

Image8

Please enter the password for database user with SYSDBA privileges and the password for Weblogic Admin Server when prompted it will executes the Repository creation utility {RCU} to create BI Publisher schema {SYSMAN_BIPLATFORM}

Image10

It will require automatic restart of OMS and extends weblogic domain that contains EM to include BI Publisher and configure it.

Image11

Check the status of BI Publisher now.

Image12

Now login to EM console and navigate to “BI Publisher Enterprise Reporting” under  “Monitoring -> Reports -> BI Publisher Enterprise Reporting”. For the first time if you user is not “Super Administrator” user you will get screen like this.

Image14

Login with SYSMAN (Super Administrator) user and navigate to “BI Publisher Enterprise Reports”. You will able to use BI Publisher feature now.

Image16

You can also grant access to any repository user by using the below mentioned commands after which he/she will be able to access “BI Publisher Enterprise Reports”.

Image15

Hope this document will help you to configure “BI Publisher Enterprise Reports” in your Environment.

Thanks

Deepak Sharma

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2015/06/configure-bi-publisher-enterprise-reports-in-oracle-enterprise-manager-12cr4/
LinkedIn
Instagram

Leave a Reply

Your email address will not be published. Required fields are marked *