My Oracle Support Banner

EM 13c: How to Export Custom BI Publisher Reports and Schedules (Doc ID 2753983.1)

Last updated on JULY 15, 2021

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
Goal
Solution
 Background
 Solution:
 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.
 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
 References
 Related
 Keywords

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