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