Enables support of null values in columns of dimension tables that are used to create dimensions for Hybrid Analysis-enabled outlines.
HARAGGEDHIERARCHY [appname [dbname]] TRUE | FALSE
appname—Optional. If you supply an application name, the setting applies to all databases within the named application. If you do not supply an application name, the setting applies to all applications and databases on the Essbase Server.
dbname—Optional. If you supply a database name and an application name, the setting applies only to the named database. If you do not also provide an application name, the database is ignored and the setting applies to all applications and databases on the Essbase Server.
TRUE—Setting the value to TRUE enables Hybrid Analysis to account for null values during SQL generation. Note that this setting may have impact on performance because SQL generation is not optimized well on most relational databases.
FALSE—Setting the value to FALSE prevents Hybrid Analysis from recognizing the null values or gaps in the ragged hierarchy. This option does not affect performance. The default is FALSE.
This setting enables support of null values in columns of dimension tables that are used to create dimensions for Hybrid Analysis-enabled outlines. The dimension build that these dimension tables result in the outlines are known as ragged hierarchies.
If you have null values in columns of dimension tables used to create dimensions in a Hybrid Analysis-enabled outline, use the HARAGGEDHIERARCHY setting in essbase.cfg to enable Hybrid Analysis to account for these null values during SQL generation.
In the following example, TRUE enables Hybrid Analysis to account for null values during SQL generation.
HARAGGEDHIERARCHY TRUE