A data load option that clears values only from the accounts specified in the data load file and replaces them with values in the data load file.
Essbase @MERGE
Merges two member lists that are processed by another function. Duplicates
(values found in both lists) are included only once in the merged list.
Syntax
@MERGE (list1, list2)
Parameter | Description |
---|---|
list1 | The first list of member specifications to be merged. |
list2 | The second list of member specifications to be merged. |
Notes
- Duplicate values are included only once in the merged list.
- @MERGE can merge only two lists at a time. You can nest @MERGE
functions to merge more than two lists.
Example
In the Sample Basic database,
@MERGE(@CHILDREN(Colas),@CHILDREN("Diet Drinks"));
returns Cola, Diet Cola, Caffeine Free Cola, Diet Root Beer, and Diet
Cream Soda.
Diet Cola appears only once in the merged list, even though it is a
child of both Colas and Diet Drinks.
In this example, the @MERGE function is used with the @ISMBR function
to increase the marketing budget for major markets and for western markets.
Budget (IF (@ISMBR(@MERGE(@UDA(Market,"Major Market"), @DESCENDANTS(West)))) Marketing = Marketing * 1.1; ENDIF;);
This example produces the following report, which shows only the major
markets in the East and all western markets:
Product Year Budget Marketing ========= New York 6039 Massachusetts 1276 Florida 2530 California 7260 Oregon 2090 Washington 2772 Utah 1837 Nevada 4521
The values prior to running the calculation script were:
New York 5490 Massachusetts 1160 Florida 2300 California 6600 Oregon 1900 Washington 2520 Utah 1670 Nevada 4110
See Also
- @LIST
- @RANGE
- @REMOVE