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

SAP EPM
Thought Leadership

Michael Sheard

Michael Sheard

Recent Posts

Introduction to SAP Disclosure Management

Posted by Michael Sheard on Tue, Dec 01, 2015 @ 08:12 AM

Overview

SAP Disclosure Management is an application within the Enterprise Performance Management suite.  It is used to improve organisations’ reporting where multiple users need to contribute to reports, and accuracy and consistency is critical. Key examples are the Annual Report and Accounts, returns to financial markets and regulators, and internal reports such as board report “books”.

The business case for Disclosure Management is that it manages and streamlines the process of bringing together multiple data sources and text required in reporting all of which are owned and authored by multiple teams and which require approval by multiple approvers.  This article provides an overview of the business case for and operational structure of SAP Disclosure Management.

Business Case

The below diagram created by SAP demonstrates the issues faced in reporting that Disclosure Management is designed to streamline.

A typical process leading to a major reporting output such as an annual report or regulatory filing will often have a wide range of data sources  For example, General Ledger systems - Enterprise Performance Management applications such as SAP BPC and BFC and manually created inputs such as written text.  These data sources often feed into numerous Excel and Word documents that form part of the reporting output.  The report sections require approvals and collaboration within the organisation that can be difficult to monitor and coordinate.  The sections of the report that have been created separately need to be put together into the final output.  In the past, the output may have only been a printable format such as a Word document or PDF file, but a number of legal and regulatory filings require electronic submission, notably via XBRL.

Topics: Enterprise Performance Management (EPM), Business Intelligence (BI), Analytics, Financial Information Management, Data

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