This guide also applies to on-premises implementations

1 Setup and Administration Overview

This chapter contains the following:

Analyses and Reports: Administrative Overview

Analyses and reports in Oracle Applications Cloud are built using Oracle Business Intelligence (BI) tools and technologies, which you also use for administration and setup. Oracle Business Intelligence provides several tools and different report types to meet different reporting requirements.

Oracle Transactional Business Intelligence is a real-time, self-service solution that lets users create ad hoc analyses and dashboards with real-time transactional data, using different Oracle BI technologies.

  • Analyses are visualizations, such as charts and tables, of a specific set of data. An analysis can be embedded into an application page, or included as a component of a dashboard. Analyses are generally interactive, allowing users to customize the presentation of the data in real time.

  • Dashboards are a collection of analyses grouped together to return data.

Operational reports are static reports that meet operational and statutory reporting requirements. Operational reporting includes the generation of high-volume business documents such as payroll and invoices. Oracle Business Intelligence Publisher is the tool for operational reporting, and many predefined reports may be provided with your applications.

Tools for Administering Analyses and Reports: Explained

You can use several different tools to manage and administer analyses and reports.

These components support modification and administration of your analyses and reports:

  • Use the Business Intelligence catalog to interact directly with your reports and analyses. Use this interface to manage permissions, properties, and the organization of your analyses and reports.

  • Use the Oracle Business Intelligence Publisher administration pages to configure settings specific to the running and scheduling of operational reports, such as setting up your delivery servers, managing scheduler work load, and setting run-time properties for reports.

  • Use the Oracle BI Administration Tool to edit the Oracle BI repository (RPD), which contains the metadata upon which reports and analyses are built. The Administration Tool is a Windows application that you use to edit the RPD based on your requirements.You can use the Administration Tool to perform data modeling tasks such as adding new fact or dimension tables, reorganizing Presentation layer metadata, and creating BI view objects for tables. This tool isn't available in Oracle Cloud implementations.

  • Use the Catalog Manager to perform online and offline management of the catalog. Tasks that you can perform with the tool include managing folders, shortcuts, global variables, and Oracle BI objects such as analyses, filter, prompts, and dashboards; viewing and editing catalog objects in XML, and searching for and replacing catalog text. This tool isn't available in Oracle Cloud implementations.

  • Use the Oracle Enterprise Manager Cloud Control to monitor your IT environment unattended. It's delivered with a predefined set of performance and health metrics that enable you to monitor key environment components, access real-time performance charts, and perform strategic tasks such as trend analysis and reporting. This tool isn't available in Oracle Cloud implementations.

Business Intelligence Catalog: Explained

Reports, analyses, dashboards, and other business intelligence (BI) objects are stored and administered in the business intelligence catalog.

Navigating to the Catalog

To navigate to the catalog:

  1. Click Reports and Analytics under Tools in the Navigator.

  2. In the Reports and Analytics pane, click the Browse Catalog icon.

Identifying Objects in the Catalog

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

BI objects and reports are organized in the following folder hierarchy:

  • Shared Folders (top level)

  • Product family (example: Financials)

  • Product (example: Payables)

  • Report groups (example: Invoices)

  • Dashboard reports

  • Data Models

  • Report Components

  • BI Publisher reports

  • Prompts

The following table describes the common BI objects that you find in the catalog:

Catalog Object Description Location

Analysis

Analyses are used primarily by dashboards.

Report Components folder

Dashboard

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

Reporting group folder

Dashboard Prompt

Dashboard prompts allow users to filter dashboard content using provided values.

Prompts folder

Filter

Filters are used in dashboards and analyses.

Prompts folder

Report

Reports are operational reports created in Business Intelligence Publisher.

Reporting group folder

Data Model

Subtemplates are used by reports created in Business Intelligence Publisher.

Data Models folder

Subtemplate

Data models are used by reports created in Business Intelligence Publisher.

Reporting group folder

Define Transactional Business Intelligence Configuration: Overview

Use the Define Transactional Business Intelligence task list in the Setup and Maintenance work area to complete configuration of business intelligence in your application. Some tasks in this task list are performed during Oracle Applications Cloud provisioning and require no further action from you. The Define Transactional Business Intelligence Configuration task list includes the following tasks:

  • Optimize Transactional Business Intelligence Repository

    Trim unused projects from the business intelligence repository based on configured Oracle Applications Cloud offerings. This optimization is automated during the provisioning process and requires no further action from you.

  • Manage Transactional Business Intelligence Connections

    Review data source connections in the physical layer of the business intelligence repository. Connections are set up and reviewed during the provisioning process, and this task requires no further action from you.

  • Manage Security for Transactional Business Intelligence

    Review security for business intelligence users. The default security configuration can be modified. Refer to the security documentation for your cloud services to review or change the default user security model.

  • Configure Key Flexfields for Transactional Business Intelligence

    Define the key flexfield segments and validation for use as classification keys. You must define these key flexfields for Oracle Fusion Transactional Business Intelligence to operate correctly.

  • Configure Descriptive Flexfields for Transactional Business Intelligence

    Define validation and display properties of descriptive flexfields, which are used to add custom attributes to entities. You enable and import flexfields for use in analyses.

  • Import Essbase Cubes into Transactional Business Intelligence Repository for Financials General Ledger

    Import Essbase cubes into the business intelligence repository. You must perform this task if you're using Oracle Fusion General Ledger.

  • Manage User Currency Preferences in Transactional Business Intelligence

    Manage user currency preferences, which control regional currency settings, currency used in reports, and corporate currency.

Setting Up Your Financial Reporting Center: Critical Choices

Oracle Fusion Financial Reporting Center is a powerful tool for reviewing, designing, and presenting financial reports and analytic data. The critical choices required to configure and install the components in Financial Reporting Center consist of:

  • Configuring the Financial Reporting Center

  • Installing and configuring Financial Reporting Studio, performed by your end users

  • Installing Smart View, performed by your end users

  • Configuring Workspace Database Connection, performed by your administrator

  • Configuring Oracle Transactional BI Dimensions

Configuring Financial Reporting Center

You have access to the reports in the Financial Reporting Center and Workspace installed with Oracle Fusion Financial Applications. Your Oracle Fusion Business Intelligence (BI) administrator defines the folder structure in Workspace. The administrator considers your company's security requirements for folders and reports, as well as report distribution requirements for financial reporting batches.

  • Security can be set on folders and reports from Workspace.

  • You are granted access to the folders and reports you want to view by your BI administrator.

Installing and Configuring Financial Reporting Studio

Oracle Financial Reporting Studio is client-based software. If you open Oracle Fusion Applications from Oracle Cloud, you connect to the Financial Reporting Studio through a Windows Remote Desktop Connection. Report authors download installation files for Financial Reporting Studio from Workspace by clicking Navigator > Financial Reporting Center > Tasks panel drawer > Open Workspace for Financial Reporting. Once Workspace is started, click Tools > Install > Financial Reporting Studio. After performing the prerequisites and completing the installation, start the Financial Reporting Studio. Provide your user ID, password, and the Server URL. Derive the Server URL information by following the steps:

  1. Open Navigator > Financial Reporting Center > Tasks panel drawer > Open Workspace for Financial Reporting.

  2. Edit the Workspace URL and remove workspace/index.jsp.

  3. Following are two examples of Server URLs:

    • If the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp, the Server URL is https://fusionsystemtest-p-external-bi.us.oracle.com.

    • If the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com:10622/workspace/index.jsp, the Server URL is https://fusionsystemtest-p-external-bi.us.oracle.com:10622.

  4. Copy the modified URL to the Server URL field.

Note: For end users installing the Oracle Fusion Financials Reporting Studio, the installer starts a separate console window. The installer continues to run for a brief time after the installation completes the setup tasks. The process is normal, expected, and applies to Oracle Reporting Studio installations in both the Oracle Fusion Applications and Enterprise Performance Manager modes.

Wait for the console window to close, which happens automatically, before clicking the Finish button on the Financial Reporting Studio Installation dialog box. If you click the Finish button before the console window closes, the Financial Reporting Studio installation may not complete.

Note: You must save a new report before attempting to preview it with Web Preview.

Prerequisites needed for installing the Financial Reporting Studio are:

  1. Financial Reporting Studio Client Certifications that are found at: http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html.

  2. Microsoft Office installed on your end-users computers.

Installing Smart View

Smart View is an Excel add-in that must be loaded on each client. To download Smart View, click Navigator > Financial Reporting Center > Tasks panel drawer > Open Workspace for Financial Reports. Once the workspace is started, click Tools > Install > Smart View.

Note: Since Smart View is an add-in to Microsoft Office products, you can install Smart View only on a Windows operating system.

Once Smart View is installed, you must configure the connection using the Smart View Shared Connections URL. You can derive the Shared Connections URL by following these steps:

  1. From the Financial Reporting Center task panel, select Open Workspace for Financial Reporting.

  2. Edit the workspace URL by removing index.jsp and adding SmartViewProviders at the end.

    Note: The following URL is an example for a Cloud-based environment. If the workspace URL is https://efops-rel5st4-cdrm-external-bi.us.oracle.com:10622/workspace/index.jsp, the Shared Connections URL is https://efops-rel5st4-cdrm-external-bi.us.oracle.com:10622/workspace/SmartViewProviders.
  3. Copy the URL.

  4. Open Excel.

  5. From the Smart View menu, click Options > Advanced.

  6. Paste the URL in the Shared Connections URL field.

  7. Click OK.

For more information about configuring Smart View client for users, see the Oracle Smart View for Office User's guide.

To connect Oracle Fusion General Ledger Balances cubes in Smart View:

  1. Open Smart View from your Start menu > Programs > Microsoft Office > Microsoft Excel 2007.

  2. Navigate to the Smart View menu > Open. On the Start on the ribbon, click on Smart View Panel that appears in the list of values under the ribbon. The task pane opens.

  3. Click on the Shared Connections button on the task pane.

  4. Sign in with your user name and password.

  5. Click on the Select Server to proceed list of values.

    Note: If the Essbase Server is not there, then it has to be added. Use the following steps:
    1. Click on the Add Essbase Server link on the bottom of the spreadsheet.

    2. Specify the Essbase Server login and password.

    3. Expand the Essbase server and locate the cube under it.

  6. Select Oracle Essbase from the list of shared connections.

  7. Expand the list of cubes.

  8. Expand your cube (name of your chart of accounts).

  9. Click on db. A list of functions appears on the bottom of the panel.

  10. Click the Ad hoc analysis function.

Note: You must perform these steps only once for a new server and database.

To set how the name and alias of the Essbase database appears:

  1. Click Options on the ribbon. Select Member Options > Member Name Display.

  2. Set one of these three options:

    • Distinct Member Name. Only shows the full Essbase distinct path.

    • Member Name and Alias: Shows both the member name and the alias.

    • Member Name Only. Shows only the member name.

Note: The Smart Slice feature is not supported in General Ledger. For all other documentation, refer to the Oracle Smart View for Office User's Guide.

Configuring Workspace Database Connections

Administrators must create database connections from Workspace so users can access the cubes from Workspace and Financial Reporting Studio.

Note: Ledger setup has to be completed before the database connection can be created. General Ledger balances cubes are created as part of ledger setup. A separate cube is created for each combination of chart of accounts and accounting calendar. A database connection is needed for each cube.

Steps to define a database connection are:

  1. Start at the Navigator by selecting Financial Reporting Center.

  2. From the Financial Reporting Center task panel, select Open Workspace for Financial Reporting.

  3. From within Workspace select the Navigator menu > Applications >BI Catalog.

  4. Select Tools menu > Database Connection Manager.

  5. Select New button.

  6. Enter a user-friendly name for the Database Connection Name.

  7. Enter Essbase as the Type, your server, user name, and password.

  8. Select Application (cube) and Database from the list of values. Expand the Application name to see the related Database, for example, db.

  9. Click the OK button twice to save your selections.

  10. Click Close button in the Database Connection Manager window to save your connection.

For more information about configuring Essbase database connections in Workspace see: Database Administrator's Guide for Oracle Essbase.

Note:

The database connection is available in both Workspace and Financial Reporting Studio. Optionally, it can be set up in Financial Reporting Studio when putting grids on a report. This should only be done by an administrator.

Configuring Oracle Transactional BI Dimensions

Within Oracle Transactional Business Intelligence (BI), Accounting Segment Dimensions such as Balancing segment or Cost Center segment are based on the Chart of Accounts configuration. These segments can be configured to be tree-enabled, which means that hierarchies are defined upon the segment values for rollup purposes. In such scenarios, you must filter by a specific hierarchy when performing ad hoc queries against tree-based accounting segments. Incorrect results may occur if tree filters are not applied. To apply tree filters, create a filter condition on Tree Filter attributes in Accounting Segment Dimensions.

Note: For information, see: Administering Transactional Analyses at http://docs.oracle.com/cloud/latest/common/OATBI/toc.htm.

Mapping to Work Areas

Setting Up the Reports and Analytics Pane: Procedure

You can find the Reports and Analytics pane in many work areas, and the analytics and reports you see in the pane depends on the work area. You can define what's available for a specific work area, by mapping reports from the business intelligence (BI) catalog to that work area. In this mapping context, reports refer to both analytics and reports. Your changes apply to all users who have access to the work area you're mapping.

Mapping Reports from Your Work Area

To map reports to the work area that you're in:

  1. Click the Edit Settings icon in the Reports and Analytics pane.

    You see all the reports that are currently mapped to your work area.

  2. Click Select and Add.

  3. Find the report in the catalog and select it.

  4. Click OK.

  5. To remove any mapping, select the report and click Remove.

  6. Save your work.

Mapping Reports to Any Work Area

To map reports to any work area that you have access to:

  1. Go to the Setup and Maintenance work area and open the Map Reports to Work Areas task.

  2. Select the application of the work area you want to map to.

  3. Select the work area.

  4. Click Search and see all the reports that are currently mapped to that work area.

  5. Click Select and Add.

  6. Find the report in the catalog and select it.

  7. Click OK.

  8. To remove any mapping, select the report and click Remove.

    Tip: Click Synchronize to remove all mappings to any reports that are no longer in the catalog. You synchronize all work areas, not just the one you're mapping.
  9. Save your work.

Why can't I see reports when mapping reports to work areas for the Reports and Analytics pane?

Either no reports are currently mapped to the work area you select on the Map Reports to Work Areas page, or you don't have access to the reports that are mapped.

Similarly, when you're selecting a report to map, you can see only the reports that you have access to. Ask your administrator to either:

  • Assign you roles that have access to the reports you want to map to work areas.

  • Grant the Reports and Analytics Region Administration Duty to someone who already has access to those reports.

Why can't I see reports when I edit settings for the Reports and Analytics pane?

In the Edit Settings window, you might not see a currently mapped report because you don't have access to it.

Similarly, when you're selecting a report to map, you can see only the reports that you have access to. Ask your administrator to either:

  • Assign you roles that have access to the reports you want to map to work areas.

  • Grant the Reports and Analytics Region Administration Duty to someone who already has access to those reports.

Configuring Business Intelligence Publisher

Managing Report Delivery Servers: Overview

Oracle Business Intelligence Publisher, the report generation and delivery engine, requires configuration and tuning to deliver reports to users.

Report requests are received by Publisher from:

  • Oracle Enterprise Scheduler

  • The Reports and Analytics pane

  • Application pages

Requests submitted through Oracle Enterprise Scheduler are processed by the Oracle BI Publisher scheduler. Requests submitted through the Reports and Analytics pane can be either real-time online requests or scheduled requests. Requests submitted through an application may invoke Oracle Enterprise Scheduler or may return report request results directly back to the application page.

Oracle BI Publisher is configured to accept requests from Oracle Applications Cloud. However, before you can deliver report documents to their destinations, you must define the delivery servers in Oracle BI Publisher. Use the Oracle BI Publisher Administration page to define your delivery servers.

Once delivery servers are defined, you can further configure the number of report processor and delivery threads to best handle your processing and delivery requirements. In addition, you can configure report properties for the system or at the report level to tune performance of your reports. To diagnose report processing issues, BI Publisher provides a set of scheduler diagnostics.

Navigating to the Oracle BI Publisher Administration Page: Procedure

You use the Oracle BI Publisher Administration Page to perform most tasks related to report delivery and performance.

Use the Oracle BI Publisher Administration page to:

  • Configure delivery servers

  • Manage report and delivery processors

  • View scheduler diagnostics

  • Set system properties and report runtime configuration properties

Request the Oracle Applications Cloud security administrator to assign the BI Platform Administrator duty role (BI stripe) to the person responsible for administering BI analyses, dashboards, and BI Publisher reports. Administration tasks include security permissions for objects, organizing objects into folders, accessing log files, and several other tasks.

Navigating to the Administration Page

To navigate to the Oracle BI Publisher Administration page:

  1. Under Tools, click Reports and Analytics.

  2. In the Reports and Analytics pane, click Catalog.

  3. In the Catalog page, click Administration, then click Manage BI Publisher.

Configuring Report Delivery Servers: Procedure

Set up the report delivery servers to support printing.

Configuring Servers

To configure delivery servers:

  1. From the BI Publisher Administration page, click Delivery Configuration.

  2. Enter values in the Delivery Configuration Options tab to set general properties for email deliveries and notifications.

  3. To configure a delivery server, click the appropriate tab.

Understanding the Report and Delivery Processors: Overview

When Oracle Enterprise Scheduler initiates a job, it is picked up by the BI Publisher scheduler queue.

  • Job Processor: Listens for requests from the scheduler queue. When the job information is received, the job processor executes the data model (and splits the data for bursting jobs), stores the data in the shared temporary folder, and sends the report metadata to the report queue.

  • Report Processor: Listens for requests from the report queue. When the report information is received, the report processor generates the report documents, stores it in the shared temporary folder and puts the delivery information in the delivery queue.

  • Delivery Processor: Listens to the delivery queue and handles the delivery of reports for its channel. The delivery processors are:

    • Email Processor

    • File Processor

    • FTP Processor

    • Print Processor

    • WebDAV Processor

    • Fax Processor

Managing Report Processing and Delivery Server Load: Procedure

Manage the processors in the BI Publisher Scheduler Configuration page.

Managing Processing and Server Load

By default, each processor is enabled and the thread count for each is set to five. For each managed server that is running in the BI cluster, a table for that instance's processors is displayed. Use the table to enable or disable processors for the instance and configure the thread counts.

To configure processor threads:

  1. From the BI Publisher Administration page, click Scheduler Configuration.

  2. In the the Cluster Instances region of the Scheduler Configuration page, enter the Number Threads value in the processor configuration table.

  3. All processors are automatically set to use the number of threads defined in the Threads Per JMS Processor value of the JMS Configuration region of the page. Enter a value in the Number Threads column to change the value from this default.

After performing the scale-out procedure, configure the processor threads for each cluster instance using the steps above.

Diagnosing Report Processing Issues: Procedure

The Scheduler Diagnostics page provides the runtime status of the scheduler. It provides status of its JMS configuration, JMS queues, cluster instances, scheduler Database, Top link, and Oracle Enterprise Scheduler.

Diagnosing Issues

To access the Scheduler Diagnostics page:

  1. Navigate to the Oracle Business Intelligence Publisher Administration page.

  2. In the System Maintenance group, click Scheduler Diagnostics.

Configuring System Properties for Reports: Procedure

Use the Oracle BI Publisher Runtime Configuration page to set the system-level runtime properties for reports.

Configuring Reporting Properties

To access the Runtime Configuration page:

  1. Navigate to the Oracle Business Intelligence Publisher Administration page.

  2. In the Runtime Configuration group, click Properties.

Uploading PGP Public Key Files to GPG Keystore: Procedure

To support encrypted communication channel from the BI Publisher Server to an FTP site, you upload a PGP public key file to a GPG keystore on the cloud and then provide it to a registered FTP location.

Uploading PGP Keys

You upload, test, and delete PGP keys in the BI Publisher Administration page.

To upload PGP keys:

  1. Navigate to the BI Publisher Administration page.

  2. In the Security Center section, click the PGP Keys link to open the PGP Keys page.

  3. In the PGP Keys section, click Browse and select the PGP key file in the Open dialog box.

  4. Click OK.

  5. Click Upload. After the file is uploaded, it is imported into the keystore and its details are visible in the PGP Keys table. If a key with the same ID is imported again, the file is overwritten.

  6. Click the Download icon of the key in the Encrypted Test Output column of the PGP Keys table to download and decrypt a test output file using the secret key of the imported public key. Successful decryption confirms the encryption is working for your keys.

Deleting a PGP Key

To delete an imported public key, click the Delete icon.

Configuring an FTP Delivery Channel Using PGP Keys

To create an FTP channel:

  1. Navigate to the BI Publisher Administration page.

  2. In the Delivery section, click the FTP link to open the FTP page.

  3. Add a new FTP Server and click Test Connection to test it. The Filter Command field is read-only and is updated automatically when you select a PGP key.

  4. Select the PGP Key ID of the key you uploaded from the drop-down.

  5. Select the true check box for Sign Output to sign the encrypted document. If you select this check box, a -s parameter is added to the existing filter command.

  6. Test the connection again to confirm that an encrypted test file is sent to the remote directory. The FTP delivery channel can now be used in a scheduled job.