SAP BPC 10.1 Planning Prototype with Logic Script

A little less than a year ago I dived into SAP BPC world. It is a great career path for me and I don’t regret switching my focus from SAP FICO to SAP BPC. I still believe BPC fits better to my profile and skills set.

I was lucky enough to take official SAP courses – BPC420, BPC430 and BPC440  and be able to certify after that. The courses are very valuable and give you the opportunity to form a stable foundation, but they do not cover Logic Script very well. That is the reason I decided to start playing with it while creating a relatively simple planning solution with several Models.

The planning solution includes Sales, Inventory, BOM, Processing (Operation), HR, Capex and Opex models which are tightly integrated with the built-in functions of Logic Script – *DESTINATION_APP and *LOOKUP. There are few examples of *RUNALLOCATION and many *END/*IS/*REC/*ENDWHEN statements in combination with scoping the data using primarily *XDIM_MEMBERSET.

You will also see using of running data manager package from a file within macro where the file itself is also created in the macro. The selection in the file is based on input forms’ page axis in the related input forms. Check the quick demonstration of it on the following link:

I had plans to extend the Planning Prototype with Purchasing and Liquidity models and use already created Assumptions model extensively, but I decided to skip that part. My initial goal was to improve and make myself comfortable with the Logic Scriptwriting and I think I’ve achieved my target. There are certain things that could be fine tuned and I will be very thankful if someone points them out in the comments below.

If you want to download and have a look at the logic script code, you will find it here. I am also providing the backup of the environment using UJBR. The backup is from BPC 10.1 SP05 version. I am not sure whether you can use it on different version or support package. Keep in mind that the environment does not have assigned users to it. If you restore it, you will also have to change the status from Offline to Online.

If you have any questions, please use the comments section below 🙂