HARAGGEDHIERARCHY

Enables support of null values in columns of dimension tables that are used to create dimensions for Hybrid Analysis-enabled outlines.

Syntax

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.

Description

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.

Example

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