Setting Planning Properties

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

Table 15. 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.
OFFLINE_COMPRESSION_THRESHOLD	See Setting Offline Compression.
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_PATH_SEPARATOR	See Configuring Data Synchronization on UNIX.
ENABLE_FOR_OFFLINE	See Setting Data Form Precision, Display Properties, and Other Options.
SMART_VIEW_DISPLAY_WARNING	See Controlling Smart View Messages.
RULE_MAX_WAIT, HBR_MAX_WAIT_FOR_RULE, HBR_MONITOR_DELAY, 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.
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.

Note:

In some cases, additional properties may be visible in the Properties page. Because the following properties are required by 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, 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 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 you create when selecting the Configure Database task under Planning in Oracle's Hyperion Enterprise Performance Management System Configurator.