ROOT

Description

This function returns the indexed root of the specified dimension hierarchy.

This function is designed specifically to allow you to view the root level member under a specific dimension with a hierarchical structure. The function displays the name of the member at the specified index under the specified dimension. The function takes as a parameter the name of the dimension which has the hierarchy with member names that are to be accessed, and the index of the root for the member whose name you wish to access from the hierarchy.

Syntax

ROOT (dimension, index)

Dimension : Enter the name of the dimension which exists in this database mentioned above and is the dimension whose members you wish to access.
Index : Enter the index number of the root that exists under the dimension specified above, and corresponds to a member, the name of which will be the result of the formula.

Remarks

The name of the dimension must be a valid name and should exist in the database.
The index number for the root must be a valid number corresponding with a specific member in the dimension and should not be a number that is smaller or greater than a valid number for the members in that dimension.
The value for parameter "index" must be a positive real integer.
Both arguments are compulsory.

Example

=ROOT ("Account", 1)	-Returns the 1st root level member from the dimension Account. (Member returned is " ")
=ROOT ("Region", 2)	-Returns the 2nd root level member from the dimension Region. (Member returned is " ")
=ROOT ("Month", 3)	-Returns the 3rd root level member from the dimension Month. (Member returned is " ")