Local Members

You can create members mainly for calculations on the current report. These members are called "local members". Local members have the same behavior as any other member, but they contain standard Microsoft Office Excel formula or EPM functions.

There are two ways of creating local members:

Enter a Microsoft Office Excel formula. When the Local Member Recognition is activated, all Microsoft Office Excel formulas are automatically converted into "local members". You can then view and modify the local member in the Local Members tab of the Report Editor.
Create a local member directly in the Local Members tab of the Report Editor.

Note You can also create a grouping local member in the Member Selector, when grouping members by property.

Note Once a local member has been created in a report, you should not overwrite the cells that are calculated by the local member. The content you have entered in the cells may be overriden by the local member.

Note Local members are specific to the current report. If you want to reuse a local member in other reports for the same sheet/connection couple, you can convert the local member into a custom member. To convert a local member into a custom member, right-click on the local member in the report and select Start of the navigation path

EPM

Convert to Custom Member End of the navigation path

. Note that a local member that is attached to a row or column axis, cannot be converted into a custom member. You can create custom members only when using a local or SAP BusinessObjects Enterprise connection.

Note Precedence rules: in case of conflicts between local members on row and column axis, local members on the columns axis override the ones on the row axis by default. You can change the precedence by selecting the Apply to rows as a priority in the Local Members tab of the Report Editor.

Note You can apply specific formatting to local members.

Keywords and Attachement

A local member is identified by a formula using one of the keywords below:

EPMMEMBER, to attach the local member to a specific member.
EPMTUPLE, to attach the local member to a combination of members belonging to nested dimensions.
EPMSELECTEDMEMBERS, to perform a calculation (such as sum or average) on all the members displayed in the report for a specific dimension. The axis in which the dimension is placed must contain only one dimension.
EPMALLMEMBERS, to perform a calculation (such as sum or average) on all the members displayed in a row or column axis, whether the axis contains one or several dimensions.
EPMDIM_CURRENT_MEMBER, to attach the local member to the current axis.
EPMPOSITION(n), to reference a row or column of the report, not a member.

A local member is attached to one of the following items:

Member combination. The axis to which the formula applies contains more than one dimension, and you have entered a formula that references two different members in the outer dimension.
Row or column axis. A formula that gives information about the members in the opposite axis.
A member. The local member is displayed after the member to which it is attached.
A position. The local member is attached to a position in the report, not to a specific member.
Another local member. The local member is displayed after the local member to which it is attached.

For examples and explanations on how keywords and attachments are managed, see Local Members - Examples.

Use of Volatile Functions

As mentioned in the Microsoft Excel documentation, the use of too many volatile functions can lower the recalculation performances.

As a reminder, the following Microsoft Excel functions are volatile: NOW, TODAY, RAND, OFFSET, INDIRECT, INFO (depending on its arguments), CELL (depending on its arguments).