1. Using Oracle Essbase
  2. Integrate Essbase with Autonomous Database Using Federated Partitions
  3. Federated Partitions Workflow

Federated Partitions Workflow

Federated partitions are a type of partition that enables Essbase to directly query Autonomous Data Warehouse, removing the need to load data into the Essbase cube.

The workflow to use federated partitions is:

  1. Review the Prerequisites for Federated Partitions.

  2. Log in to your organization's Oracle Cloud Infrastructure tenancy.

  3. Optional: Provision an instance of Autonomous Data Warehouse, and set up a new, empty schema. (You may instead choose to provision one during the next step).

    Note:

    Here and elsewhere in this federated partitions documentation, all references to Autonomous Data Warehouse should be considered to mean Oracle Autonomous Database Serverless with Autonomous Data Warehouse workload type.

    See Provision an Autonomous Data Warehouse for Federated Partitions.

  4. From the Marketplace listing in Oracle Cloud Infrastructure, deploy an Essbase stack to the same tenancy. See Deploy Essbase from Marketplace for Federated Partitions.

  5. Create an Essbase application and cube.

    Select a BSO or ASO application and cube as the starting point. Depending on your circumstances, the starter cube may already exist, or you may create a new one and then create the federated partition over it.

    If you are not sure which type of cube to start with, review the comparison table in Integrate Essbase with Autonomous Database Using Federated Partitions.

  6. Create a fact table in the empty Autonomous Data Warehouse schema.

    For guidelines on fact tables (and pivot dimensions), see Learn About Fact Tables and Pivot Dimensions.

  7. Define a connection that enables Essbase to access the schema on Autonomous Data Warehouse, as shown in Create a Connection for Federated Partitions.

    To create a global connection, you need to have the service administrator role. To create an application level connection, you need to have user role, plus application manager permission on the application.

  8. Log in to the Essbase web interface and create the federated partition, as described in Create a Federated Partition.

  9. Complete a workflow to enable Essbase data load operations to the fact table in Autonomous Data Warehouse. See Federated Partition Data Load.

  10. Learn about maintaining and troubleshooting the federated partition. See Federated Cube Maintenance and Troubleshooting.