Get started with custom reports

Follow these three steps to create your report.

There are three steps to create a custom report:

First, you need to define a Data Model to select the data to report on. For this, you’ll use the Data Model Editor.

Next, in step two, you’ll design a Layout to decide how to represent the data visually. Layouts are created either in your browser using the online editor, or offline using the Oracle BI Publisher plugin for Microsoft Office.

Finally, in step three, you can View and Share your report.

Beginners guide

Easily create a custom report by modifying a copy of an existing standard report. Follow these steps to copy and reuse the data model and layout of an existing report and edit it as needed. This is much faster than creating the custom report from scratch.

  1. Look through the standard reports library and find a report with similar details you want to report on.
  2. Save a copy of the report and Edit the data model. Add/remove attributes and filters to create the report you need. 
  3. Modify the layout to create the look/representation of metrics you want. 
  4. Save and view your report. Continue to edit it until you are happy.

Add a new Custom Report

  1. From the menu, select Insights > Reports.
  2. Click Add Report on the top of the screen.
  3. Follow the three steps to create your custom report.

Tip!

Add button not visible? You’ll need to ask your Organization Administrator to grant you the required access permission. As a minimum, you’ll need the security asset Create new private reports granted to your user role.

Create your report in three steps

Step 1. Create a Data Model to select the data points for the report, such as subject areas, attributes, and filters.
Step 2. Create a Report Layout to design your report using either the: 
             Online Layout Editor – recommended for most users.
                   or
             Offline Template Builder – for advanced users (requires plugin)
Step 3. View and Share your report. Newly created reports will be listed under the Custom tab of the report listing page and shared with ‘Private’ by default. Private reports are only visible to the user who created them. Use the Share option to share the reports with other users based on your access permissions. You can also edit the data model or layout as needed to refine your report.

Tip!

The offline Template Builder requires the Oracle BI Publisher plugin to be installed on your computer. It supports Microsoft Office for Windows computers only. If you are unable to use the plugin, you’ll need to use the online editor to design your layout.

Report Permissions

Organization Administrators can grant the following assets to provide permission for custom reports. These permission are listed under Insights in Setup > User Role Configuration.

  • Create private report layouts - add layouts to existing reports (cannot create new reports).
  • Create new private reports - create new reports and layouts for yourself only (cannot be shared).
  • Create Project Org reports - create new reports and layouts and share with users from your organization.
  • Create Project reports - create new reports and layouts and share with all users from all organizations.