Man-Computer-Laptop-Coffee-Cafe-Concept-000079551979_Large-1.jpg

SAP BPC & EPM
Thought Leadership

SAP BPC: Top 5 Most Viewed Blog Posts of 2016 (So Far)

Posted by Gracie Arnold on Mon, May 02, 2016 @ 13:05 PM

For those who missed our 2016 blog posts! Here at Column5, we believe that user education is paramount. Because of this we provide our viewers and clients many free educational resources. If you love a post or want us to post something specific, throw us a comment below! 

Topics: best

Tax Reporting Just Got a Whole Lot Tougher! (Thanks to the OECD)

Posted by Ciaron Kulczycki on Fri, Mar 11, 2016 @ 08:03 AM

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)

Topics: Center of Excellence, Process Improvement, Thought Leadership, best

HOW TO: Suppress Send Dialog Box in SAP BPC

Posted by Deb Silverman on Fri, Mar 04, 2016 @ 09:03 AM


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.

Topics: Thought Leadership, BPC (Business Planning & Consolidation), best

SAP BPC Reporting Tips & Tricks

Posted by Deb Silverman on Tue, Jan 12, 2016 @ 08:01 AM

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 CENTRE 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.

Topics: Best Practices, Excel, Enterprise Performance Management (EPM), best

Formatting in SAP BPC

Posted by Deb Silverman on Wed, Jan 06, 2016 @ 10:01 AM

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.

Topics: Best Practices, Excel, Data, best

Building a Competent BPC Team

Posted by Jonathon Pause on Tue, Dec 08, 2015 @ 10:12 AM

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:

Topics: Center of Excellence, Project Management, Training, Innovation, best

Subscribe