@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
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