EPMMemberOffset
This function retrieves a member related to another
member by specifying an offset from a given member to retrieve the previous or
subsequent member. The cell containing the EPMMemberOffset function increments
members based on the member selected. By default, if the optional Level
parameter is not included, the member at the same level as the member specified
is incremented.
Note When you choose a specific level using the
Level parameter, note that only the members that are above the member (the one
specified in the member parameter) or at the same level in the hierarchy, are
displayed. If you specify a level that is below the member, the level is
ignored.
You can use a negative offset.
| Parameter | Description |
|---|---|
| connection name | Name of the connection. For details about the syntax you must use, see Connection Name Parameter - Syntax. |
| member | Member to start from. Mandatory. |
| offset | Specify the number of member increments. Mandatory. |
| level | Specify the hierarchy level. Optional. |
Note
- If the description of a member exists in several dimensions, once you have entered the function, a message appears, stating that the description is ambiguous and recommending that you use the ID of the member instead.
- If the ID of a member exists in several dimensions, once you have entered the function, a message appears, stating that the ID is ambiguous and recommending that you use the full unique name of the member instead.
Note When connected to a large-volume BAPI provider BW NW connection, you can use the
EPMMemberOffset provided that, when creating the connection, you have selected
hierarchies for which members are loaded at connection time. See Large Volume Data Sources.
Example
EPMMemberOffset("Finance",D4,"1")
If cell D4 contains 2009.Q1, and no level is specified, an increment of 1 returns the member 2009.Q2, and an increment of 2 returns 2009.Q3, and so on.
If cell D4 contains 2009.TOTAL, and no level is specified, an increment of 1 returns 2010.TOTAL.