Column5 - Leading Edge of Enterprise Performance Management Blog  

Thought Leadership on SAP BPC and EPM Implementations

Using SAP BPC Restore and Export Journal Data Manager Packages - Part 2

Posted by David Kolka on Tue, Jun 30, 2015 @ 07:06 AM

This is part two of a blog on utilizing the BPC Restore Journal and Export Journal Data Manager Packages.  In the first installment we covered how to setup BPC to use the packages and a few of the reasons why a business team might utilize mass journal updates.  In the second installment, we will walk through a working example of how a team might use the packages to seed budget journals from actuals.  See part 1 for a refresher on how to setup BPC for importing and exporting journals.

So let’s take a look at how the BPC Import and Export Data Manager Packages can help seed the budget using actual’s journals.

All steps were performed on SAP BPC 10 NW on HANA using EPM Client SP 15 for Excel.

Seeding Budget Journals

In this scenario, the business has a need to pre-populate (seed) next year’s budget using last year’s actuals.  While this is a common process, what’s not as common is the need to capture detailed journal entries.  In many instances journals, are summarized and entered as a single entry for planning purposes.  But in some situations, especially consolidated financial budgets, it may be necessary to include all journal entries.  If you’re not familiar with BPC Journals, it’s recommended that the following steps be done in a test environment.

Read More

Analytics, EPM, and Managed Service

Posted by Jonathon Pause on Tue, Jun 23, 2015 @ 10:06 AM

Analytics?  Analytics.  Analytics!  Let us simply get it out there – analytics are the newest, hottest technology that everyone is talking about.  “The CFO’s Technology Imperatives for 2015” by Financial Executives International (FEI) and Gartner states, “many IT organizations have made initial investments, but these tend to be tactically focused and do not address the more fundamental issues of data quality and consistency.”  The market is in such a fervor over the promise of analytics that we often lose sight of our greater IT goals, and we do not effectively outline a strategy that can move us toward the new promised land.  

Surveys from Gartner reaffirm these assertions in a study on Top Big Data Challenges.  The top three challenges include how to derive value, how to define strategy, and how to obtain the skills and capabilities needed related to a big data initiative.

Read More

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!

Read More

Journal Import and Export Setup Steps - Part 1

Posted by David Kolka on Tue, Jun 16, 2015 @ 08:06 AM

Has your team ever had the need to consolidate history, including journals, when moving to a new consolidation solution?  How about detailed consolidated budgets that use journals?  Or detailed reporting on journal activity?   What about the need to move journals between development, quality, and production environments?  All of this can be accomplished using BPC’s Restore Journals and Export Journals package that comes standard with BPC. Today’s discussion will outline some of the key concepts with using BPC Restore Journal and Export Journal Data Manager Packages.   In the second installment, the discussion will continue with a couple of use cases explaining the different ways to use the functionality.  As a primer, it’s important to review the standard BPC EPM documentation on how to use Journals and Data Manager Packages.

Read More

Mind the Gap!

Posted by David Den Boer on Tue, Jun 09, 2015 @ 08:06 AM

The traditional IT vs. Finance gap and why it is essential to overcome that for EPM success.

Everyone loves a rivalry, at least when it comes to sports teams. It seems that the bitterer and longer running the rivalry, the better. When it comes to corporate politics, there can be few rivalries as legendary or potent as that between IT and Finance.

No one knows when it all started, but make no mistake, this can be trench warfare that started long before computers were even used in business. I can imagine the conflict raging so long, that there may have been a dialog like this in ancient times, “I simply can’t let you operate the wheel on your own, you don’t have the technical skills. Why don’t you tell me what you need the wheel to do, and I will operate it for you…just so there aren’t any mistakes?” “What? It’s just a stupid wheel; surely I am qualified to figure this out. Let me try it and we’ll see how it goes.”

Read More

The Inconvenient Truths About Organizational Change Management

Posted by Connie Folk on Wed, Jun 03, 2015 @ 10:06 AM

Why OCM is Critical to the Success of Your EPM Transformation.

According to analysts and customer feedback, EPM projects, as a subset of Analytics projects, are among the most challenging to achieve positive business value results. The reasons are many, including not having appropriate expectations laid out in a business plan, ill-advised technical designs, poor technical execution, not having internal skills to properly manage the solution, and not including a beneficial process change while implementing the technology.

Read More

EPM and the Wisdom of Sun Tzu

Posted by David Den Boer on Tue, May 26, 2015 @ 14:05 PM

Inspired by my colleague from Column5 EMEA’s use of a military reference, I’d like to discuss some of the parallels of 2500 year old military tactics to EPM strategic objectives.

Read More

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.

Read More

Would Napoleon have Won Waterloo if he had Used SAP BPC?

Posted by David Jones on Mon, May 18, 2015 @ 09:05 AM

The SAP EPM value liberation army is on the march!

18th June 1815 was a historic day in the history of Europe. It’s the day that two great armies lined up to determine Europe’s future. Who would win? Napoleon and his magnificent “Armée du Nord”, or the armies of the Seventh Coalition and the Prussians, under the Duke of Wellington and von Blücher?

Read More

5 Things You Can Do to Get the Best Performance from Your BPC MS 10/10.1 Server Environment, Part 2

Posted by Charles Dagaev on Tue, May 12, 2015 @ 08:05 AM

If you have not read part one of this blog, read it here!

Read More

Subscribe to Email Updates