BACK TO THE FUTURE - Formulate Consulting

Stephen Hambling, Director. Formulate Consulting
5 different areas with Planning functions?
BPC -10
BW planning -10
General ledger -10
Controlling (Cost Centre, Profit Centre, Product costing,
Projects etc) -10
CO- Profitability Analysis -20
EIS -50
3 places for Consolidation in Finance
BPC -10
BI/BW- SEM etc -10
External (hyperion etc) -10
Excel (!) -20
EC-CS -50
3 Finance reporting tools
BPC -10
BI/BW -10
Report painter & writer -10
Drill-down reporting -10
SAP Query -10
Summarisations and Evaluations -30
GL Wand & Reports Wand -100
Headline solutions
Business Intelligence
Designed and developed as a reporting tool
Great toolset
Handles large volumes
Manages external data too
Requires additional hardware and licences
Additional skillset needed
Implementation and support are a factor
Headline solutions
Business Planning and Consolidation
Another great tool
Excel based
Very flexible rules based approach
Combines SAP and non SAP data
Brings more control to forecast process
As with BI, hardware, skills, licences and implementation are a
Real benefits
 Time is the biggest constraint
 Fast turnaround and ROI
 Business need is NOW
 Resource is a constraint
 Business case must be viable
 Additional licence cost
 Hardware
 Complexity – sourcing skills to implement
 Supporting
 Maintaining in house skills is challenging
It’s the data stupid!!
Can’t report or analyse bad data
Rubbish in, Rubbish out!
Use SAP tools to enhance data
Flowing data through from earlier process
Simple stuff – assessments, substitutions, mandatory data, user exits,
All of FICO has planning capability
FI, Cost Centres, Profit Centres, COPA, Projects
Copy to new version, Custom formulas, not financial data
Upload from Excel is standard
Report Painter/Writer
Specific report writing tool for FICO
Row and Column reports
Formulas and Formatting
Output to Excel
Used by many standard Finance reports
Can add own reports
A good solution for finance reporting
Can add create own libraries
Formatting has limits
Report Painter
Create Evaluation structure
T.code MC27 to create a new Evaluation structure
Can use Data dictionary tables as source
Not restricted to Finance
Evaluation structure can be added to a Library
Can be used in Report Painter/Writer reports
For ad hoc or business specific reports its ideal
Evaluation structure
AR/AP Evaluations
Project Summarisations
 Create your own hierarchy,
with custom levels
choose the data to be collected
 Run the summarisation routine
 Fast reporting against the summarised data
 Create your own reports
 Available in Projects and Orders (PP, IO etc)
Going Old School!
EIS – the mini BI system within SAP!
Create a Cube (an “Aspect”), with Characteristics & Values
Create Master data – with Hierarchies
Full Planning tool
Extract data from source – internal or external
Standard loads from FI, CO, PS,TR, Consolidation
Or Custom load from SAP Query, or from standard Reports
Summarise data for speed
Manual data entry too
EIS - Structure
EIS - Setup
Reporting on EIS
Create Reports on the Aspect
Drilldown reporting
Create reporting groups and menu
Aspect creates Evaluation structure
So use MC27 to create a Report Painter Library
Aspect 001 = CO-PA
So CO-PA reports can be available in Report Painter
As can Externally uploaded data
CO-PA Drilldown report
CO-PA Report painter report
Going Old School!
 Requirement is financial Consolidation system
 EC-CS still available – works with New GL
 Fully functioning Consolidation system
 No additional licences or hardware
 User interface in SAP, not Excel
 Reporting via EIS/Report Painter
 Will accept external upload
Old school – Back to the future!
Excel planning uploads to GL, Controlling, CO-PA & EIS
Hold and manipulate any data in a cube in EIS
Consolidate in EC-CS
Report from any via Report painter and/or GL Wand
Upload external data
80% of the functionality of BPC, 20% of the cost…..
Not fashionable – but it works
In Summary
 Reporting can’t solve poor data
 BI and BPC are great tools
 The challenges are time, cost and ROI
 Standard SAP has good flexible reporting tools
 Digging back in time reveals some gems
 GL Wand is a real alternative.
The future might be behind you!

similar documents