Registering Enterprise Profitability and Cost Management Applications
When you register an Enterprise Profitability and Cost Management external application into Oracle Enterprise Data Management Cloud, an application and default view are created which represent the external application.
Before you begin:
- Ensure that you have the Application - Create role to register an
application. After the registration, you are automatically granted
the Owner permission on the application and the default view.
Note:
The Service Administrator assigns roles, see Understanding Application Roles and Permissions. - Decide which dimensions you want to register. You must register all the cubes associated with each dimension. You can register two dimension types: Entity and Custom.
- When you add a cube to a new or existing application, the data storage
property for the cube (for example, PLN.Data Storage
(PCM_CLC)) is automatically set to be derived from
the application default data storage property (PLN.Data
Storage). See Derived Properties.
Note:
Editing an existing cube by modifying an application's registration will not set the data storage property for the cube to be derived from the application default. If you want the value for the cube data storage property to be derived from the application default, you must set up an application override. See Editing Property Parameters.
For more information, see Understanding Registering Applications.
To register an Enterprise Profitability and Cost Management application:
- From Applications, click Register, and then select Enterprise Profitability and Cost Management.
- Enter an application name and description.
Note:
The application type, name and description are displayed in the Application list. - If you are using a local csv (comma-delimited) file for your dimension, skip the next step.
- If you are connecting to an external application, click
Add, and define the connection
settings. You can add multiple application connections.
Field Valid Values Example: connecting to an external application Connection Name
Enter a required connection name, unique to this application.
US Enterprise Profitability Cloud Connection
Connection Description
Enter an optional description.
Use this connection to connect to an Enterprise Profitability and Cost Management application.
Instance Location
Enter a connection URL to the external application in the format:
https://InstanceName-Cloud_Account_Name.EPM_Cloud_Family.Data_Center_Region.ocs.oraclecloud.com/Context
See Sample EPM Cloud URLs in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
Identity Domain
Enter the identity domain of the external application (not required for OCI (Gen 2) URLs).
Note:
This is the same as the Cloud Account Name used in the Instance Location.epmid
Username
Enter an authorized user name
Note: The user must be a Service Administrator of the external application, and they cannot be authenticated using corporate SSO (identity provider) credentials.
tom.smith
Password
Enter a password.
xxxxxxxx
Primary Connection
Select this check box to make this the default for importing from and exporting to the external application.
- Review the application summary information, and then click
Create.
Note:
The application and default view are created and set to draft mode. The default view name is the same as the application name you specified above. - Continue the registration, see Registering Enterprise Profitability and Cost Management Cubes, Application Settings, and Dimensions.