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 »

SAP HANA Home Server PC Build (Energy Efficient)

Energy Efficient SAP HANA Server Build for Home

In my last post, I wrote about my intentions to build another PC Build which I planned to use for SAP HANA and SAP BPC experiments. The server has been running already for few months, but because of the busy working and private schedule, I was not able to share any updates. After having my previous server for a little over a year, I understood that running a PC 24/7 has an enormous impact on the electricity bill. Therefore my aim was to build power efficient training server which I can run non-stop with marginal impact …

Read More »

New SAP HANA Training Server Build

New SAP HANA Training Server Build

It has been a little more than two months since I wrote my previous post about developing VBA Skills. A lot of things happened in the meantime, but overall I was and still I am in busy projects. I don’t complain as it is exciting in 95% of the time and I can refine my BPC skills with every passing day. Nevertheless, in this quick post, I will explain why I am in a process of building new SAP HANA Home Training Server for BPC/BW. My old server is in Bulgaria and is reachable from any place in …

Read More »

Learn VBA for MS Excel – Video Course Review

Learn VBA for Excel

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 »