25 Configuring Reports
You can configure and use reports when standalone Oracle Analytics Server is deployed.
This chapter describes how to configure Oracle Identity Governance reports. It contains the following topics:
25.1 What are Oracle Identity Governance Reports?
Oracle Identity Governance reports enable you to use Oracle Analytics Server (7.0) as the reporting solution for Oracle Identity Management products.
Note:
Oracle Identity Governance reports are classified based on the functional areas, for instance, Access Policy Reports, Request and Approval Reports, Password Reports, and so on. It is no longer named Operational and Historical.
Oracle Identity Governance reports provide a restricted-use license for Oracle Analytics Server (7.0) and easy-to-use reporting packages for multiple Oracle Identity Management products.
As shown in Figure 25-1, Oracle Identity Governance reports use Oracle Analytics Server to query and report on information in Oracle Identity Management product databases. With minimal setup, Oracle Identity Governance reports provide a common method to create, manage, and deliver Oracle Identity Governance reports.
Figure 25-1 Oracle Identity Manager Reports Architecture

Description of "Figure 25-1 Oracle Identity Manager Reports Architecture"
The report templates included in Oracle Identity Governance reports are standard Oracle Analytics Server (7.0) templates. However, you can customize each template to change its look and feel. If schema definitions for an Oracle Identity Management product are available, you can use that information to create your own custom reports.
Note:
Oracle strongly recommends creating back-up copies of the original default report templates before customizing them.
25.2 What is Oracle Analytics Server?
Oracle Analytics Server (7.0) is an Oracle's enterprise reporting solution and provides a single reporting environment to author, manage, and deliver all of your reports and business documents.
Utilizing a set of familiar desktop tools, such as Microsoft Word, Microsoft Excel, or Adobe Acrobat, you can create and maintain report layouts based on data from diverse sources, including Oracle Identity Management products.
25.3 Oracle Analytics Server (7.0) Licensing
Oracle Analytics Server (7.0) is included when you separately license Oracle Identity Governance.
Oracle Identity Governance can be separately licensed, independent of any Oracle Application Server or WebLogic edition. Oracle Analytics Server (7.0) is included when you separately license Oracle Identity Governance:
-
Shipped Oracle Analytics Server (7.0) reports. Layout changes are allowed, AND
-
Shipped or newly created Oracle Analytics Server (7.0) reports that are modified to access data from the existing Identity Management schema that has not been customized.
Note:
Oracle Analytics Server (7.0) is certified with this release of Oracle Identity Governance.25.4 Installing and Configuring Oracle Analytics Server (7.0)
Install Oracle Analytics Server (7.0) software and configure Oracle Analytics Server with new schema option.
25.5 Integrating Standalone Oracle Analytics Server with Oracle Identity Governance
After installing and configuring standalone Oracle Analytics Server (7.0), you integrate the same with Oracle Identity Governance to run and view Oracle Identity Governance reports.
25.6 Configuring Oracle Identity Governance Reports
After standalone Oracle Analytics Server is integrated with Oracle Identity Governance, you can deploy the predefined reports for using them.
25.7 Configuring Data Sources for Running Oracle Identity Governance Reports
For running and viewing Oracle Identity Governance reports using Oracle Anaytics Server, Oracle Identity Governance JDBC connection and BPEL-based JDBC connection is required.
This section describes how to configure data sources for running Oracle Identity Governance reports. It contains the following topics:
25.7.1 Configuring Oracle Identity Governance JDBC Connection
To configure Oracle Identity Governance JDBC connection:
25.7.2 Configuring BPEL-Based JDBC Connection
You can configure a secondary source for BPEL-based reports.
This section describes how to configure BPEL-based JDBC connection. It contains the following topics:
25.7.2.1 About Reports With Secondary Data Source
In Oracle Analytics Server, only one data source can be assigned to a report. The first data source is the Oracle Identity Manager data source. The following reports have a secondary data source, which connects to the BPEL database to retrieve BPEL data:
-
Task Assignment History
-
Request Details
-
Request Summary
-
Approval Activity
25.8 Generating Oracle Identity Governance Reports
Oracle Identity Governance reports can be generated against the sample data source, Oracle Identity Governance JDBC data source, or BPEL-based JDBC data source.
This section describes how to generate Oracle Identity Governance reports. It contains the following topics:
Note:
Oracle Analytics Server can be accessed through the Identity Self Service for viewing the certification reports. But for all other reports, you must open Oracle Analytics Server explicitly to access the Oracle Identity Governance 12c reports.
25.8.1 Generating Sample Reports Against the Sample Data Source
To generate reports against the sample data source, you must first create the sample date source.
This section describes how to create the sample data source and generate sample reports against the sample data source. It contains the following topics:
25.8.1.1 Creating the Sample Data Source
If you want to see an example of what report data will look like without running a report against the production JDBC Data Source, you can generate a sample report against the Sample Data Source. You must create the Sample Data Source before you can generate sample reports.
25.8.2 Generating Reports Against the Oracle Identity Governance JDBC Data Source
To generate reports against the OIG JDBC data source, navigate to Oracle Identity Governance reports by logging in to Oracle Analytics Server, and select an output format for the report you want to generate.
To generate reports against the Oracle Identity Governance JDBC data source:
-
Log in to Oracle Analytics Server.
-
Navigate to Oracle Identity Governance reports. To do so:
-
In the Oracle Analytics Server Home page, under Browse/Manage, click Catalog Folders. Alternatively, you can click Catalog at the top of the page.
The Catalog page is displayed with a tree structure on the left side of the page and the details on the right.
-
On the left pane, expand Shared Folders, and navigate to Oracle Identity Governance. All the objects in the Oracle Identity Governance folder are displayed.
You are ready to navigate to OAS and use the Oracle Identity Governance OAS reports.
-
-
Click View for the report you want to generate.
-
Select an output format for the report and click View.
The report is generated.
Note:
See Oracle Analytics Server Documentation to learn more about Oracle Analytics Server.
25.8.3 Generating Reports Against the BPEL-Based JDBC Data Source
Some reports have a secondary data source, which is BPEL-based JDBC data source.
This section describes how to generate reports against the BPEL-based JDBC data source. It contains the following topics:
25.8.3.1 Reports With Secondary Data Source
The following four reports have a secondary data source, which connects to the BPEL database to retrieve BPEL data:
-
Task Assignment History
-
Request Details
-
Request Summary
-
Approval Activity
These reports have a secondary data source, which is the BPEL-based JDBC Data Source, and is called BPEL JDBC
.
25.8.3.2 Generating the Reports Against the BPEL-Based JDBC Data Source
To generate reports against the BPEL-based JDBC data source:
-
Ensure that a BPEL data source exists in Oracle Analytics Server. This BPEL Data Source must point to the BPEL database. See Configuring BPEL-Based JDBC Connection for more information about creating a BPEL data source.
-
Log in to Oracle Analytics Server.
-
Navigate to Oracle Identity Manager reports. To do so:
-
In the Oracle Analytics Server Home page, under Browse/Manage, click Catalog Folders. Alternatively, you can click Catalog at the top of the page.
The Catalog page is displayed with a tree structure on the left side of the page and the details on the right.
-
On the left pane, expand Shared Folders, and navigate to Oracle Identity Manager. All the objects in the Oracle Identity Manager folder are displayed.
You are ready to navigate to OAS and use the Oracle Identity Governance OAS reports.
-
-
Click Open for the report you want to generate.
-
Select an output format for the report, and click Apply.
The report is generated based on the BPEL-based JDBC data source.
25.9 Configuring Certification Reports
Certification reports are implemented in Oracle Analytics Server. When using a standalone deployment of Oracle Analytics Server, Oracle Identity Manager reports must be deployed on Oracle Analytics Server.
This section describes how to configure certification reports. It contains the following topics:
Note:
-
Oracle Identity Manager reports must be deployed on Oracle Analytics Server. See Generating Certification Reports in Performing Self Service Tasks with Oracle Identity Governance for information about the default certification reports and generating certification reports.
-
If Oracle Analytics Server credentials and URL are not configured in Oracle Identity Manager, then the Reports tab in the Dashboard and the Export to PDF or Excel option in the Certification page are not available.
25.9.1 Configuring the Oracle Analytics Server URL
Update the value of the BIPublisherURL attribute with Oracle Analytics Server URL for the DiscoveryConfig.Discovery mbean in Oracle Enterprise Manager.
To configure Oracle Analytics Server URL:
- Log in to Oracle Enterprise Manager.
- Click Identity and Access.
- Select OIM cluster, OIM node, System MBean Browser.
- In the System MBean Browser, navigate to Application Defined MBeans, oracle.iam, Server: <oim_server_name>, Application: oim, XMLConfig, Config, XMLConfig.DiscoveryConfig, Discovery.
- Update the value of the BIPublisherURL attribute with Oracle Analytics Server URL.
- Click Apply.
25.9.2 Enabling Certification Reports
Select or deselect the Enable Certification Reports option to enable or disable certification reports.
To enable the generation of certification reports, after configuring Oracle Analytics Server credentials and URL, go to the certification configuration screen in Identity System Administration, and select the Enable Certification Reports option.
25.9.3 Enabling the Display of the Reports Tab
The Reports tab can be displayed in the Detailed Information section of the Dashboard.
To configure the display of the Reports tab in the Detailed Information section of the Dashboard:
- Log in to Oracle Identity Self Service.
- Click the Compliance tab.
- Click the Identity Certification box, and select Certification Configuration. The Certification Configuration page is displayed.
- Select the Enable Certification Reports option.
- Click Save.