This chapter contains the following sections:
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.
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:
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.
Use the Oracle Identity Analytics user interface to upload the reports template to Oracle Identity Analytics.
Run or schedule the report as needed.
Log in to Oracle Identity Analytics.
Choose Reports > Custom Reports.
Click New Custom Report.
The New Custom Report window opens.
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.")
Click Save.
Log in to Oracle Identity Analytics.
Choose Reports > Ad Hoc Reports.
Click Custom Reports.
Click the Report that you want to view and click Run.
Select the business structure, users, date range, or roles depending on the prompt.
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.
(Optional) To download the report, click Download in either the Download PDF Report column or the Download CSV Report column.