Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
BACK TO THE FUTURE • 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 (hyperionetc) -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 factor
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, BTE’s, BADI’s
Planning • 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
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
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
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
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.