Registering Planning and FreeForm Applications
When you register a Planning or a FreeForm external application into Oracle Enterprise Data Management Cloud, an application and default view are created which represent the external application.
Videos
Your Goal | Watch This Video |
---|---|
Learn about registering Planning applications. |
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 three dimension types: Account, Entity, and User Defined.
- When you add a cube to a new or existing application, the data storage property for cube (for example, PLN.Data Storage (Plan 1)) 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 a Planning or FreeForm application:
- From Applications, click Register.
- Select one of these application types:
- Planning
- Planning Modules
- FreeForm
- 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 Planning Cloud Connection
Connection Description
Enter an optional description.
Use this connection to connect to a Planning 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 Cubes, Application Settings, and Dimensions.