9 Oracle Identity Analytics Reports

This chapter contains the following sections:

• Section 9.1, "Overview"

• Section 9.2, "Working With Custom Reports"

9.1 Overview

This chapter documents reports and reporting features that are available to business administrators, but not to general business users. Reports information for general business users is documented in the User's Guide for Oracle Identity Analytics "Reports" chapter.

See the User's Guide for Oracle Identity Analytics to learn more about the following Reports topics:

• Understanding the reports user interface

• Working with reports: How to schedule and sign off on reports

• Defining and generating business structure reports

• Defining and generating system reports

• Defining and generating identity audit reports

Note:

Business structure reports, system reports, and identity audit reports are standard reports that are included with Oracle Identity Analytics.

9.2 Working With Custom Reports

You can run custom reports in Oracle Identity Analytics to suit the requirements of your organization.

Complete the following steps to create and run custom reports:

1. Create a reports template using JasperReports.

   JasperReports is an open source Java reporting tool that can write to screen, to a printer, or to various file formats, including PDF, HTML, Microsoft Excel, RTF, ODT, comma-separated value (CSV), and XML. It reads its instructions from an XML or .jasper file.

2. Use the Oracle Identity Analytics user interface to upload the reports template to Oracle Identity Analytics.

3. Run or schedule the report as needed.

9.2.1 To Upload a Custom Report Template in Oracle Identity Analytics

1. Log in to Oracle Identity Analytics.

2. Choose Reports > Custom Reports.

3. Click New Custom Report.

   The New Custom Report window opens.

4. Complete the form as follows:

   • Report Name - Type a name for the report.

   • Sub Report - If you require sub-reports, select this check box. Selecting this option will display additional fields that you can use to specify subreport templates to be uploaded.

     Note:

     To establish a relationship between a master report and one or more subreports, the master report must reference the subreport(s) by file name. For example:

     <subreportExpression class="java.io.File"><![CDATA[new
     File($P{REPORT_LOCATION},"/mainReport_subreport1.jasper")]]></subreportExpression> 
     

     Subreport file names should end with a .jasper suffix.

     For more information about configuring subreports, refer to the JasperReports documentation.

   • Prompts - Oracle Identity Analytics has four prompts: Business Structure, Users, Date Range, Roles, and Custom Properties.

     Custom reports can be run on any or all of the prompts that you select. Custom Properties will display five prompts where you can enter relevant values to run the report.

   • File Uploads - Click Browse to upload the XML or .jasper report template file. (Report templates were discussed in Section 9.2, "Working With Custom Reports.")

5. Click Save.

9.2.2 To Run a Custom Report

1. Log in to Oracle Identity Analytics.

2. Choose Reports > Ad Hoc Reports.

3. Click Custom Reports.

4. Click the Report that you want to view and click Run.

5. Select the business structure, users, date range, or roles depending on the prompt.

6. Click the Actions drop-down menu for options to export the file in other formats. Formats offered include PDF, XLS, CSV, HTML, XML, and Print.

7. (Optional) To download the report, click Download in either the Download PDF Report column or the Download CSV Report column.