If you follow best practices for SAP implementation and use, whether it be BPC, Disclosure Management, ECC,
HANA, ABAP, or many others, you will be successful in quantifying the benefits from the suite of products you choose.  Our perspective is that there are no inherently “bad” SAP products, just poor implementation that can make your product use more stressful than it needs to be.

Need to calculate a grand total dynamically?  Shifting of Local Members giving you a headache?  I previously used Indirect() functions, but I discovered with larger reports this put a drag on reporting performance.  To sum from the first report column to the last report column I was using something like this  =SUM(EPMPOSITION(1):INDIRECT(ADDRESS(ROW(),COLUMN()-1))), which is not considered best practice but I got results!

The SAP definition: “EPMALLMEMBERS is used to perform a calculation (such as sum or average) on all the members displayed in a row or column axis, whether the axis contains one or several dimensions”

HOW?  Here are some examples:

You may have noticed in the news recently that many large multinationals have been the subject of some rather intense media and public scrutiny regarding the amount of tax they pay in certain countries.  As media pressure and public anger has escalated, governments and regulators have been compelled to take action to improve the visibility of where companies make their profits and where they pay their taxes to help ensure that they pay a fair share to the coffers of the national governments.

It had become obvious to governments that the underlying issues could not be addressed by unilateral regulation and instead need a cohesive joined up approach to tackle tax base erosion and profit shifting through transfer pricing arrangements between multinational subsidiaries.  The OECD in conjunction with the G20 countries devised an action plan which includes the need for greater levels of disclosure from multinational enterprises (MNEs) in relation to the countries where their economic activities occur and amounts of tax they pay in each jurisdiction.   This has resulted in the creation of the Country by Country (CbC) reporting standards by the OECD that are being implemented through the local tax governing bodies of all OECD members.

The OECD CbC regime requires the following reporting on a country by country basis;

Aggregate country wide information relating to the global allocation of

* Income;

* Taxes paid;

* and; other indicators of economic activity (stated capital, accumulated earnings, tangible assets, no of employees)

BPC has always been a flexible tool with many “hooks” through Excel and the database layer enabling all manner of customizations to increase usability to customers’ exact specifications. The risk of customizing is the potential of that customization being an impediment to an upgrade. One popular access point provided by SAP/OutlookSoft was the “MNU_Commands” hook.

SAP has a portfolio of Consolidation solutions with their own unique positioning and the SAP Financial Consolidation (FC) software is an enterprise solution offered to companies looking to improve and speed up their financial close – without sacrificing quality control and compliance.

FC became part of the SAP EPM portfolio through the acquisition of BusinessObjects in 2007.  BusinessObjects itself acquired the French software vendor Cartesis who originally marketed Financial Consolidation as Cartesis Magnitude.  With a large and loyal customer base throughout Europe and Japan, FC has a particularly strong focus on statutory consolidation requirements within large multinational organisations that have complex and evolving corporate structures across multiple reporting standards (e.g. IFRS and local GAAP).

Column5 and I have seen a lot of things over the years in the EPM space. I have been working on the technical side of BPC MS since 2000, BPC NW since 2007, and BPC NW on HANA since 2012, having implemented it around the world over 1000 times.

I have a dream to, at some point, write a book of everything I have seen over the years. If investors knew what was really going on deep within some of the world’s datacenters, I think some heads would be rolling! I won’t mention ANY NAMEs but some of them are the who’s who of worldwide companies!

I keep running into the same thing over and over and over again, whether it is hosted by a 3rd party or implemented on-site at a client. The challenges start with a common element that is surprisingly easy to fix: No one seems to take care of the servers and technology!

This blog is part of a series on reporting techniques to help you get more value from SAP BPC.

DROP-DOWN LISTS help make a worksheet more efficient by provided a controlled list of options that make the report or input template respond to preconfigured options.

To create the list use Excel’s Data Validation tool. We are going to take this a step further by populating the list with EPM reports on a ‘List’ tab within the workbook.  In the snapshot below we are using drop-down list for Company, Cost Centre, Program, and Account. Each drop-down list will have its own report to populate the list.

COST CENTER LIST: A list of cost centers is created using fixed members that had been input. In this example, the dropdown has a friendly label that is the result of concatenating ID & Description, but the report will only use the dimension ID’s referenced on the list tab by using Excel’s VLOOKUP function to match the concatenated friendly label to the ID from the right row.

The formatting strategy chosen for a report or input schedule is one of the most important decisions made in development because it influences performance, complexity and the “fun factor” for development.  I say this with humor because the report may take 4 hours to build and 8 hours to format!  There isn’t room enough to go into all aspects of formatting in detail, however the understanding of choices we have is critical and can certainly influence the overall life cycle (maintenance and productivity).

The EPMFormatting sheet is used to format dynamic reports and input templates.  It is an Excel sheet that can be copied and changed for multiple worksheets and reports.  Dynamic formatting means the formats are applied to levels of a hierarchy, types of members or column and page axis dimensions.

Buying an Adequate Level of Service

Column5 offers many solutions and best practice concepts outlined in numerous blogs and webinars with the intent of supporting clients who wish to cultivate an internal capability to best elicit value from their EPM solutions. While all are recommended for our clients, we understand that for many organizations, being in a confident position to properly support their EPM investment is not easily met immediately after go live. We have found some clients looking for assistance with adhering to these best practices, or a little extra bandwidth to supply additional continued support post go-live. In response to these requests, Column5 has assembled a number of services designed to fill any gaps in your EPM deployment plan.

Since its early OutlookSoft days, BPC has always been touted as a tool that enables finance teams to become independent from IT so they can wield control of the system during crunch time.  Fast forward to SAP acquiring BPC, many SAP shops pride themselves on have the internal capabilities to own their systems, period.  It isn’t shocking that many of our clients have come ready to meet the challenge of proper care and usage with an internal team.  Column5 applauds this approach and has created numerous tools to help your team succeed: