Home >> SAP BPC

SAP BPC

Top-Down Planning in SAP BPC

Top-Down Planning in SAP BPC

SAP BPC is handling by default the so-called Bottum-Up planning by using the hierarchy capabilities of the Dimensions. It is normal planning scenario where departments plan on the lowest level and later it is aggregated to a company and group. It is nothing special and nobody will be surprised by that. However, sometimes you might be asked how to do a Top-Down Planning in SAP BPC. Top-Down Planning is characterised by setting a target budget of a Company or Sub-Group level which is later allocated to the business units underneath. By default, SAP BPC can hold data only …

Read More »

SAP BPC Common Mistakes in Logic Script

SAP BPC Common Mistakes in Logic Script

Logic Script is a powerful proprietary language used in SAP BPC for logic execution. While it is widely used in almost every BPC implementation, especially for the Planning Models, there aren’t many resources teaching you on best practices or how to write it correctly. The official SAP BPC420 BPC Administration course is covering only marginally how the Logic Script code should be written. Therefore the majority of the consultants are learning by doing without tutor guidance. The so-called “Trial and error” method. Unfortunately, there are cases where because of poorly written Logic Script, consultants are rewriting …

Read More »

Learn VBA for MS Excel – Video Course Review

From a little less than a year, I had plans to learn VBA basics for Excel. As an SAP BPC Consultant I am not expected to be a master of it, but there is no doubt it is a useful programming language in a variety of cases. As a rule of a thumb, SAP BPC Consultants should avoid extensive usage of VBA, especially for sophisticated calculations. However there are circumstances where you will need to automate tasks such as changing chart source data, chart title, copying excel formulas to dynamic input forms, etc. Initially, I was …

Read More »

SAP BPC Embedded Consolidation is Finally Here

SAP BPC Embedded Consolidation is Here

SAP just released BPC SP09 for NetWeaver BW 7.4 and NetWeaver BW7.5 SP02. Both are enabling the highly anticipated feature for SAP BPC Embedded – Consolidation.  It is a huge step forward, and it will certainly help to increase the adoption rate. Don’t forget that SAP Embedded is the core of SAP Integrated Business Planning also known as SAP IBP for S4/HANA. It is intended to integrate planning needs of  Finance, Sales, Manufacturing, Procurement, etc. As I wrote already few times in my blog, BPC Embedded is a crucial product for SAP and a heart of …

Read More »

Activate SAP BPC in NetWeaver BW 7.5 Guide

Activate BPC in NetWeaver BW

There are a lot of things going on with BPC and EPM as General. SAP already showed their commitment to extend and make BPC a core product of their portfolio. You can check my posts on EPM Roadmaps and Consolidation Feature in BPC Embedded, but certainly a lot of things are going on with it. Their latest version of BPC is 10.1, and you can install it on NetWeaver BW 7.4. Nevertheless, this post is not about it. This article is about activating BPC in NetWeaver BW 7.5. You heard me right, you will not need to …

Read More »