How to add Local Member in IBP Planning Template

[lingaiahvanam]

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