Setting Application and System Properties

You can add or change application or system properties to customize such aspects as the path to the external authentication configuration file.

Table 2-1 Examples of Configurable Properties

PROPERTY_NAME Column	Description
RDB_DRIVER RDB_SERVER_URL	See Changing the JDBC Driver.
JDBC_MIN_CONNECTIONS JDCB_MAX_CONNECTIONS	See Configuring JDBC Connection Pooling.
SUPPORTING_DETAIL_CACHE_SIZE	See Allocating Memory for Supporting Detail Cache.
SUBST_VAR_CACHE_LIFETIME	See About Selecting Substitution Variables as Members.
DIRECT_DATA_LOAD DATA_LOAD_FILE_PATH	See Loading Data.
OLAP_MAX_CONNECTIONS	See Optimizing Performance.
SMART_VIEW_DISPLAY_WARNING	See Controlling Smart View Messages.
SMART_VIEW_MD_NEW_MEMBER_SUFFIX	See Selecting the Add Mode within Planning Application Properties.
SMART_VIEW_MERGE_FORMATTING	See Controlling Smart View Cell Formatting in Planning Forms.
HOME_PAGE	See Setting the Application Home Page.
RULE_MAX_WAIT, RULE_MONITOR_DELAY, CLR_CELL_MAX_WAIT, CLR_CELL_MONITOR_DELAY, COPY_DATA_MAX_WAIT, COPY_DATA_MONITOR_DELAY, PUSH_DATA_MONITOR_DELAY, PUSH_DATA_MAX_WAIT JOB_STATUS_MAX_AGE	See Setting Background Processing.
BUSINESS_RULE_LAUNCH_LOG_ENABLED BUSINESS_RULE_LAUNCH_LOG_RTP_VALUES BUSINESS_RULE_LAUNCH_LOG_CALC_SCRIPT	See Setting Business Rules Launch Logging Properties.
CAPTURE_RTP_ON_JOB_CONSOLE	See About Runtime Prompts.
MAX_VALIDATION_RECORDS VALIDATION_CACHE_SIZE	See Setting Data Validation Properties.
MAX_CELL_TEXT, MAX_CELL_NOTE	See Setting the Maximum Length for Text Values and Comments in Cells.
DATA_GRID_CACHE_SIZE	See Specifying How Many Forms Users Can Simultaneously Use.
WARNING_THRESHOLD_NUM_OF_CELLS, ERROR_THRESHOLD_NUM_OF_CELLS, WARNING_THRESHOLD_NUM_OF_PUS, ERROR_THRESHOLD_NUM_OF_PUS, WARNING_THRESHOLD_FOR_NUM_DIMS, ERROR_THRESHOLD_FOR_NUM_DIMS, WARNING_THRESHOLD_FOR_NUM_ACCOUNTS, WARNING_THRESHOLD_FOR_NUM_ENTITIES, WARNING_THRESHOLD_FOR_NUM_VERSIONS, WARNING_THRESHOLD_FOR_NUM_SCENARIOS, WARNING_THRESHOLD_FOR_NUM_YEARS, WARNING_THRESHOLD_FOR_NUM_CURRENCIES, WARNING_THRESHOLD_FOR_NUM_PERIODS, WARNING_THRESHOLD_FOR_NUM_CUSTOM_DIM_MBRS, WARNING_SYNC_THRESHOLD_FOR_NUM_BLOCKS, ERROR_SYNC_THRESHOLD_FOR_NUM_BLOCKS, WARNING_ASYNC_THRESHOLD_FOR_NUM_BLOCKS, ERROR_ASYNC_THRESHOLD_FOR_NUM_BLOCKS, WARNING_SYNC_THRESHOLD_FOR_NUM_PASSES, ERROR_SYNC_THRESHOLD_FOR_NUM_PASSES, WARNING_ASYNC_THRESHOLD_FOR_NUM_PASSES, ERROR_ASYNC_THRESHOLD_FOR_NUM_PASSES, WARNING_THRESHOLD_FOR_CUBE_LINK_NUM_BLOCKS, ERROR_THRESHOLD_FOR_CUBE_LINK_NUM_BLOCKS	See Setting Threshold Limits for Applications.

Note:

In some cases, additional properties may be visible in the Properties page. Because the following properties are required by Oracle Hyperion Planning, they should not be changed even if they are visible: SYSTEM_DB_RELEASE and SYSTEM_DB_VERSION.

To set Planning application or system properties:

Select Administration, then Application, and then Properties.
Select:
- Application Properties: Set properties for the current application.
- System Properties: Set properties for all Planning applications.
To:
- Change a property, change its value under Property Value.
- Add a property, click Add. Enter a name (avoid using spaces) and value for the property in the blank row.
  
  If you enter a property already on the tab, its name turns red to indicate that it is a duplicate. You can duplicate properties between the application and system tabs.
Click Save and confirm your changes.
Stop and then restart the application server.

Properties are saved in the HSPSYS_PROPERTIES system database table, which by default is located in the relational database that you create when selecting the Configure Database task under Planning in EPM System Configurator.