This chapter contains the following:

About This Guide

If you administer or work with business intelligence, this guide is for you. You can modify, create, and tailor analyses, reports, and dashboards to the content needs of your line of business or company.

Overview of Transactional Business Intelligence

You use Oracle Transactional Business Intelligence (OTBI) to analyze your business and take action with embedded and ad-hoc analysis of your transactional data. Key metrics and attributes of your business and organization are organized into subject areas of data you use as building blocks to answer your business questions.

  • Use embedded analyses and reports to gain insights and report on key business metrics

  • Build ad-hoc analyses, reports, and dashboards.

  • Create business intelligence (BI) catalog folders and define who has access to what in the catalog.

  • Organize your analytics in dashboards and embed them in your work areas.


OTBI uses Oracle Business Intelligence Enterprise Edition (OBIEE) with integration to Application Development Framework (ADF) to run your real-time analysis of your business subject areas.

The BI Server creates physical queries based on metadata mappings between the subject areas you work with in your analysis and ADF view objects and their underlying database tables. The BI Presentation Server compiles and formats the results in the BI client or as embedded analytics.

Here's the OTBI architecture.

OTBI architecture, which focuses physical queries
generated by the BI Server against the Oracle Applications Cloud database
based on repository metadata to provide analyses.

BI Objects and Tools

Here are some of the OTBI components and the objects they support.

Catalog Object Description BI Component or Tool


Analyses are a selection of data displayed in one or more views, such as a table or chart, to provide answers to business questions.



Dashboards organize analytical content and catalog objects, and present them in a meaningful way.

Dashboard Builder

Dashboard Prompt

Dashboard prompts allow users to filter dashboard content by selecting from provided values.

Answers and Dashboard Builder


Filters limit the results that are displayed when an analysis is run.



Agents deliver scheduled analytics and other content and notifications.

BI Delivers


Reports present data in pixel-perfect printable format for distribution.

BI Publisher

Data Model

Data models define the data source for reports.

BI Publisher


Subtemplates are reusable formatting definitions for reports.

RTF or XSL editor

Note: You can't change privileges for the BI components, for example by changing which roles are assigned to access Dashboards or Answers. Any changes made to privileges in the BI Administration page Manage Privileges page aren't preserved during any upgrade.

The catalog stores the BI objects in a folder structure of individual files, organized by product family.

BI objects and reports are organized in a folder hierarchy:

  • Shared folders (parent)

  • Product family, for example, Financials

  • Product, for(example, Payables

  • Report groups, for example, Invoices

  • Dashboard reports

  • Data models

  • Report components

  • BI Publisher reports

  • Prompts

Some Oracle BI Enterprise Edition components aren't available in Oracle Applications Cloud:

  • BI Server: Processes user requests and queries in underlying data sources.

  • Catalog Manager: Manages BI catalog and objects.

  • BI Administration Tool: Manages metadata repository that defines the logical structure and physical data sources for analytic subject areas.

More About Oracle Business Intelligence Components

If you want to know more about Oracle Business Intelligence Enterprise Edition components, here's what we have.

Oracle Business Intelligence Enterprise Edition

Here's the information about the parts of Oracle BI Enterprise Edition that support analysis against your transactional data.

Oracle Business Intelligence Publisher

BI Publisher is the part of Oracle BI Enterprise Edition you use for reports.

Overview of Creation and Administration of SCM Analytics and Reports

Business intelligence enables you to analyze data to gain insight that you can act on, gathering information to meet specific requirements. You can use different types of predefined analytics and reports, or create and edit them, to support your business needs.

Types of Business Intelligence

This table describes the purpose of analyses and reports.

Type Description Purpose


An interactive display of data, for example in a table or graph.

To summarize or break down simple, real-time data, and help you make short-term decisions.


A collection of analyses and other content, presented on one or more pages, or tabs.

To get various pieces of information about a particular subject.


Output of data in a readable, predefined format.

To get high-volume data in an output optimized for printing, including documents to support internal operations, statutory requirements, and other business needs.

For a list of predefined analyses and reports, see Oracle Supply Chain Management Cloud: View Supply Chain Management Reports and Analyses on the Oracle Help Center.

Modification of Analyses and Reports

You can create and edit analyses and reports for your own use. Or, if you have the appropriate roles, you can make modifications for others. For example, you can:

  • Add or remove columns from an analysis.

  • Change the branding logo on report output.

  • Create a dashboard to include your most commonly viewed analyses.

Setup and Administration

Administrators perform setup and administration tasks to manage how you or how other users use and modify analyses and reports. For example, you can:

  • Configure Oracle Business Intelligence Publisher, the tool used for generating and modifying reports.

  • Define flexfields to provide attributes that can be used in analyses.

  • Archive analyses and reports and move them from one environment to another.

Security Overview of SCM Analytics and Reports

All users with appropriate roles can create and access analyses and reports based on role access to subject areas and catalog folders.

Analyses and reports are secured by applying job roles with associated duty roles to users. Duty role assignments determine access to subject areas for analyses as well as catalog folders. For information about the job and duty roles provided with SCM and how to modify your security model by creating job roles and assigning duty roles to them, see the Oracle SCM Cloud: Securing Oracle SCM Cloud guide.

In addition to folder and object access, duty roles also determine data security. Each of the duty roles that provides access to subject areas and catalog folders is granted one or more data security policies that allow access to the data.

There are different ways to view and work with your analytics and reports. You can view analyses, dashboards, and reports in the course of your work, on your usual pages and infolets. Or you can find them in the business intelligence catalog with the Reports and Analytics work area and the Reports and Analytics panel tab.

View Analytics in Infolets

Use your favorite infolet pages to find analytics.

  1. Use the page controls and Previous and Next icons to explore infolet pages in the home page, where they may appear in infolets with summaries and aggregations or performance metrics. You may also find infolets in some work areas.

  2. Click an infolet to open a detailed analysis. So for example, if an infolet has transactions summed to a total, click it to view details of the underlying transactions.

  3. Click Done.

View Objects in Familiar Work Areas and Pages

Use analyses, dashboards, and reports available in your usual pages and work areas.

  1. Explore your pages. Some may include analysis and report links or embedded objects, sometimes in tabs or panel tabs.

  2. Some work areas have a Reports and Analytics panel tab, where you explore catalog folders for relevant analyses and reports for the work area. And if you have permission, you can map more objects to the work area if they're appropriate.

    1. Open the panel tab.

    2. Expand the Shared Reports and Analytics folder and explore the available content.

    3. Click the link for any object and see its type to determine whether it's an analysis, a report, or a dashboard.

    4. Click View to open the object.

View Objects in the Reports and Analytics Work Area

Use the Reports and Analytics work area to search or browse the catalog and view any analysis, dashboard, or report you have access to. It opens at the highest level of the catalog's folder hierarchy with all objects you have marked as favorites.

Here are some things you can do in the Reports and Analytics work area.

  1. Click Navigator > Tools > Reports and Analytics.

  2. Filter and search for objects:

    1. From the Filter list, select what you want to find.

    2. To view objects you have marked as favorites, select Favorites in the list. Or select Recent Items to view objects you recently worked with, or a recent search to run it again. Enter a name or part of a name and click the Search icon.

    3. In the search results, use the icons to identify what the objects are.

    4. Click the name of an object to open it, or click More and select an action.

  3. In the breadcrumbs, browse the catalog folders for analytics and reports. Click any Hierarchical Selector icon to select a different node for the next level in the hierarchy.

  4. Mark objects as favorites.

    • Select Favorites in the Saved Searches to display your favorite objects.

    • Click the Add Favorites icon for an object to mark it as a favorite.

    • Click the Remove from Favorites icon to remove an object from your favorites.

  5. Create and edit analyses and reports.

    1. Click Create and select Report or Analysis.

    2. Use wizards to create your analysis or report.

  6. Click the Browse Catalog button (or click the More icon for a specific report, dashboard, or analysis) to use more features.

View Analyses

An analysis queries against your company's data and answers business questions with visualizations, such as charts and tables. They may appear on your pages, or as parts of a dashboard.

  1. From the catalog folders or search results, open an analysis to view.

  2. Click Refresh to rerun the analysis and refresh its data.

  3. Click Print and select either Printable PDF or Printable HTML to open a printable version.

  4. Click Export to get analysis data in various formats, for example PDF, Excel, PowerPoint, comma-separated value (CSV), and XML.

    Note: When you export data in a CSV format, dates are exported in raw format and converted to UTC time zone.

View Grouped Analyses in Dashboards

Some analyses are grouped in dashboards to give you meaningful related information. A dashboard contains pages of analyses, prompts that filter information, and other objects.

  1. From the catalog folders or search results, open a dashboard to view.

  2. Select values for any dashboard prompts to filter the dashboard.

  3. Click Apply to refine the results of all of the analyses in the dashboard.

View Reports

Reports show data in a predefined format that's optimized for printing.

  1. From the catalog folders or search results, open a report.

  2. Click the View Report icon if you want a different format.

    • Choose HTML or PDF to display the report in a format for printing. Because it's optimized for printing, PDF often provides the best results.

    • You can also export the report as RTF for editing in a word processor, or as Excel or PowerPoint.

  3. From the catalog folders or search results, you can also do these tasks:

    • Click Edit to edit the report properties, layout, and data model.

    • Click Report History to see details about past submissions of the report.

    • Click Schedule to schedule the report to be run.

You save analyses, dashboards, and reports in the catalog, along with other objects like prompts and filters. Besides the hierarchy of folders organized by product family, another important folder is Custom, found in Shared Folders. This is where you save the analytics and reports you create or edit for others to use.

Shared Folders and the Custom Subfolder

Anyone with the correct access can get to objects stored in Shared Folders. If you have the appropriate roles, you can save in Shared Folders so that your objects are available for other users. You should save objects in the Custom subfolder, and use the product family subfolders to organize and publish analytics and objects for the correct audiences.

Here are a few things to know while working with analytics in the catalog. Keep all modified analyses and reports in the Custom folder. Directly edit predefined analytics only when it's necessary to make sure that any references to the analysis or dashboard still work properly.

  • Preserve modified predefined objects during updates, which can make changes to predefined analytics, reports, and other objects outside the Custom folder. You might lose changes saved outside the Custom folder during updates.

  • You can easily find modified objects if they're not spread around the catalog.

  • You can edit objects in the Custom folder without compromising security on the original objects.

  • For predefined reports only, you can use a special Customize option to copy the report and also the folder structure and permissions. The copy is linked to the original, so editing the copy is like directly editing the original.

When you copy an object into the Custom folder, the copied object inherits the permission settings of the Custom folder. An administrator can reset the permissions on the object and the folder that it's in.

My Folders

My Folders is your personal storage; you're the only one who can access anything that you save there. What you save there is available in the Reports and Analytics work area, but not in My Folders in the Reports and Analytics panel tab on any other work area. But an exception is when you create an analysis using the wizard in the Reports and Analytics work area. If you save a wizard analysis in My Folders, it's available in any panel tab that appears in any work area.

FAQs for Overview

Do I need to create copies of predefined reports and analyses for each user?

No, you don't need to create multiple versions of the same analysis or report for different users. When you view an object, it includes only the data that you have permission to view from your data security profile.

What happens to modified analytics and reports when a release update is applied?

Updates don't affect the Custom folder or My Folder in the catalog. Anything saved there is preserved, including the analytics and reports you edited or created. But anything saved outside those folders, in the predefined catalog, is preserved only if the update doesn't include a new version of those BI objects.

If an update includes a new version of a predefined object that you edited outside the Custom folder, the changes you made are saved as a new object. The new version from the update overwrites the existing predefined object. And a copy of the existing object (with your edits) is automatically created in the same folder, with a new name that indicates it's a new version.

If the update includes a new version of both the predefined object and a folder in its file path, the new folder name, along with the new version of the object, overwrites the existing predefined folder and object. And a copy of the existing folder (along with your edited object) is automatically created. The folder is renamed to indicate that it's a new version, but your edited object isn't renamed.

Note: Future updates won't affect renamed objects or anything within a renamed folder.