How to add Local Member in IBP Planning Template
Step 1: Log on to SAP IBP Excel Add-in
Step 2: Open the existing template or open new template.
Step 3: Create the local member for as following scenario
= Actuals Qty – Actuals Qty Prior Yr
Navigate to Planning Template “Advanced” -> Click on “EPM Editor Report”
Select the “Local members”
Local member Properties
Select Enable Option
Name: Enter Local Member Name
Description: Enter the description
Formula:
=INDIRECT(ADDRESS(ROW()-2,COLUMN()))INDIRECT(ADDRESS(ROW()-1,COLUMN()))
Select radio button Insert After
Attached to
Select Member
After added member, click on Add button in Actions.
Click on “OK” button. Created local member added to planning template.
Save as new template or update the existing template.
Note: Formula is based on the business requirement. This process to enable Local Member only.
Best Regards,
Lingaiah
Hi Lingaiah,
Thanks for sharing this interesting approach to do calculations between Key Figures having Planning Levels with periods transformed. (PERPRODCUST vs PRIORPERPRODCUST). I would like to know if there is any creative way, to do this without using EPM Local Member feature. My scenario is as follows :-
Also, using the EPM local member feature, i cant find a way to calculate values for IBP configured KF based on Local Member value. Is there any standard/creative way to achieve this ? Kindly suggest.
Many Thanks & Regards,
Shivpriye