Home >> SAP BPC >> SAP BPC 10.1 Planning Prototype with Logic Script

SAP BPC 10.1 Planning Prototype with Logic Script

SAP BPC 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 🙂

About Emiliyan Tanev

Hello, My name is Emiliyan Tanev. I am SAP BPC Certified Application Associate with a good process understanding of FICO. I am also an experienced accountant and financial controller with 5+ years of diversified responsibilities. I am also a member of Management Accounting Body in the UK - CIMA and CGMA in the US. I love IT and Finance which impacted my career orientation towards SAP FICO and BPC. Follow me and get the latest tips, tricks, tutorials and career guides related to SAP BPC. More about me on My Story.

Check Also

Activate BPC in NetWeaver BW

Activate SAP BPC in NetWeaver BW 7.5 Guide

There are a lot of things going on with BPC and EPM as General. SAP …

2 comments

  1. Hi Sir,

    The script which was working in 10.0, is not working in 10.1.

    Could you plz let me the reason for it aswel if any changes required to be done.

    Regards
    Jeevan

Leave a Reply

Your email address will not be published. Required fields are marked *