Oracle Analytics Cloud Enterprise Edition integrates with Oracle Planning and Budgeting Cloud. You can build dashboards and analyses to analyze data from Hyperion Planning and Essbase Cubes.
Build Dashboards and Analyzes with Data From Oracle EPM
Oracle Analytics Cloud Enterprise Edition integrates with Oracle Enterprise Performance Planning (Oracle EPM), for example, Planning and Budgeting Cloud. You can build dashboards and analyses to analyze data from Hyperion Planning and Essbase Cubes.
About Integration with Oracle Planning and Budgeting Cloud Service
Oracle Planning and Budgeting Cloud Service is a planning, budgeting, and forecasting solution used by many large, medium, and small companies worldwide to provide enterprise-wide business planning.
You can analyze and build dashboards of data from Hyperion Planning and Oracle Essbase Cubes by importing and querying data from on-premises and cloud data sources. The application metadata enables your report builders to create dashboards and analyses that analyze this data.
Oracle Analytics Cloud supports all EPM Cloud applications, including Planning, Financial Consolidation and Close, Tax Reporting, and so on.
If you have Oracle Enterprise Performance Management (EPM) Cloud Version 19.08 and higher, you can also take advantage of the advanced modelling capabilities provided in Oracle Planning and Budgeting Cloud Service by the Analytic Data Modelling (ADM) driver that's preinstalled with Oracle Analytics Cloud. The driver supports:
- Generation of number columns that support filtering.
- Leaf indicator columns.
- Separate columns per generation for member names and aliases (requires EPM 20.04).
- Attribute dimensions.
- Enhanced performance features.
You can review the Service Description documents to understand licensing requirements for using this feature. See Service Description Documents.
When you import data from Hyperion Planning data sources, both measures and dimensions are imported into your data model.
Prerequisites for Integration with Oracle Planning and Budgeting Cloud
Before you start, make sure you have the required components configured correctly.
Oracle Analytics Cloud Enterprise Edition.
A Windows 64–bit machine on which to run Oracle Analytics Developer Client Tool.
Oracle Analytics Developer Client Tool for Oracle Analytics Cloud Version 5.6. Download it from Oracle Technology Network and install it on a local Windows 64–bit machine.
- Start the Javahost process from the client using:
If you're deploying Oracle Analytics Cloud, (that is, on Oracle Cloud Infrastructure with Oracle-Managed), configure these options:
- Set the JAVA_HOME system environment variable to point to your JDK installation. For example, C:\Program Files\Java\jdk1.8.0_162.
- Edit the file <BIClient_Home>\bi\bitools\bin\admintool.cmd, and below the ESSBASEPATH setting add:
- Run <BIClient_Home>\bi\bifoundation\javahost\bin\startOnClient.bat to start Javahost.
If you need to restart the client, run
stopOnClient.bat, then rerun
If you're deploying Oracle Analytics Cloud-Classic, (that is, Oracle Cloud Infrastructure Classic), configure these options:
<BIClient_Home>\bi\bitools\bin\admintool.cmdwith the instance name:
Configure Oracle Analytics Cloud host and port information in
[JAVAHOST] JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = "host:9506";
Build and Upload an Oracle Planning and Budgeting Cloud Data Model
Build a data model for Oracle Planning and Budgeting Cloud, then upload it to Oracle Analytics Cloud Enterprise Edition.
In your local environment, start Oracle Analytics Developer Client Tool, and create a repository.
Import the Planning and Budgeting metadata:
From the File menu, select Import Metadata to start the import wizard.
In the Select Data Source page, select Hyperion ADM from the Connection Type list.
In the Select Metadata Objects page, enter connection details.
Option Description Connection Type Select Hyperion ADM.
Select Hyperion Planning.
Specify the connection URL as:
Note: Specify the URL-encoded value %3A instead of a colon (:) to separate the host and port number.
User Name and Password
Specify the name and password of a user with administration privileges.
When the import is complete, review the metadata in the Physical Layer.
Description of the illustration planningbudgetingmetadata-gif.gif
- Make sure that you've selected the
Complete your data model:
Cut and paste tables in the Physical layer to the Business Model and Mapping layer and to the Presentation layer.
Description of the illustration planningbudgetingmetadata2-gif.gif
Verify the data model and save it as an .rpd file.
In the Physical layer, edit the Connection Pool for this data source, specify a URL using the URL that you used on the Select Metadata Objects page in step 1, and select Shared logon.
Description of the illustration connectionpooldialog-gif.gif
- Save the repository, and ignore the warning that the database features don't match the defaults.
Upload the data model to Oracle Analytics Cloud. From the File menu, click Cloud, then click Upload, and enter connection information for your Oracle Analytics Cloud instance.