EPMLocalMemeber in Version

[OliverA41]

Hello,

I want use a EPMLocalMember also in a version. Unfortunatley if I want in the Attached field the version, the existing member will be overwritten.

My first understandig was, that I can use the LocalMemeber in every version.

[former_member592774 · Accepted solution]

Hi Oliver,

If I understood your question correctly , you want to use the local member in a different version than base version. Is that right ?

Local members are attached to the current sheet in which you are working so I think you can use the cell references to add/subtract KFs.

Or I didn't get your question.

Regards,

Anurag

[OliverA41]

further Information

as formular I insert follow calculation:

=EPMMEMBER([KEY_FIGURES].[].[CONSENSUSDEMAND])-EPMMEMBER([KEY_FIGURES].[].[TOTALCONSTRAINEDDEMAND])

Perhaps it is necessary to insert the version in the calculation? if yes, how I can insert the version