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 parameter. 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 Analytic Server. |
dbname | Optional parameter. 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 Analytic 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
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |