dimensionRoot

Specifies the dimension and multiple members to use as the root.

Data Sources

Multidimensional

Syntax

dimensionRoot="DimA:NewRootMemberA1,NewRootMemberA2;DimB:NewRootMemberB1,
NewRootMemberB1;..."

where:

Argument Default Description
dimensionNameAndNe
wRootMember
empty string A String which specifies the new root member for the specified dimension or dimensions. The String is in the form:
"DimA:NewRootMemberA;DimB:NewRootMemberB;"

If you specify a dimension without a new root member, the dimension root is reset to the database default root member for that dimension.

dimension none A Dimension object. If dimension appears in a page filter, in the Member Filter, or if a member is null, then the database uses its default dimension root. acts as the root of the dimension.
member none A Member object. If member is null, the dimension root resets to the database default.

Usage

If the named dimension appears in a page filter or the Member Filter, the selected member acts as the root of the dimension. If there is conflict between this property value and the query, the query overrides the property.

A unique name (base name in Hyperion Essbase) or display name can be used for the dimension and member name string specified in the property’s value. This allows assemblers to differentiate between different members or dimensions with the same display names. In Hyperion Essbase, an assembler can specify a member, regardless of the alias table in use, by using the base name.

You can have multiple root members for the specified dimension.

The String getdimensionRoot() method returns a String of the form:

"DimA:RootMemberA;DimB:RootMemberB;"

Examples

The following example specifies, as an attribute to the DataBlox custom tag, that the root of the Products dimension is Tools and the root of the Market dimension is East.

dimensionRoot="Products: Tools;Markets: East"
Related reference
query