EM 13c: How to Export Custom Business Intelligence (BI) Publisher Reports and Schedules for Migration to the Stand-Alone Oracle Analytics Server (OAS) (Doc ID 2753983.1)

Last updated on AUGUST 18, 2023

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 and later
Information in this document applies to any platform.

Goal

This document explains the steps to Export Custom BI Publisher reports and BIP Schedules from EM 13.4 or older integrated BI Publisher.

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

1. Migrating any (Oracle-provided and customized) reports from the embedded BIP in EM 13.4, to the standalone OAS.

1.1 Migrating any customized BIP reports to the standalone OAS.

1.2 Example Use Case

1.3 Outline of steps to export the report from EM 13.4:

1.3.1 EM 13.4 – Login to BIP

1.3.2 From the BIP home screen, click on the link for ‘Catalog Folders’

1.3.3 If needed, expand the ‘Shared Folders’ node in the catalog tree.

1.3.4 Click on the ‘MyReports’ Folder.

1.3.5 In the bottom left hand side of the window, in the ‘Tasks’ pane, click on the 'Download' link.

1.3.6 When asked what to do with the file named ‘MyReports.xdrz’, Choose to save the file locally.

1.3.7 Confirm that the file was downloaded correctly.

1.3.8 Importing the EM Out-of-Box Reports into OAS.

1.3.8.1 : Upgrading from a version of OEM prior to version 13.5:

1.3.8.2 : New install of OEM 13.5 (you have no prior versions of OEM to export from):

2. Migrating the BIP schedules, from the embedded BIP in EM 13.4 (or earlier), to the schedules in the standalone OAS.

2.1 Migrating BIP Schedules from EM 13.4

2.1.1 Arguments for OAS Scheduler Migration Script

2.1.2 Example execution of OAS Scheduler Migration Script using example values

2.1.2.1 Change to the directory appropriate for your platform:

2.1.2.2 Using the table above as an example, execute the script:

2.1.2.3 Run the bip_12c_scheduler_migration.sql script

3. Repository Clean-up.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.