Data Applications → Power BI dashboards for Oracle EBS

This guide shows you how to install and configure this data application.

What does it do?

This data application significantly shortens the time it takes to find insights in your Oracle EBS data using Power BI dashboards with Incorta. After deploying and loading your Oracle EBS data in Incorta, visualize it with our customizable Power BI dashboards. This application includes sample dashboards and metrics for multiple Oracle EBS modules.

Answer questions like:

  • Who are our top suppliers?
  • Do they have any outstanding payments due?
  • Which booked orders aren’t shipped yet?
  • Which sales orders are open?

Requirements

To install this data application you need:

  • Microsoft Power BI installed and configured. For instructions, check out Integrations → Microsoft Power BI.
  • Read level access for the following business schemas, granted by your administrator:
    • OrderManagementTableau
    • PaymentsTableau
    • GeneralLedgerTableau

Installation steps

Here are the installation steps:

  1. Install the data application
  2. Configure the data application

Step 1: Install the data application

If you’re an administrator, you can install the application in the Incorta Cloud Administrator Portal (CAP). If you’re a different type of user, you can install it in Incorta Analytics.

(Administrators) To install in the CAP:

  1. Sign in to the CAP.
  2. Select Data Apps in the navigation bar.
  3. Search for and Install the following applications: Oracle EBS Procure to Pay, Oracle EBS Order To Cash, Oracle EBS General Ledger, and Power BI dashboards for Oracle EBS.

(Other users) To install in Incorta Analytics:

  1. Sign in to Incorta Analytics.
  2. Select Marketplace in the navigation bar.
  3. Search for and Contact to Install the following applications: Oracle EBS Procure to Pay, Oracle EBS Order To Cash, Oracle EBS General Ledger, and Power BI dashboards for Oracle EBS. Contact to Install contacts your administrator to install the application.

Step 2: Configure the data application

  1. Download the PBIX files using this link.
  2. Access the PBIX file location in Excel under FileOpen ReportBrowse Reports.
  1. Select the PBIX file, then select Open.
  1. In the ribbon, select Transform dataData source settings.
  1. In the Data source settings popup window, select Change source….
  1. In the PostgreSQL database popup window, enter the following details for your instance and select OK:
PropertyDescription
ServerYour cluster’s SQL interface connection string (e.g., incorta-testinstall.sqli.centralincortacloud.com:30642). Located in Incorta under Clusters > select cluster name > Cluster Configurations.
DatabaseYour tenant name (e.g., default)
  1. In the Data source settings popup window, select Edit permissions…
  1. In the Edit Permissions popup window, select Edit.
  1. In the PostgreSQL database popup window, enter your Incorta User name and Password. Select Save.
  1. Select OK in the Edit Permissions popup window.
  2. In the Data Source Settings popup window, select Close.
  1. In the alert message under the Excel ribbon, apply Apply changes.
  2. Save the report under FileSave.
  1. To update the data, select Refresh in the Excel ribbon.

Dashboards

Dashboard nameDescriptionBusiness schema view
EBS_GLGeneral ledger template with KPIs and insightsGeneralLedgerTableau
EBS_Incorta_OrderToCashOrder to Cash template with multiple tabs of KPIs and insightsOrderManagementTableau
EBS_Incorta_ProcureToPayProcure to Pay template with multiple tabs of KPIs and insightsPaymentsTableau