Creating Analytics with Oracle Business Intelligence Cloud Service

Oracle Business Intelligence Cloud Service (Oracle BI Cloud Service) enables you to create, manage, and deploy analytics data to create your own dashboards. These dashboards are based on business data and allow you to get a broader and better perspective of your business processes. See About Oracle BI Cloud Service in Using Oracle Business Intelligence Cloud Service.

Integrating Oracle BI Cloud Service with Process enables you to archive business analytics from Process into Oracle BI Cloud Service. This integration lets you explore and access your archived data in Oracle BI Cloud Service. Once the archive is complete, you can sign in to Oracle BI Cloud Service and create charts or graphs by selecting data from multiple tables and creating business analytics reports as per your need. See Exploring Your Content and Adding Your Own Data in Using Oracle Business Intelligence Cloud Service.

The business analytics reports that you create in Oracle BI Cloud Service help you detect errors in your process and enable you to resolve them. You can also create your own dashboards. See Creating Analyses in Visualizing Data and Building Reports in Oracle Analytics Cloud.

How do I integrate with Oracle Business Intelligence Cloud Service?

Before you or any users can use and access Oracle Business Intelligence Cloud Service (BI Cloud Service), an administrator must configure settings in both Oracle Business Intelligence Cloud Service and Process.

Pre-requisites:

To create the integration between BI Cloud Service and Process, the administrator must ensure:
  • The user is subscribed to both BI Cloud Service and Process.

  • Analytics data is being captured in Process Database.

  • User in BI Cloud Service has the required role for creating/updating tables in BI Cloud Service.

Configuring BI Cloud Service Settings in Process

As the administrator, you must also configure the connection between your Process and your Oracle BI Cloud Service. You need to enter information such as the URL and sign-in credentials for your Oracle BI Cloud Service. You can also add a unique table name prefix for each of the instances you archive.

To configure the settings in Process:
  1. Go to the Home page, click Configure.
  2. Click Services.
  3. In the Business Intelligence Cloud Service section, enter the following information:
    • URL: the web address of your Oracle Business Intelligence Cloud Service, for example, https://mybicloudservice-myidentitydomain.analytics.us1.oraclecloud.com
    • Identity Domain: the name of the identity domain that your Oracle Business Intelligence Cloud Service belongs to.
    • Database Table Name Prefix: unique prefix for the table names in the BI Cloud Service Database.

      Note:

      If you have only one BI Cloud Service instance and multiple Process instances, then for each instance, the table name in the BI Cloud Service database can be unique with a prefix. However, this is an optional attribute and if you don't enter a prefix, the default prefix “PCS” will be used in the table names.
    • User and Password: the account credentials for a user who has access to your Business Intelligence Cloud Service. This user account is used for testing the connection between the services and for transferring the analytics data to BI Cloud Service.
  4. Click Test.

    Whenever you make any changes to the configuration settings, it’s a good idea to verify that the values you entered are correct. You want to confirm that a successful connection has been established with Oracle Business Intelligence Cloud Service.

    Review the test results, which may include messages, errors, and warnings.

  5. Select one of the following options to continue:
    • If there are any errors or warnings, make the necessary changes and then click Test again to verify the new values. Repeat the test each time you change the settings.
    • If the connection test is successful, click Save to save the configuration settings.
    • If you want to cancel and return to the last-saved values, click Revert.
Oracle BI Cloud Service is successfully configured in Process. To archive process analytics, see Scheduling Analytics Data Archive and Purge in Using Oracle Business Intelligence Cloud Service.

Creating Charts and Graphs in Oracle BI Cloud Service

After you enable your BI Cloud integration, the archived analytics data gets saved in different tables in Oracle BI Cloud Service:
  • PCS_<Application Name>_ACTIVITY

  • PCS_<Application Name>_PROCESS

  • PCS_PROCESS

  • PCS_ACTIVITY

  • PCS_TASK

  • PCS_ASSIGNMENT

  • PCS_COMPOSITE_DEFINITION

  • PCS_PROCESS_DEFINITION

  • PCS_ACTIVITY_DEFINITION

  • PCS_TASK_DEFINITION

  • PCS_ROLE_DEFINITION

Note:

If the name of the application exceeds 30 characters, then the table name for the same gets shortened in Oracle BI Cloud Service. The data is stored in tables with names prefixed with "PCS_" by default.

An administrator can sign in to Oracle BI Cloud Service, and create charts and graphs using the data from these tables. You can select the data from multiple tables and create a business analytic report as per your need. See Creating Analyses and Building Dashboards in Visualizing Data and Building Reports in Oracle Analytics Cloud.

Note:

If you switch to a new Oracle BI Cloud Service instance, you can migrate your data from the old system to the new one. See Downloading, Uploading, and Migrating Snapshots in Preparing Data in Oracle Business Intelligence Cloud Service.