Removes values or members in one list from another list.
@REMOVE (list1, list2)
| list1 | A list of member specifications, from which the members specified in list2 are removed. |
| list2 | A list of member specifications to be removed from list1. |
In the Sample Basic database,
@REMOVE(@CHILDREN(East),@LIST("New York",Connecticut))
returns Massachusetts, Florida, New Hampshire.
The following example is based on the Sample Basic database. Assume that the Market dimension contains an additional member, Non-West.
A special analysis requires a sum of the actual sales values of a particular product family for non-western states. In this example, the @REMOVE function is used with the @SUMRANGE function to perform this analysis. The @LIST function is used to group the last two arguments of the @REMOVE function (the children of West plus two additional members, Texas and New Mexico).
FIX(Sales)
"Non-West"=@SUMRANGE(Sales,@REMOVE(@LEVMBRS(Market,0),
@LIST(@CHILDREN(West),Texas,"New Mexico")));
ENDFIX
This example produces the following report:
Jan Colas Actual
Sales
=====
Non-West 5114
New York 678
Massachusetts 494
Florida 410
Connecticut 310
New Hampshire 213
East 2105
California 941
Oregon 450
Washington 320
Utah 490
Nevada 138
West 2339
Texas 642
Oklahoma 180
Louisiana 166
New Mexico 219
South 1207
Illinois 579
Ohio 430
Wisconsin 490
Missouri 360
Iowa 161
Colorado 643
Central 2663
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |