Local Member: condition-based logic IF(UPPER("Attribute1")=''OptionA'', attribute value in row

[vincentverheyen]

It is easy to create a Local Member in the IBP Add-In. We are trying to create a Local Member that should have a different calculation based on the value of another attribute.

If the row contains Attribute1: Value "OptionA", we would like to show the LocalMemberA in those rows, for those planning objects, with a certain FormulaA.

If another row contains the Attribute1: Value "OptionB", we would like to:

• either not show the LocalMemberA; but show a LocalMemberB in those rows, for those planning objects, with a certain FormulaB.
• or alternatively, still show the LocalMemberA; but now with a different FormulaB, in those rows, for those planning objects.

Is this possible? Can these Local Member work with IF statements and refer to the value of attributes, just like Key Figures can. For example for a Key Figure we can do:

IF(UPPER("Attribute1")=''OptionA'',"KeyFigure1@PlanningLevel1"*"KeyFigure2@PlanningLevel1", IF(UPPER("Attribute1")=''OptionB'',"KeyFigure1@PlanningLevel1"*"KeyFigure2@PlanningLevel1"*"KeyFigure3@PlanningLevel1", NULL))

If any LocalMember is shown, it should always come "after" (underneath) KeyFigure1.

Could someone give an example of such a formula for a Local Member? If possible.

Or can this functionality be covered by the "Attached to Member Combination"? I see that you can select the values of the attributes in the "Multi Dimension Member Selector". However, I do not seem to get it to work. An example would be much appreciated.

I have only been able to get Local Members to work so far, "before" or "after" any Key Figure so far, not "before" or "after" any Attribute with certain value.

[piyush_parekh]

Hi,

I think it would be easier to model this requirement using key figure configuration. You can model If condition based on attribute values by using two single quotes.

Regards,

Piyush

[vincentverheyen]

We are trying to use the power of local formulas in Local Members. So you agree that SAP IBP's Local Member "Before" or "After" Attribute (or Attribute's value) is not functional yet? Is it correct to say that this should be reported as a bug/incident? I only managed to get the Local Member "Before" or "After" Key Figure operational so far.

[rahulmohnot]

Vincent,

Before and after are relevant. I intended to say that it only depends on the member attached (Before that member or after that member) not on the Key figures used in the calculation, which can be before or after.

Hope my intend is clear now.

-Rahul

[vincentverheyen]

mohnotrahul For example in UNIPA, when I create a local member, and attach it to a member which is a Key Figure, it works nicely, yet seemingly only if the Key Figure field (lay-out settings) is in the row immediately next to the actual data points (Key Figueres). However, when I try to attach to a member which is an Attribute, the local members disappear all together. It isn't working from my side.

[rahulmohnot]

Hi Vincent,

The placement of the Local member just depends on the member, it is attached with as shown in snap.

The calculation may have Key figures placed before or after it. A sample formula is as shown below, you please simplify and use the KF id (XXn) based on your need. it represents calculation (XX1*XX2)+XX3+XX4. In case its error , i am placing "Blank".

=IFERROR((EPMMEMBER([KEY_FIGURES].[].[XX1])*EPMMEMBER([KEY_FIGURES].[].[XX2))+EPMMEMBER([KEY_FIGURES].[].[XX3])+EPMMEMBER([KEY_FIGURES].[].[XX4]), "")

Hope this helps.

Rahul Mohnot

[vincentverheyen]

Hi mohnotrahul. Thanks for your answer. So in your experience the "Before" or "After" Attribute (or a certain Attribute's value) also does not work, via the "Attached to" functionality? Only "Before" or "After" Key Figure works? If so, could you give an example of an IF- (or other) formula which only displays the local member in a row with an Attribute having a certain value?