SAP BI-IP Implementation steps

With the release of SAP BI 7.0; SAP is recommending it’s user to use Intergrated Planning for their company wide Budgeting and Planning Application.

Integrated Planning – is a J2EE-web based Planning tool used to create Enterprise Planning Application.  The concept of planning remains the same for BPS and IP but IP gives a lot of flexibility to the developer to intergrate individual planning to create a consolidated web-based planning application.

Steps to create Planning Application  using BI-IP

1.  Create Real-Time InfoCube/MultiProvider that will be used to store plan data.  Developer can use a single InfoCube to store Plan & Actual data using an InfoObject “Value Type for Reporting” which will help user differentiate Plan and Actual data.  The 2nd choice could be use a MultiProvider that is created based on Two InfoCube: Plan & Actual.
Note: if you use a single InfoCube cube, make sure to change the Real-Time Load Behaviour when using it for Plan or Loading data.

2.  Goto Planning Modeler and select the above created Real-Time InfoProvider for creating Plannning Application based on this InfoProvider.

3.  Create Aggregation Level:   You can think of Aggregation Level as an User Level Planning: for example CFO, Regional Manager, Supervisor, etc.  individual Aggregation Level will have to be created respective user depending on respective user requirement.

4.  Create Filter:  This is the same concept as of Filters used in BEx Query Designer.  It will limit the scope of planning to the specific range of dataset.

5.  Planning Function:   SAP gives pre-defined planning functions that can be executed automatically using Front-End of planning Application

6.  Planning Sequence:   Here you can add the above created Planning Function to be executed sequentially in proper order.  Also,  developer can create an Input Enabled Query to enter the plan data manually in order to test his planning Application.