@INTERSECT

The @INTERSECT calculation function for Essbase returns the intersection of two member lists. 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.