@SHARE

The @SHARE calculation function for Essbase checks each member from a list to see if it has a shared member, and returns a list of the shared members it has found.

Syntax

@SHARE (rangeList)

Parameters

rangeList

A comma-delimited list of members, functions that return members, and ranges of members. All the members in rangeList must be from the same dimension.

Notes

Other member-set functions return the prototype members, not the shared members. You can use @SHARE within the memberList, rangeList, expList or list parameters of other functions to provide shared members instead.

Example

The following examples are based on Sample Basic.

To remove all shared members from the Product dimension:

@REMOVE(@DESCENDANT(Product),@SHARE(@DESCENDENT((Product)))

To remove a specific member from the Product dimension, you can use @SHARE specifying the shared member to be removed:

@REMOVE(@DESCENDANT(Product),@SHARE("100-20"))  

See Also

@REMOVE