Essbase @SHARE

Checks each member from rangeList to
see if it has a shared member and returns a list of the shared members it
has found.

Syntax

@SHARE (rangeList)
Parameter Description
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 actual 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