@INTERSECT

The @INTERSECT calculation function for Essbase returns the intersection of two member lists.

This function returns the intersection of members that appear in two specified lists of members. The intersection is the set of all distinct members that are part of both lists.

Syntax

@INTERSECT(list1, list2)

Parameters

list1: The first list of members.
list2: The second list of members.

Notes

This function treats shared members as distinct from their prototype members; therefore, they do not intersect.

Example

The following examples use the Sample.Basic database.

@INTERSECT(@CHILDREN("100"), @ATTRIBUTE(Can)) returns 100-10 and 100-20.

@INTERSECT(@CHILDREN("Colas"), @CHILDREN("Diet Drinks"); returns an empty set, because shared members are considered distinct from their prototype members.

FIX (@INTERSECT(@CHILDREN("100-10"), @CHILDREN("Diet Drinks")))

   Sales = 500;

ENDFIX;

The @INTERSECT expression evaluates to an empty set; therefore, the FIX statement sets all the values of Sales to 500.