EPM Add-In for Excel

In BPC NW 7.5 finance users were able to create static report having some very basic knowledge about EVDRE. The only thing to remember was: “remove reference for expand range from EVDRE formula”. Then we have a static report where user... Read More »

In this blog post, you will learn what are the recommended approaches and relevant use cases of creating planning objects in SAP IBP. Planning objects are a combination of attribute records. It is same as that of characteristic combination in SAP... Read More »

So you are trying to explore your models in HANA Express from Lumira or Analysis for Office but getting error  “InformationAccess Service GetResponse is not available. Install SAP HANA EPMMDS plugin.” And you wonder why if before SPS01... Read More »

In some cases it’s required to find the password used to protect sheets in EPM workbook. Not to remove, but to find the password string. This can be done with a simple VBA code. Create a new workbook, open VBA editor and insert a new module... Read More »

Unable to open EPM add-in from BPC web client is a very common problem in BPC 10.X, here we discuss the common errors and how to deal with them.   First, you need to know the client software supported by BPC 10.X   SAP NW... Read More »

As reminder, the well-known Add-in, SAP Analysis for Office is available with two different editions/ installers of SAP Analysis for Office, based on the licensing model applied, systems in use and customer’s scenario. The features-set of the two... Read More »

Updated on 2019.06.18: Complete code redesign for better performance. Updated on 2019.06.14: Code corrected to support proper case for ID column. Updated on 2019.06.13: Fast code to get property value and late binding to work on EPM or AO. EPM... Read More »

SAP Business Planning and Consolidation (BPC) came into existence with SAP acquiring Outlooksoft in 2007.  From then BPC has come a long way over these years. The first product of SAP BPC was SAP BPC, version for the Microsoft platform. After that... Read More »

New! After EPM SP 29 Patch 01 the new subroutine “DataManagerAdvancedRunPackage” was introduced to run DM packages with answer file. At the end of this blog I will provide simplified code using  this sub. Updated: Universal code with... Read More »

PROMPT(COMBOBOX… is a useful statement in DM advanced script to provide user selection of some text values that can be later used in script logic. With the help of this statement it’s possible to limit user choice to only values... Read More »