Skip to Content
0
Jan 17, 2023 at 12:06 PM

EPMTUPLE - IBP local member disappears from planning view?

331 Views Last edit Jan 18, 2023 at 09:59 AM 9 rev

I can successfully insert a local member into an IBP planning view, for example using the formula:

=EPMMEMBER([KEY_FIGURES].[].[KEYFIGURE1])*0.5

However, if I go into the report editor, and change the local member's formula into:

=EPMTUPLE([LOCID].[.].[__TOTAL];[SCNID].[].[__BASELINE];[KEY_FIGURES].[].[KEYFIGURE1])

Then the local member disappears from the planning view. Why is this please?

  • The attribute LOCID is present in the planning view.
  • The scenario BASELINE is present in the planning view.
  • The key figure KEYFIGURE1 is present in the planning view.

Anyone who has more experience with regards to EPMTUPLE and who can share some practical info on what it can and can't do?

Please note I have a planning view with a Layout of Row Axis: "Key Figure", Column Axis: "Scenario". This means that (in the planning view) the scenarios are and should be put next to each-other per column.

The goal/context here is that the local member, which should be inserted in an extra row below the key figure KEYFIGURE1, should substract the baseline's key figure value from the same key figure value of the particular column (of a particular scenario).