ELWEIGHT

ELWEIGHT returns the weight of a child in a consolidated member.

Syntax

ELWEIGHT(server:dimension, element1, element2)

Argument

Description

 Required/Optional

server:dimension

The name of the TM1® server and a dimension name.

 Required

element1

The name of a consolidated member within the dimension. This argument can also be the name of an alias for a dimension member.

If member1 is not a consolidated member, the function returns 0.

 Required

element2

The name of a child of the consolidated member. This argument can also be the name of an alias for a dimension member.

If member1 is not a parent of member2, the function returns 0.

 Required

Example

The following examples use the SData TM1 server and a member called Gross Margin with two child members.

Display of the two child members of Gross Margin. The member Variable Costs has type set to Simple and Weight set to -1. The member Sales has type set to Simple and Weight set to 1. 
ELWEIGHT("SData:Account1","Gross Margin","Sales")

In this example, the function returns 1. The member Sales, which is a child of Gross Margin, has a weight of 1.

ELWEIGHT("SData:Account1","Gross Margin","Variable Costs")

In this example, the function returns -1. The member Variable Costs, which is a child of Gross Margin, has a weight of -1.