Excel Client:ElemChildIndex

Function

ElemChildIndex(DimensionName, Parent, Child)

This function searches through the specified dimension and returns the index of the child element with refers to the parent element. If the child element is no sub-element of the specified parent element, the function returns -1.

Parameter	Description
DimensionName	Name of the dimension
Parent	Parent-Element in the dimension, which should be the parent of the specified child
Child	Child-Element in the dimension, whose index should be returned

Example

ElemChildIndex("Products";"Colnago";"Rock")

Returns 1, because Rock is the first Child-element of the parent Colnago

ElemChildIndex("Produkte";"Rock";"Colnago")

Returns -1, because Colnago is no child-element of Rock