BI Publisher in Oracle Enterprise Manager (OEM) 13c introduces reporting functionalities, by leveraging the OEM Repository Database. And, the Administrators can extract pertinent information and generate reports, such as health check reports to facilitate proactive issue resolution.
Let’s go through the steps to create a report to receive a report that lists all the Unhealthy Agents every 8 hours.
BI Publisher Steps
Data Model
The first step is to create a Data Model for the report. This is the dataset to be used by the report. Be mindful of the licensing restrictions around the reports, below is an excerpt from the licensing guide.
OEM includes restricted use of Oracle Business Intelligence Publisher (BI Publisher) and Business Intelligence Mobile for use with Oracle Enterprise Manager functions and interfaces only. This restricted BI Publisher license allows reporting only against the Oracle Enterprise Manager repository and
against the data dictionary (including AWR and AWR Warehousing data) of target databases. In order to report against other data sources, it is necessary to have the BI Publisher license.
Click on Create New Data Model, you can use SQL Query to generate the dataset you need. You can use the MGMT views to pull the data for your reports.
SELECT TARGET_NAME, AVAILABILITY_STATUS, START_TIMESTAMP
FROM MGMT_VIEW.MGMT$AVAILABILITY_CURRENT
WHERE AVAILABILITY_STATUS not in ('Target Up')
and TARGET_TYPE = 'oracle-emd'
order by AVAILABILITY_STATUS, START_TIMESTAMP desc
Create Report
Utilizing the data model created in the preceding step as your foundation, create the report. For example, we’ll fashion a straightforward table report by extracting pertinent data from the established model and structuring it in a tabular format for clear presentation.
Schedule Report
The report can viewed from the console, and additionally it can be scheduled to recieve email notifications
You can receive the report in your inbox!
These reports enable users to extract actionable insights from complex datasets within Oracle databases. As we conclude, it’s important to recognize that the transition from BI Publisher to Oracle Analytics Server accompanies the introduction of Oracle 13.5. Therefore, when upgrading Oracle Enterprise Manager (OEM), you must take proactive steps to extract and relocate your reports accordingly.