EPM Add-In for Excel

**** Correction 18.07.2014 – Default password for Offline protection is “PASSWORD” The document below is based on EPM SP16 Patch 1. The documentation is sometimes confusing and I want to show some step by step examples of... 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 »

Announcing general availability of Analysis Office 2.8 Analysis Office 2.8 has just been generally available since Nov 29, 2019. It is the latest and best release of Analysis Office, combining the power of the classic Analysis functionality and the... Read More »

Hi BPCeros!!!!! Do you want to download the BPC AddIn? Possibly you have already seen a similar blog in my account, I just wanted to update it since many have left me comments that the images from my previous blog are outdated. With this blog, I... Read More »

It is not out of the ordinary for a client to want a summation of last 12 months for many accounts.  One way of doing this, if the number of accounts is minimal, is to create several dimension formulas, but this could diminish performance.  A... 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 »

Let’s assume the following scenario: due to business requirements the hierarchy in BPC dimension was significantly changed (or even removed in case of multiple hierarchies). As a result, a lot of nodes are obsolete and has to be deleted. There... Read More »

SAP Analysis 2.8 ( GA by November 29th)  brings a structural code change in EPM Plug in. Indeed, EPM Plug in code has been replaced  by EPM add-in code. Main goal is to ensure smooth transition to the EPM version contained into SAP Analysis for... Read More »

EPM Add-in report with multiple Categories in SAP BPC, version for Microsoft and NetWeaver 10.0 With the new user interface in BPC 10, one might wonder how to create a report rendering two different Categories: Actual data for closed months and... Read More »

Introduction In this post I am going to brief you about silent installation/uninstallation  of AO and EPM components of Analysis Office 2.8 support pack 02. Analysis Office (AO) is available as a consolidated version from 2.8.The installer GUI... Read More »