Default Application Properties
This appendix lists the default application properties that EPMware sets when an application of a given type is first registered. These properties control application-level behavior such as delete permissions, metadata import, node-level security, and target-system connection details.
Editing Defaults
Default values are applied at application registration and can be edited from Configuration → Application Configuration → Application Properties. Review each property against your environment before moving an application to Production.
Production Hardening
Properties such as ALLOW_APPLICATION_DELETE, ALLOW_APPLICATION_DELETE_METADATA, and ALLOW_APPLICATION_IMPORT are typically set to N once an application goes live in Production to prevent accidental loss of metadata.
Application Types
The following application types have default properties documented in this appendix:
- HFM Classic
- Essbase ASO
- Essbase BSO
- Oracle Fusion Cloud
- Hyperion Planning Classic
- PBCS
- Oracle EBS
- FCCS
- OneStream
- FDMEE
- PCMCS
- Anaplan
- SAP Business Objects
- HPCM
- TRCS
- Generic
- NetSuite
- Workday
- Databricks
HFM Classic
Application type: HFM-CLASSIC
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
EPM_INSTANCE_NAME |
epmsystem1 |
Hyperion EPM Instance name |
HYPERION_CLUSTER_NAME |
HFMEPMA |
Hyperion Cluster Name |
HYPERION_HOME |
D:\Oracle\Middleware\EPMSystem11R1 |
Hyperion home directory |
Additional Properties
The following properties may also appear on HFM Classic applications of the same type:
| Property | Default Value |
|---|---|
ConsolidationRules |
N |
DefaultCurrency |
USD |
DefaultRateForBalanceAccounts |
EOMRate |
DefaultRateForFlowAccounts |
AvgRate |
DefaultValueForActive |
1 |
EnableMetadataSecurityFiltering |
Y |
FdmAppName |
TCOFDM |
ICPEntitiesAggregationWeight |
1 |
MaxCellTextSize |
8000 |
MaxDocAttachmentSize |
-1 |
MaxNumDocAttachments |
-1 |
NodeSecurity |
Entity |
OrgByPeriodApplication |
N |
SupportSubmissionPhaseForAccounts |
N |
SupportSubmissionPhaseForDataSourceType |
N |
SupportSubmissionPhaseForICP |
N |
SupportSubmissionPhaseForMovements |
N |
SupportSubmissionPhaseForVarianceType |
N |
UsePVAForBalanceAccounts |
N |
UsePVAForFlowAccounts |
Y |
UseSecurityForAccounts |
N |
UseSecurityForDataSourceType |
N |
UseSecurityForEntities |
Y |
UseSecurityForICP |
N |
UseSecurityForMovements |
N |
UseSecurityForScenarios |
Y |
UseSecurityForVarianceType |
N |
UseSubmissionPhase |
N |
ValidationAccount |
|
ValidationAccount2 |
|
ValidationAccount3 |
|
ValidationAccount4 |
|
ValidationAccount5 |
|
ValidationAccount6 |
|
ValidationAccount7 |
|
ValidationAccount8 |
|
ValidationAccount9 |
Essbase ASO
Application type: ESSBASE-ASO
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
DEPLOY_ALIAS_FOR_SHARED_MEMBERS |
N |
Y/N Flag to indicate whether Alias property values to be sent for Shared instances or not. |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
ESSBASE_CLOUD_URL |
https://<server>/essbase |
* Specify Essbase Cloud URL (Change Server name) if Essbase on cloud is used * |
ESSBASE_DATABASE_NAME |
Basic |
Specify Essbase Database Name |
ESSBASE_TYPE_ENABLED |
N |
Typed Measures Enabled? |
Additional Properties
The following properties may also appear on Essbase ASO applications of the same type:
| Property | Default Value |
|---|---|
EPM_INSTANCE_NAME |
epmsystem1 |
ESSBASE_SERVER_NAME |
localhost |
HYPERION_HOME |
C:\Oracle\Middleware\EPMSystem11R1 |
Essbase BSO
Application type: ESSBASE-BSO
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
DEPLOY_ALIAS_FOR_SHARED_MEMBERS |
N |
Y/N Flag to indicate whether Alias property values to be sent for Shared instances or not. |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
ESSBASE_CLOUD_URL |
https://<server>/essbase |
* Specify Essbase Cloud URL (Change Server name) if Essbase on cloud is used * |
ESSBASE_DATABASE_NAME |
Basic |
Specify Essbase Database Name |
ESSBASE_TYPE_ENABLED |
N |
Typed Measures Enabled? |
Additional Properties
The following properties may also appear on Essbase BSO applications of the same type:
| Property | Default Value |
|---|---|
EPM_INSTANCE_NAME |
epmsystem1 |
ESSBASE_SERVER_NAME |
localhost |
HYPERION_HOME |
C:\Oracle\Middleware\EPMSystem11R1 |
Oracle Fusion Cloud
Application type: ORACLE-FUSION-CLOUD
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
DEPLOY_CONTENT_TYPE |
zip |
|
DEPLOY_JOB_NAME |
oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader,InterfaceLoaderController |
Fusion Job Name |
DEPLOY_JOB_NOTIFICATION_CODE |
10 |
Deploy Notification Code |
DEPLOY_JOB_PARAMETER_LIST |
16 |
Job Parameter List |
DEPLOY_JOB_POLL_TIME |
30 |
# of Seconds to wait for polling |
DEPLOY_JOB_TOTAL_TIME |
60 |
# of minutes to wait for the job to complete |
DEPLOY_OPERATION_CODE |
importBulkData |
Fusion Operation Name |
DEPLOY_ZIP_FILE_PREFIX |
GlSegmentValuesInterface |
|
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
IMPORT_DATE_FORMAT |
RRRR-MM-DD |
Data format for Start and End Dates used during app Import |
ORACLE_FUSION_ERP_INTEGRATION_SUB_URL |
/fscmRestApi/resources/11.13.18.05/erpintegrations |
Sub URL for the ERP Integrations |
ORACLE_FUSION_URL |
https://<Server>.oraclecloud.com/ |
* Specify Server ** |
ORACLE_FUSION_WSDL_URL |
<ORACLE_FUSION_URL>/fscmService/ErpIntegrationService?WSDL |
URL to get WSDL for SOAP APIs |
Hyperion Planning Classic
Application type: HP-CLASSIC
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
EPM_INSTANCE_NAME |
epmsystem1 |
Hyperion EPM Instance name |
HYPERION_HOME |
D:\Oracle\Middleware\EPMSystem11R1 |
Hyperion home directory |
OUTLINE_LOAD_SWITCHES |
/C |
/C is used to refresh cube after deployment. Specify additional custom switches for outline Loads if required. |
PASSWORD_FILE |
Specify Password file with full path for outline Loads | |
PROJECT_FOLDER_NAME |
Planning |
Specify Folder name where planning app is placed |
PlanCapexName |
Capex |
Specify Plan Name |
PlanWorkforceName |
Workforce |
Specify Plan Name |
Additional Properties
The following properties may also appear on Hyperion Planning Classic applications of the same type:
| Property | Default Value |
|---|---|
Plan1Name |
PFAINDL |
Plan1Type |
BSO |
ValidForPlan1 |
Y |
ValidForPlan2 |
N |
ValidForPlan3 |
N |
ValidForPlan4 |
N |
ValidForPlan5 |
N |
PBCS
Application type: PBCS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
PBCS_APP_NAME |
** Specify PBCS Application Name ** | |
PBCS_APP_VERSION |
11.1.2.3.600 |
Application Version |
PBCS_CLEAR_CUBE |
Y |
Y or N flag to indicate whether Clear Cube is enabled or not for this application |
PBCS_CLEAR_CUBE_JOB_NAME |
CLRASOAgg |
Default Job name(s) to clear cubes. Provide comma separated Job Names defined in PBCS app. |
PBCS_CLEAR_CUBE_MAX_TIME_ALLOWED |
30 |
Maximum time allowed before Clear Cube task is timed out |
PBCS_CLEAR_CUBE_PARAM_clearAttachments |
Specify if attachments should be cleared. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection. | |
PBCS_CLEAR_CUBE_PARAM_clearComments |
Specify if comments should be cleared. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection. | |
PBCS_CLEAR_CUBE_PARAM_clearPhysicalOnEssbase |
Specify if this is a physical clear on Essbase. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection or MDX query support. | |
PBCS_CLEAR_CUBE_PARAM_clearSupportingDetails |
Specify if supporting details should be cleared. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection. | |
PBCS_CLEAR_CUBE_PARAM_mdxQuery |
Valid MDX query. Applicable only for Partial Clear Job, for an ASO cube, defined with MDX query support. Example: "Crossjoin({[Apr],[May],[Jun]},{[Expense1]})" | |
PBCS_CLEAR_CUBE_PARAM_members |
Valid member selection that is comma separated. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection. Example: "ILvl0Descendants(Exchange Rates),Total Expense" | |
PBCS_CUBE_AGGREGATION |
Y |
Enable or Disable execution of Cube Aggregation Task |
PBCS_CUBE_AGGREGATION_JOB_NAME |
Optimize Aggregation Process |
Default Job Name to perform Aggregation. App Name and Cube Name will automatically be appended |
PBCS_CUBE_AGGREGATION_MAX_TIME_ALLOWED |
30 |
Maximum time allowed before Cube Aggregation task is timed out |
PBCS_CUBE_AGGREGATION_PARAM_cubeName |
By default run for all ASO Cubes. Override it with specific ASO cube names (comma separated). | |
PBCS_CUBE_AGGREGATION_PARAM_growthSizeRatio |
Aggregates the views the server selects until the maximum growth of the aggregated database exceeds the limits you specify. The value can be a real number such as 1.01. Default is that the database will grow without any growth ratio limit. | |
PBCS_CUBE_AGGREGATION_PARAM_includeAlternateRollups |
Include secondary hierarchies (with default level usage) in the view selection. Permissible values: disable or enable. Default: disable (no secondary hierarchies are considered). | |
PBCS_CUBE_AGGREGATION_PARAM_type |
executeAggregationProcess |
Can take one of these values: enableQueryTracking or executeAggregationProcess |
PBCS_CUBE_AGGREGATION_PARAM_useQueryData |
0 |
Aggregate the views the server selects based on collected user querying patterns. Available if query tracking is turned on AND type is executeAggregationProcess. Permissible values: true or false. |
PBCS_CUBE_REFRESH |
Y |
Y or N flag to indicate Cube Refresh is enabled or not for this application |
PBCS_CUBE_REFRESH_JOB_NAME |
Refresh Metadata |
Default Job Name to Refresh Cube |
PBCS_CUBE_REFRESH_MAX_TIME_ALLOWED |
30 |
Maximum time allowed before Cube Refresh task is timed out |
PBCS_CUBE_REFRESH_PARAM_allowedUsersAfterCubeRefresh |
Allowed users during After Refresh parameter -> Options are Administrators OR All Users | |
PBCS_CUBE_REFRESH_PARAM_allowedUsersDuringCubeRefresh |
Allowed users during cube Refresh parameter -> Options are Administrators OR All Users | |
PBCS_CUBE_REFRESH_PARAM_logOffAllUsersBeforeCubeRefresh |
0 |
Options are true or false (CASE Sensitive) |
PBCS_CUBE_REFRESH_PARAM_terminateActiveRequestsBeforeCubeRefresh |
0 |
Options are true or false (CASE Sensitive) |
PBCS_DATA_CENTER |
us6 |
** Specify PBCS DCx (Data Center Name) such as us1 **. You can determine this from URL |
PBCS_DEPLOY_JOB_FILE_NAME |
EW_IMPORT_<DIMENSION_NAME>.csv |
Job File Name for Deployment |
PBCS_DEPLOY_JOB_NAME |
EW_IMPORT_<DIMENSION_NAME> |
Job Name for Metadata Import |
PBCS_DEPLOY_METADATA_URL |
<PBCS_SERVER_URL>/HyperionPlanning/rest/v3/applications/<PBCS_APP_NAME>/jobs |
URL for Deployment Job |
PBCS_ENVIRONMENT_TYPE |
Classic |
** Specify Environment Type for PBCS App ** Valid values are Classic and OCI (Gen 2) ** |
PBCS_FDMEE_DATA_URL |
<PBCS_SERVER_URL>/aif/rest/V1/jobs |
URL for FDMee Data Load Job |
PBCS_LCM_EXPORT_URL |
<PBCS_SERVER_URL>/interop/rest/<PBCS_APP_VERSION>/applicationsnapshots/<PBCS_LCM_SNAPSHOT_NAME>/migration?q={type:export} |
Application URL for LCM Export |
PBCS_LCM_SNAPSHOT_NAME |
EW_LCM_EXPORT |
LCM Export Snapshot Name |
PBCS_PAYLOAD |
{"jobType":"IMPORT_METADATA","jobName":"<PBCS_DEPLOY_JOB_NAME>","parameters":{"importZipFileName":"<PBCS_PAYLOAD_FILE_NAME>"}} |
Deployment Payload |
PBCS_SERVER_URL |
https://<PBCS_SERVICE_NAME>-<PBCS_TENANT_NAME>.epm.<PBCS_DATA_CENTER>.oraclecloud.com |
Application URL |
PBCS_SERVICE_NAME |
Planning |
** Specify PBCS Service Name such as Planning ** |
PBCS_TENANT_NAME |
** Specify Oracle cloud Tenant Name ** |
Additional Properties
The following properties may also appear on PBCS applications of the same type:
| Property | Default Value |
|---|---|
PBCS_USE_TENAME_NAME_IN_LOGIN |
Y |
Plan1Name |
OPEX |
Plan1Type |
BSO |
Plan2Name |
REP |
Plan2Type |
ASO |
ValidForPlan1 |
Y |
ValidForPlan2 |
Y |
Oracle EBS
Application type: ORACLE-EBS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
APPLY_DATE_SUFFIX_IN_DEPLOY_FILES |
Y |
If enabled Date Suffix (DD_MON_YYYY) will be applied to the Deployment files for EBS. |
DEPLOYMENT_LOG_FILE_DELETE_AFTER_RETRIEVAL |
Y |
* Delete Logfiles after retreival on the Remote Directory * |
DEPLOYMENT_LOG_FILE_EXTENSION |
log |
* Logfile Extension * |
DEPLOYMENT_LOG_FILE_NAME |
LOG_<DEP_FILE_NAME> |
* Logfile Name * |
DEPLOYMENT_LOG_FILE_RETRIEVE |
Y |
* Retrieve Logfile * |
DEPLOYMENT_REMOTE_DIR_INBOUND |
./inbound |
* Specify Folder where EBS Deployment files will be saved * |
DEPLOYMENT_REMOTE_DIR_OUTBOUND |
./outbound |
* Specify Folder from where EBS Log files will be retrieved * |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
PARENT_MEMBER_NAME_FOR_ORPHANS |
Orphan Members |
Create Orphan Members under this Parent member |
FCCS
Application type: FCCS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
HFM_LEGACY_DIM_MAP_ACCOUNT |
Account |
Assign FCCS Dimension which will be mapped when HFM Account dimension is imported |
HFM_LEGACY_DIM_MAP_CUSTOM1 |
Custom1 |
Assign FCCS Dimension which will be mapped when HFM Custom dimension is imported |
HFM_LEGACY_DIM_MAP_CUSTOM2 |
Custom2 |
Assign FCCS Dimension which will be mapped when HFM Custom dimension is imported |
HFM_LEGACY_DIM_MAP_ENTITY |
Entity |
Assign FCCS Dimension which will be mapped when HFM Entity dimension is imported |
HFM_LEGACY_TOP_NODE_PREFIX |
HFM_Legacy_ |
Top Node under which HFM nodes will be inserted for dimensions migrated from HFM Classic application |
PBCS_APP_NAME |
FCCS |
Application Name |
PBCS_APP_VERSION |
11.1.2.3.600 |
Application Version |
PBCS_DATA_CENTER |
us6 |
** Specify PBCS DCx (Data Center Name) such as us1 **. You can determine this from URL |
PBCS_DEPLOY_JOB_FILE_NAME |
EW_IMPORT_<DIMENSION_NAME>.csv |
Job File Name for Deployment |
PBCS_DEPLOY_JOB_NAME |
EW_IMPORT_<DIMENSION_NAME> |
Job Name for Metadata Import |
PBCS_DEPLOY_METADATA_URL |
<PBCS_SERVER_URL>/HyperionPlanning/rest/v3/applications/<PBCS_APP_NAME>/jobs |
URL for Deployment Job |
PBCS_ENVIRONMENT_TYPE |
Classic |
** Specify Environment Type for PBCS App ** Valid values are Classic and OCI (Gen 2) ** |
PBCS_FDMEE_DATA_URL |
<PBCS_SERVER_URL>/aif/rest/V1/jobs |
URL for FDMee Data Load Job |
PBCS_LCM_EXPORT_URL |
<PBCS_SERVER_URL>/interop/rest/<PBCS_APP_VERSION>/applicationsnapshots/<PBCS_LCM_SNAPSHOT_NAME>/migration?q={type:export} |
Application URL for LCM Export |
PBCS_LCM_SNAPSHOT_NAME |
EW_LCM_EXPORT_2 |
LCM Export Snapshot Name |
PBCS_PAYLOAD |
{"jobType":"IMPORT_METADATA","jobName":"<PBCS_DEPLOY_JOB_NAME>","parameters":{"importZipFileName":"<PBCS_PAYLOAD_FILE_NAME>"}} |
Deployment Payload |
PBCS_SERVER_URL |
https://planning3-<PBCS_TENANT_NAME>.pbcs.us2.oraclecloud.com |
Application URL |
PBCS_SERVICE_NAME |
Planning |
** Specify PBCS Service Name such as Planning ** |
PBCS_TENANT_NAME |
a419994 |
Specify PBCS Tenant Name |
Plan1Name |
Consol |
|
Plan1Type |
BSO |
|
Plan2Name |
Rates |
|
Plan2Type |
BSO |
|
ValidForPlan1 |
Y |
|
ValidForPlan2 |
Y |
|
ValidForPlan3 |
N |
|
ValidForPlan4 |
N |
|
ValidForPlan5 |
N |
OneStream
Application type: ONESTREAM
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
OS_APPLICATION_URL |
* Specify OneStream Application Base URL Syntax -> [https://[REST API Web Server]/onestreamapi/api] * | |
OS_APP_VERSION |
5.2.0 |
OneStream REST API Version |
OS_BATCH_DEPLOYMENT_ENABLED |
Y |
Y -> Perform Batch Method of deployment. New DLL is required. |
OS_BIZ_RULE_SEQUENCE_NAME |
Deploy Metadata |
OneStream Business Rule Sequence Name |
OS_REST_API_CLIENT_ID |
* Specify Client ID for REST API Authentication * | |
OS_REST_API_CLIENT_SECRET_KEY |
* Specify Client Secret Key for REST API Authentication * | |
OS_REST_API_SCOPE |
* Specify Scope for REST API Authentication [For example WebApiMachineToMachineScope for OKTA] * | |
OS_REST_API_TOKEN |
* Specify PAT (Personal Access Token from OIS) * | |
OS_REST_API_URL |
* Specify URL for REST API Authentication (To get Access token) * | |
OS_REST_API_USERNAME |
* Specify User Name of the REST API * | |
PARENT_MEMBER_NAME_FOR_ORPHANS |
Orphan Members |
Create Orphan Members under this Parent member |
Additional Properties
The following properties may also appear on OneStream applications of the same type:
| Property | Default Value |
|---|---|
CURRENCYFILTER |
CAD, EUR, GBP, USD |
ENDYEAR |
2020 |
STARTYEAR |
2009 |
UDDIMTYPEFORWFCHANNELS |
UD1 |
FDMEE
Application type: FDMEE
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
EPM_INSTANCE_NAME |
epmsystem1 |
Hyperion EPM Instance name |
FDMEE_DATA_FOLDER_NAME |
c:\FDMData |
Specify Folder with full path where FDMData resides |
FDMEE_REST_API_URL |
http(s)://<webserver>:<port>/aif/rest/V1/jobs |
http(s):// |
FDMEE_VALIDATION_MODE |
0 |
TRUE or FALSE |
HYPERION_HOME |
D:\Oracle\Middleware\EPMSystem11R1 |
Hyperion home directory |
Additional Properties
The following properties may also appear on FDMEE applications of the same type:
| Property | Default Value |
|---|---|
TARGET_APP_TYPE |
HFM |
PCMCS
Application type: PCMCS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
EPMAUTOMATE_BIN_DIR |
c:\oracle\epmautomate\bin |
* Assign directory where EPMAUTOMATE is installed. * |
PBCS_APP_NAME |
** Specify PBCS Application Name ** | |
PBCS_APP_VERSION |
11.1.2.3.600 |
Application Version |
PBCS_DATA_CENTER |
us6 |
** Specify PBCS DCx (Data Center Name) such as us1 **. You can determine this from URL |
PBCS_DEPLOY_JOB_FILE_NAME |
EW_IMPORT_<DIMENSION_NAME>.csv |
Job File Name for Deployment |
PBCS_DEPLOY_JOB_NAME |
EW_IMPORT_<DIMENSION_NAME> |
Job Name for Metadata Import |
PBCS_DEPLOY_METADATA_URL |
<PBCS_SERVER_URL>/HyperionPlanning/rest/v3/applications/<PBCS_APP_NAME>/jobs |
URL for Deployment Job |
PBCS_ENVIRONMENT_TYPE |
Classic |
** Specify Environment Type for PBCS App ** Valid values are Classic and OCI (Gen 2) ** |
PBCS_FDMEE_DATA_URL |
<PBCS_SERVER_URL>/aif/rest/V1/jobs |
URL for FDMee Data Load Job |
PBCS_LCM_EXPORT_URL |
<PBCS_SERVER_URL>/interop/rest/<PBCS_APP_VERSION>/applicationsnapshots/<PBCS_LCM_SNAPSHOT_NAME>/migration?q={type:export} |
Application URL for LCM Export |
PBCS_LCM_SNAPSHOT_NAME |
EW_LCM_EXPORT |
LCM Export Snapshot Name |
PBCS_PAYLOAD |
{"jobType":"IMPORT_METADATA","jobName":"<PBCS_DEPLOY_JOB_NAME>","parameters":{"importZipFileName":"<PBCS_PAYLOAD_FILE_NAME>"}} |
Deployment Payload |
PBCS_SERVER_URL |
https://<PBCS_SERVICE_NAME>-<PBCS_TENANT_NAME>.epm.<PBCS_DATA_CENTER>.oraclecloud.com |
Application URL |
PBCS_SERVICE_NAME |
Planning |
** Specify PBCS Service Name such as Planning ** |
PBCS_TENANT_NAME |
** Specify Oracle cloud Tenant Name ** |
Anaplan
Application type: ANAPLAN
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
ANAPLAN_API_MAJOR_VERSION |
1 |
|
ANAPLAN_API_MINOR_VERSION |
3 |
|
ANAPLAN_API_URL |
https://api.anaplan.com |
|
ANAPLAN_LOCALE_NAME |
en_US |
SAP Business Objects
Application type: SAP-BUSINESS-OBJECTS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
Generation Prefix |
GEN |
HPCM
Application type: HPCM
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
HPCM_ENABLE_APPLICATION |
Y |
Enable Application after metadata deployment |
HPCM_IMPORT_EXPORT_FOLDER |
C:\Oracle\Middleware\user_projects\epmsystem1\import_export |
**** Folder where DataFiles are placed before Updating Dimension ** |
HPCM_RESTRCTURE_CALCULATION_CUBE |
Y |
Refresh Calculation Cube after metadata deployment |
HPCM_RESTRCTURE_REPORTING_CUBE |
Y |
Refresh Reporting Cube after metadata deployment |
HPCM_REST_API_URL |
http://localhost:19000/profitability/rest/v1/ |
* Specify URL for REST API * |
HPCM_UPDATE_DATABASE |
Y |
Update Essbase Database after metadata deployment |
TRCS
Application type: TRCS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
PBCS_APP_NAME |
** Specify PBCS Application Name ** | |
PBCS_APP_VERSION |
11.1.2.3.600 |
Application Version |
PBCS_DATA_CENTER |
us6 |
** Specify PBCS DCx (Data Center Name) such as us1 **. You can determine this from URL |
PBCS_DEPLOY_JOB_FILE_NAME |
EW_IMPORT_<DIMENSION_NAME>.csv |
Job File Name for Deployment |
PBCS_DEPLOY_JOB_NAME |
EW_IMPORT_<DIMENSION_NAME> |
Job Name for Metadata Import |
PBCS_DEPLOY_METADATA_URL |
<PBCS_SERVER_URL>/HyperionPlanning/rest/v3/applications/<PBCS_APP_NAME>/jobs |
URL for Deployment Job |
PBCS_ENVIRONMENT_TYPE |
Classic |
** Specify Environment Type for PBCS App ** Valid values are Classic and OCI (Gen 2) ** |
PBCS_FDMEE_DATA_URL |
<PBCS_SERVER_URL>/aif/rest/V1/jobs |
URL for FDMee Data Load Job |
PBCS_LCM_EXPORT_URL |
<PBCS_SERVER_URL>/interop/rest/<PBCS_APP_VERSION>/applicationsnapshots/<PBCS_LCM_SNAPSHOT_NAME>/migration?q={type:export} |
Application URL for LCM Export |
PBCS_LCM_SNAPSHOT_NAME |
EW_LCM_EXPORT |
LCM Export Snapshot Name |
PBCS_PAYLOAD |
{"jobType":"IMPORT_METADATA","jobName":"<PBCS_DEPLOY_JOB_NAME>","parameters":{"importZipFileName":"<PBCS_PAYLOAD_FILE_NAME>"}} |
Deployment Payload |
PBCS_SERVER_URL |
https://<PBCS_SERVICE_NAME>-<PBCS_TENANT_NAME>.epm.<PBCS_DATA_CENTER>.oraclecloud.com |
Application URL |
PBCS_SERVICE_NAME |
Planning |
** Specify PBCS Service Name such as Planning ** |
PBCS_TENANT_NAME |
** Specify Oracle cloud Tenant Name ** |
Additional Properties
The following properties may also appear on TRCS applications of the same type:
| Property | Default Value |
|---|---|
Plan1Name |
Consol |
Plan1Type |
BSO |
Plan2Name |
Rates |
Plan2Type |
BSO |
ValidForPlan1 |
Y |
ValidForPlan2 |
Y |
ValidForPlan3 |
N |
ValidForPlan4 |
N |
ValidForPlan5 |
N |
Generic
Application type: GENERIC
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
GENERATION_FORMAT_APP_IMPORT |
N |
Application Import format is Generation type (Y or N) |
GENERATION_MEMBER_COLUMN_PREFIX |
GENERATION_ |
Prefix for all Generation columns |
GENERATION_MEMBER_COLUMN_SUFFIX |
_MEMBER_NAME |
Suffix for Member Name columns |
NetSuite
Application type: NETSUITE
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
NETSUITE_ACCOUNT_ID |
* Specify Account Tenant ID * | |
NETSUITE_CERTIFICATE_ID |
* Specify Netsuite Certificate ID * | |
NETSUITE_CLIENT_ID |
* Specify Restlet Consumer Key * | |
NETSUITE_SCRIPT_NAME |
customscript_empware_restlet |
* Specify EPMWARE Restlet Script Name * |
NETSUITE_TOKEN_URL |
https://<NETSUITE_ACCOUNT_ID>.suitetalk.api.netsuite.com/services/rest/auth/oauth2/v1/token |
Access Token URL |
NETSUITE_URL |
https://<NETSUITE_ACCOUNT_ID>.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=<NETSUITE_SCRIPT_NAME>&deploy=1 |
* Specify RESTlet API URL * |
Workday
Application type: WORKDAY
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
Databricks
Application type: DATABRICKS
| Property | Default Value | Description |
|---|---|---|
ALLOW_APPLICATION_DELETE |
Y |
Enable/Disable Delete of Application Metadata. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_DELETE_METADATA |
Y |
Enable/Disable Delete of Application/Dimension Metadata Only.Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_APPLICATION_IMPORT |
Y |
Enable/Disable Application Import. Usually this property is set to N once the applicaiton goes live in Production |
ALLOW_LOCKED_MEMBERS_IN_DIFF_REQUESTS |
N |
Allow users to work on locked members in multiple requests |
ALLOW_REQUEST_DELETE_AFTER_DEPLOY |
N |
Allow or Disallow request and its lines to be cancelled or deleted even if the line is deployed to the target application. Default is N (Not allowed after successful deployment) |
ENABLE_CUSTOM_PROPERTIES_BACKUP |
Y |
This property enables back up of the custom property values. When the application is deleted, custom properties will automatically get backed up and restored as soon as the application is re-imported. |
ENABLE_NODE_LEVEL_SECURITY |
N |
This property enables node level Security using Security Class (EPMWARE) property that can be applied to any member in the dimension.Default value is N |
DATABRICKS_CLIENT_ID |
*** Provide Client ID to generate Token *** | |
DATABRICKS_HOST |
client.cloud.databricks.com |
*** Provide Databricks HOST Name *** |
DATABRICKS_IMPORT_SQL |
select * from |
*** Provide SQL that will be used to fetch Data *** |
DATABRICKS_REST_API_URL |
https://<DATABRICKS_HOST>/api/2.0/sql/statements/ |
*** REST API URL dynamically formed using DATABRICKS_HOST Property *** |
DATABRICKS_SECRET_KEY |
*** Provide Secret Key to Generate Token *** | |
DATABRICKS_SQL_WAREHOUSE_ID |
*** Provide Warehouse ID *** | |
DATABRICKS_TOKEN_URL |
https://<DATABRICKS_HOST>/oidc/v1/token |
*** Token Retrieval URL dynamically formed using DATABRICKS_HOST Property ** |