<img src="https://certify.alexametrics.com/atrk.gif?account=3HHNq1DlQy20Y8" style="display:none" height="1" width="1" alt="">
iStock-955408614

SAP Analytics
Thought Leadership

Michael Sheard

Michael Sheard

Recent Posts

The Integrity of Data Entered into SAP BPC via Input Schedules

Posted by Michael Sheard on Tue, Oct 20, 2015 @ 08:10 AM

SAP BPC systems receive data from a range of external sources.  The planning and configuration necessary to insert this data into the system is an important aspect of an implementation.  The integrity of data is vital, and invalid data can affect processes within SAP BPC, such as calculations and reporting.  Safeguards should be in place to prevent the entry of invalid data.

The main methods employed to enter external data into a SAP BPC system are:

  • Interfaces to source systems such as an ERP or SAP BW system.
  • Flat file uploads.
  • Input schedules for manual data entry.

The first two sources – interfaces and flat files – are tested, configured, and operated by experienced administrators and consultants who understand the data structures of source systems and SAP BPC, so these usually do not create problems.  The greatest risk is with data entered through input schedules by users who, whilst knowledgeable about the commercial functions of their organisations, are not experts in the data structures of financial information systems like SAP BPC.  The techniques available to ensure the integrity of data entered via input schedules are the focus of this article.

Topics: Thought Leadership, Enterprise Performance Management (EPM), Data, BPC (Business Planning & Consolidation)

Using the Power of Visual Basic in EPM 10 Reporting

Posted by Michael Sheard on Wed, Aug 06, 2014 @ 07:08 AM

The Excel Add-In reporting tool of EPM 10 combines the features of Excel with EPM functionality.  A feature within Excel that is sometimes useful to meet more advanced reporting needs is macros programmed using Visual Basic (VBA).  This can achieve features that are not achievable through EPM 10 functionality.

Topics: Best Practices, Excel, Thought Leadership, Analytics, EPM 10, Value

Replace a Working Spreadsheet Based Forecasting Model with SAP BPC?

Posted by Michael Sheard on Wed, Mar 05, 2014 @ 14:03 PM
SAP BPC forecasting model implementations frequently replace existing spreadsheet forecasting models.  A key question to be asked when implementing SAP BPC is to consider how it will improve a forecasting process that works and therefore justify the disruption the change may involve and the expense, both internal and external.

Topics: Excel, Analytics, Value, Implementation, Data, BPC (Business Planning & Consolidation), Forecasting

Within BPC Automatically Display Related Members

Posted by Michael Sheard on Wed, Nov 06, 2013 @ 09:11 AM

Column5 is the leading edge of Enterprise Performance Management and strives to provide technical tools which enable personal growth to benefit you and your organization. This blog will provide users high level functional help using dimension properties to automatically display related members

Topics: Enterprise Performance Management (EPM), Training

Useful Tips of Advanced Functionality in EPM10 Dynamic Formatting

Posted by Michael Sheard on Wed, Sep 18, 2013 @ 07:09 AM

 

Column5 is the leading edge of Enterprise Performance Management and strives to provide technical tools which enable personal growth to benefit you and your organization. This blog will provide users who are familiar with dynamic formatting tips and how to use the full functionality to refine formatting.

Topics: Excel, Training, Performance

Subscribe

Recent Posts

Posts by Topic

see all

3  S T E P S

To Enhance Your EPM Performance:

 1.Get Your Ultimate Guide to Improving SAP EPM Performance

ebook 2

 Learn what could be contributing to your poor performance and how to diagnose common problems. Get tips that will empower you and your team to improve the  performance  of your system in order to get the most out of your SAP EPM Investment.

Get the e-Book

 

2.  Test Your BPC Performance 

Benchmark 2

Get a BPC performance report card and custom report to identify performance issues you may not even know you have.

Test my BPC

 

  3. Get Your EPM Assessment  

Assessment

Our assessment delivers a complete, best practice roadmap for you to follow.  We’ll work together to assess what you need to pivot your financial forecasting, planning, reporting and analysis to handle the compressed requirements from the volatile COVID-19 environment. 

New Assessment