24 Setting Up Reporting Framework

Oracle Business Intelligence Publisher (BI Publisher) is Oracle's primary reporting tool for authoring, managing, and delivering all your highly formatted documents. Set up the reporting framework using BI Publisher so that you can generate high-quality reports and documents, with pagination and headers/footers, and in formats such as PDF, Excel, Powerpoint, Word, and HTML.

Step 1: Download BI Publisher 11.1.1.6.0	Step 2: Back Up the OMS and the Domain	Step 3: Install BI Publisher	Step 4: Integrate with Enterprise Manager	Step 5: Verify the Integration
Download the software from the Oracle Enterprise Manager Downloads page. (Search for the product title Oracle Business Intelligence Publisher 11.1.1.6.0)	Back up the OMS as described in Oracle Enterprise Manager Cloud Control Administrator's Guide. Back up the domain: cd <Instance-Home>/user_projects/domains zip -r GCDomain.zip GCDomain	Run the BI Publisher installer: (Optional) Select an e-Mail address for updates, and click Next. Select Software-only Install, and click Next. After passing the prerequisite checks, click Next. Select the Middleware home of your Enterprise Manager installation. Retain the default name Oracle_BI1 as the BI Oracle home name, and click Next. (Optional) Enter the My Oracle Support credentials to be notified of any security update, and click Next.	Run the configureBIP script: $<OMS_HOME>/bin/configureBIP Enter the necessary credentials when prompted. Enter the HTTP and HTTPS ports when prompted. The script identifies free ports and ask if you want to take them as a default. Once entered, Extend Domain then runs. The ports can be in the range 9701-49152.	From the Enterprise menu, select Reports, then select BI Publisher Enterprise Reports. On the BI Publisher Enterprise Reports page, click the refresh icon at the top-right corner. Expand EM Sample Reports, then click Targets of Specified Type. Log in to BI Publisher using your Enterprise Manager credentials. Verify if you are able to see the sample report.

Learn More What Limitations Apply to the Use of Reports and Data Sources? Do I Require a Centralized Inventory File for BI Publisher? What Are the Hardware Requirements for Installing BI Publisher?

Perform Additional Tasks How Do I Authenticate and Limit Access to BI Publisher Features? How Do I Grant BI Publisher OPSS Application Roles to Administrators? How Do I Grant Access to Administrators Using the LDAP Authentication Security Model? How Do I Map LDAP Groups to BI Publisher OPSS Application Roles?

Perform Additional Tasks How Do I Grant Access to Folders and Catalog Objects? How Do I Manage Enterprise Manager - BI Publisher Connection Credentials? How Do I Manage the BI Publisher Server? How Do I Configure BI Publisher with a Load Balancer? How Do I Troubleshoot BI Publisher-Related Issues?