EPM Add-In for Excel

Despite the heavy investment in SAP Analytics Cloud (SAC), SAP Business Planning and Consolidation (BPC) remains one of the main offerings from SAP as a complete planning and consolidation solution. Whilst SAP BPC Embedded seems to be the preferred... 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 »

SAP has just made it easier to get technical help by adding over 35 new product areas for Schedule an Expert. Use the service to book an appointment with an engineer and discuss incidents and technical issues – at time that fits your schedule –... 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 »

Updated on 2019.06.18: Code corrected to support properties like PARENTx, performance improved. Updated on 2019.06.14: Code corrected to support proper case for short ID. Updated on 2019.06.13: Late binding to work on EPM or AO. Decided to share... 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 »

It’s a common question in EPM and BPC NW tags: How to create a report with many-to-many relationship between members of 2 dimensions? For example there are 2 dimensions: ENTITY and ACCOUNT For each ENTITY base member there is a list of valid... Read More »

SAP used to offer several Add-ins into Microsoft Office, Analysis Office (AO) and EPM Add-in were the most prominent ones among them. As several customers have requested to run them in parallel in the same workbook, SAP has moved them to a common... 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 »