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

SAP BPC & EPM
Thought Leadership

SAP BPC 10.1 NetWeaver at the Saudi Arabian Monetary Authority - 10 Keys to EPM Project Success

Posted by Richard Hynes on Tue, Jan 31, 2017 @ 11:01 AM

From November 2015 to November 2016, with 9 months on site, Column5 worked at the Saudi Arabian Monetary Authority (SAMA), which acts as the central bank for the KSA, to implement a Budgeting, Planning and Forecasting system using SAP BPC 10.1 NW on BW 7.4. This is the story of that implementation and the key factors behind the success of the project.

Topics: Enterprise Performance Management (EPM), Training, Case Study, Executive, Upgrade

What Exactly is “Customized eLearning” and Why Do BPC Users Want It?

Posted by Adam Hess on Thu, Sep 29, 2016 @ 13:09 PM

In terms of EPM training, there is a broad range of offerings that a company can utilize.  Whether it be on-site, workshops, or customized training portals, EPM Academy has administered thousands of sessions in pretty much any format you can imagine.  At this point, with over 10 years of EPM training experience, it seems we’ve seen it all. But by far, the most effective format of BPC education is customized eLearning. EPM Academy’s customized BPC eLearning training is in a league of its own, and will greatly benefit any type of organization, regardless of size or number of BPC users.

Topics: Training, best practices for epm

Momentous Events in London this June - Even for SAP EPM users 

Posted by David Jones on Mon, Jun 20, 2016 @ 08:06 AM

June is a month of momentous events in London. While those events unfold, SAP BPC, FC and EPM users will also gather in London on 30th June and 1st July to share in their own very special event. 

June 2016 in London will see a momentous celebration, commemoration and decision. The people of Britain will be celebrating the 90th Birthday of Queen Elizabeth II, Britain’s longest serving monarch and a rock of stability through the last 7 decades as the British Head of State. They will be commemorating the 100th Anniversary of the Battle of the Somme, a horrific episode in World War I which saw tens of thousands of European citizens killed and wounded for no obvious or significant reward. And finally, the people of Britain will be making a dramatic and historic decision in their referendum on membership of the European Community. These events all have their own special significance for European history and Europe’s future and we will all be watching them unfold with great interest.

Topics: Enterprise Performance Management (EPM), Training

Calculating Column Totals Dynamically - SAP BPC

Posted by Deb Silverman on Wed, Mar 16, 2016 @ 12:03 PM

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:

Topics: Best Practices, Excel, Training, Performance

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

The Top 5 Things to Consider When Selecting a Consulting Partner

Posted by Staci Matt on Tue, Oct 27, 2015 @ 08:10 AM

As with most specialized software programs, it is usually not suggested to implement SAP BPC without the assistance of a consulting partner.  Many projects require expertise that most EPM administrators do not have, and so it is recommended to find a partner that can ensure success.  Choosing this partner is an important decision.  Here are a few of the top things a company should look at when deciding on an appropriate organization. 

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), Project Management, Training, Implementation, BPC (Business Planning & Consolidation)

24 Hours Until the SAP EPM Value Liberation Army Meets in London: Time for our Very Own Waterloo!

Posted by David Jones on Tue, Jun 16, 2015 @ 23:06 PM

In just over 24 hours from now, over 60 delegates from 5 European countries and 40 corporate organisations, collectively responsible for over 9,000 end users of SAP BPC and BFC, will gather in London for our EMEA SAP EPM Leadership Summit. All these delegates have a common cause, to make sure their organisations deliver ever better value from their investments in SAP EPM; this is the largest gathering of the SAP EPM value liberation army in Europe this year, and it promises to deliver some famous victories!

Topics: Best Practices, Enterprise Performance Management (EPM), Training, BPC (Business Planning & Consolidation)

Want to be a European “Black Belt” in SAP BPC?

Posted by Martin Lloyd on Thu, May 21, 2015 @ 13:05 PM

Access to Advanced Training

Before being allowed to drive a vehicle unaccompanied, we are required to undergo training on both the theory (stopping distances, speed restrictions, road signs, etc.) and practice (actually handling a car) of driving, as well as passing a number of tests.

Topics: Best Practices, Process Improvement, Training, BPC (Business Planning & Consolidation)

Column5 Through the Years

Posted by David Den Boer on Wed, Apr 15, 2015 @ 09:04 AM

This month marks Column5’s 10th anniversary, and we are excited to be celebrating so many years of providing top-notch consulting services to our customers.  In the end, there are two groups who enable Column5 to have such a rich history of success.

Topics: OutlookSoft, Enterprise Performance Management (EPM), Training, BPC (Business Planning & Consolidation)

What's in a Good, Better, BEST Practice?

Posted by David Den Boer on Tue, Feb 03, 2015 @ 12:02 PM

Winston Churchill’s friend once said of him, “Winston is a man of simple tastes, he is always prepared to put up with the best of everything.” The desire for the best is something everyone covets, but this aspiration becomes problematic when “best” cannot readily be defined. So how would you know if you received the best?

Topics: Best Practices, Enterprise Performance Management (EPM), Training, Performance

Subscribe