@REMOVE

Syntax

@REMOVE (list1, list2)

Parameters

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.

Example

Example 1

In the Sample Basic database,

@REMOVE(@CHILDREN(East),@LIST("New York",Connecticut))

returns Massachusetts, Florida, New Hampshire.

Example 2

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, @REMOVE is called within @SUMRANGE to perform this analysis. @LIST groups the last two arguments passed to @REMOVE (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