Migration of BI Publisher Reports

Migrating 10g to 11g BI PUBLISHER

The Following are the below steps in-order to migrate the BI Publisher reports from 10g to 11g.Copy  the 10g reports repository and restore  it to some location in the current system where BI Publisher 11g is Installed.

• Take a backup of the BI 11g Repository by going into the following location.
• mv  $ORACLE_HOME/user_projects/domains/bitest_domain/config/bipublisher  bipublisher_ORG
• Running the Upgrade wizard by going into the following location
•   Cd  $ORACLE_HOME/Oracle_BI/bin
• $ ./ua
• Click on Next
• Select  à  Upgrade Oracle BI Publisher Repository and click on next.
• Select  à  Upgrade 10g BI Publisher Repository Directory and click on next.
• Provide the 10g reports repository location which is copied and stored in the current system.
• /rtmrap/bi10greports_repos/XMLP
• Enter the destination 11g BI Publisher Repository Directory and click on next. Provide the 11g reports repository location  /rtmrap/bi_weblogic/middleware_home/user_projects/domains/bitest_domain/config/bipublisher/repository
• Enter the weblogic Admin Server Connections details 
• UserName       :   biweblogic
• Password        :   biweblogic1
• Click on Next
• Click on Finish
• 
  
• After completing the upgrading steps restart the weblogic domain and managed server.
• To Start the BI Core application go the following location and execute the below command.
• Cd  $ORACLE_HOME/instance/bi_inst1/bin
• ./opmnctl  startall
• ./opmnctl status
• After re-bouncing the BI domain & Managed Server. Login into the BI Publisher application and go the following location
• Click on Administration tab
• Select Server Configuration
• Select Catalog Type :  Oracle BI EE Catalog
• Specify the BI Publisher repository location
• For ex:/rtmrap/bi_weblogic/middleware_home/user_projects/domains/bitest_domain/config/bipublisher/repository
• Click on Upload to BI Presentation Catalog
• Restart the BI domain, Managed Server & core application.
• After re-bouncing the weblogic domain, login into the bi publisher application.
• In-order to view the reports
• Go the catalog and select the respective folder to view the reports.

BI Publisher Reports not found in OBIEE Catalog

There could be two problems which will cause this Issue

1. Reports may not be present in Shared Folder.

• Go to the respective path of the shared folder where the reports should be present.
• If you see that there are no reports then this will be because of GUIDs.
• To Resolve it you just need to refresh the GUIDs so that you will able to see the reports.

To Update GUIDs, Modify the configuration in the NQSconfig.ini

• FMW_UPDATE_ROLE_AND_USER_REF_GUIDS=YES

Make sure that it is set as NO after you restart the system with YES

2. The user may not have the proper privileges to view the report.

• Just check the Security Properties on the BI Publisher Folders with Administrator User.
• Change the roles assigned to it with respective roles.

Hope the above resolution will fix the Issue.

Issue with large excel output in BI Publisher

If you are facing large memory issue in excel output of BI Publisher. Use Excel template to overcome that issue.

You can also use the excel features to render charts and pivot tables.