Show TOC

Local Member Automatically DetectedLocate this document in the navigation structure

You can insert a row or a column, enter text as the header of the row or column, then enter a formula.

When you enter in a report a Microsoft Office Excel formula, provided that the Activate Local Member Recognition option is selected in the Sheet Options:
  • the formula is automatically converted into a local member using a specific keyword.
  • the local member is automatically attached to a specific item.

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

Note Once a formula has automatically been converted into a local member, you can edit the local member in the Local Members tab of the Report Editor: you can see for example the keyword used in its formula and the item to which the local member is attached.
Note
  • All Microsoft Office Excel formulas are converted into local members.
  • If you do not enter a text to describe the local member, a default name is generated, beginning with (fn).
  • If a member refered to in a local member is deleted, the local member becomes invalid.
  • The local member position depends on the Totals Placement options selected in the Sheet Options.
  • A local member cannot be attached to a blank member. For more information about blank members, see Blank Member.
Restriction References to more than 100 cells are ignored.
Local Member Attachment

Any formula is converted into a local member and the local member is automatically attached to one of these items: a specific member, a combination of members, the row axis, the column axis or a specific position in the report.

Alternatively, you can ask that any formula is converted into a local member that is attached to the row or column axis at a specific position, meaning the local member is automatically detected as an EPMPOSITION type of local member.
Note However, this does not apply to the EPMDIM_CURRENT_MEMBER type of local member.

To do so, select the Use Position in Axis option in the Sheet Options.

To see an example of local members attached to a specific position in the row or column axis, see Local Members - Examples.
Note When a local member references the current report and another cell outside of the report, the member is automatically detected as an EPMPOSITION type of local member, even though the Use Position in Axis option is not selected in the Sheet Options.