DISABLEREPLMISSINGDATA
The DISABLEREPLMISSINGDATA configuration setting instructs Essbase not to replicate #MISSING values to a target partition, thus improving performance, potentially with less accurate data.
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
DISABLEREPLMISSINGDATA 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