1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. DISABLEREPLMISSINGDATA

DISABLEREPLMISSINGDATA

This configuration setting instructs Essbase not to replicate #MISSING values to the target partition, thus improving performance, potentially with less accurate data.

You can specify DISABLEREPLMISSINGDATA for individual databases, all databases within an application, or for all applications and databases on the server.

Syntax

DISABLEREPLMISSINGDATA [appname [dbname]] TRUE | FALSE

  • appname—Application name. Optional parameter for applying the TRUE or FALSE setting to one or all cubes within the application. If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified application. If you do not specify an application, you cannot specify a cube, and the setting applies to all applications and cubes on the Essbase Server.

  • dbname—Database (cube) name. Optional parameter for applying the TRUE or FALSE setting to the specified cubes within the specified application. If you do not specify a value for dbname, the setting applies to all cubes within the specified application. If appname is not specified, you cannot specify dbname.

  • TRUE—#MISSING values are not replicated to the target for those applications and cubes specified through the appname and dbname parameters.

  • FALSE—#MISSING values are replicated to the target for those applications and cubes specified through the appname and dbname parameters. This is the default.

Notes

This setting applies only to replicated partitions on block storage cubes.

When #MISSING data is not replicated a warning message is logged in the application log file.

Example

Assume a partition exists from Sample1.Basic (source) to Sample2.Basic (target). To prevent replication of #MISSING data, configure the following.

DISABLEREPLMISSINGDATA Sample1 Basic TRUE
DISABLEREPLMISSINGDATA Sample2 Basic TRUE