<LINK

Command

The LINK command uses the AND, OR, and NOT> Boolean operators, combined with extraction commands, to refine member selections.

Syntax

<LINK (extractionCommand [operator extractionCommand])

extractionCommand Any of the following extraction commands or another AND/OR expression:
<ALLINSAMEDIM (member)
<ALLSIBLINGS (member)
<ANCESTORS (member)
<CHILDREN (member)
<DESCENDANTS (member)
<DIMBOTTOM (member)
<DIMTOP (member)
<IANCESTORS (member)
<ICHILDREN (member)
<IDESCENDANT (member)
<IPARENT (member)
<MATCH (Dimension, match_string)
<MEMBER (member)
<OFSAMEGEN (member)
<ONSAMELEVELAS (member)
<PARENT (member)
<UDA (Dimension, UDA_name)

Operator Any of the following Boolean operators:

Use the AND operator when all conditions must be met.

Use the OR operator when either one condition or another must be met.

Use the NOT operator to choose the inverse of the selected condition.

Description

This command produces member selections using Boolean operators to refine the search. NOT can only be associated with an extraction command, and does not apply to the entire expression. You must use NOT in conjunction with either the AND or OR operators.

The MEMBER extraction command is only used within a LINK expression; you can use the MEMBER selection to select a single member. Do not use the MEMBER command outside of a LINK expression.

Example

<LINK (<UDA(product,Sweet) AND <LEV(product,0))

Selects all level 0 products that are sweet

<LINK ((<IDESCENDANTS("100") AND <UDA(product,Sweet)) OR <LEV(product, 0))

Selects sweet products from the "100" sub-tree plus all level 0 products

<LINK ((<IDESCENDANTS("100") AND NOT <UDA(product, Sweet)) OR <LEV(product, 0))

Selects non sweet products from the "100" sub-tree plus all level 0 products

Notes

You must select members from the same dimension, and all extraction command arguments must be enclosed in parentheses, as in the example above.
Hyperion Essbase evaluates operators from left to right. Use parentheses to group the expressions. For example: A OR B AND C is the same as ((A OR B) AND C). In the first expression Hyperion Essbase evaluates the expression from left to right, evaluating A OR B before evaluating AND C. In the second expression, Hyperion Essbase evaluates the sub-expression in parentheses (A OR B) before the whole expression, producing the same result. However, if you use (A OR (B AND C)), Hyperion Essbase evaluates the sub-expression in parentheses (B AND C) before the whole expression, producing a different result.
You can include up to 100 arguments in a LINK statement. For example, <LINK (A OR B OR (C AND D)) counts as four separate arguments.
All extraction commands within a LINK statement need to select from the same dimensions; a command such as LINK (<ICHILDREN (east) AND <LEV (product,0)) causes a syntax error.
If the LINK command returns an empty set of members, the dimension member is returned.