EssGetMemberInfo

Description

Gets information about member relationships.

Syntax

EssGetMemberInfo([workbookName]sheetName, MemberName, Action, Aliases, Destination)

Where [workbookName]sheetName is the text name of the workbook and worksheet where the options are set.

MemberName is the text name for a member for which information is retrieved.

Action is a number that specifies the type of relationship you want. The action arguments and return values are shown in Table 26.

Table 26. Action Arguments and Return Values

ActionReturn Value

1

Next or child level

2

All or descendent level

3

Bottom or leaf level

4

Sibling level

5

Same level

6

Same generation level

7

Calculation level

8

Previous or parent level

9

Dimension member belongs to

Aliases is a Boolean value that indicates whether alias names are returned.

Destination is the range of cells where you want to display the results.

Example

=EssGetMemberInfo("[Sample.xls]Sheet1","Year",1,TRUE,B1)

Notes: