Go back to SAP Business Planning and Consolidation, version for NetWeaver WIKI Space
Go back to SAP Business Planning and Consolidation, version for Microsoft WIKI Space
Welcome to the EPM Add-in Academy, where we demonstrate functionalities, tips and tricks, training and help on how to best utilize the EPM Add-in with Business Planning and Consolidation (BPC) 10.0 / 10.1, version for Netweaver powered by SAP HANA and version for Microsoft
Videos will be added continuously, so please check this page often.
Please see the EPM Add-in user guide: EPM Add-in User Guide and the EPM Add-In Report performance Best Practice Guide: http://scn.sap.com/docs/DOC-49455
Other interesting information about the EPM Add-in can be found on the EPM Add-in Help page (What's new, Installation and Upgrade information, Security information, Administration and Maintenance information, etc.)
Videos
EPM Add-in Comments
- 3 ways of retrieving comments
- 3 ways of inputting comments
- Input cell comments in a protected worksheet (leveraging the native Excel comments fonctionnality)
Formatting
Macros
- How to call the API
- How to use the EPMExecuteAPI function (former EVMNU)
- How to loop through dimension members (for report automation) in BPC 10 using EPM Add-in API?
- Input Schedule Validation using EPM Add-in events
- How to format numbers in Lakhs and Crores in SAP BPC Excel reports?
Local Members
- 3 Types of Local Members
- Before and After Ranges (with formatting)
- Percentage of Total
- Dynamic Local Member Descriptions
EVDRE (Used with the EPM Add-in) and Legacy Functions
- How To Recreate EVEXP and EVNXP-like Reporting Structures In EPM Add-in (Article)
- How EVDRE works and is being migrated
Miscellaneous Reporting
- Butterfly Report (Sharing Axis)
- Rolling 12
- Planning Using Properties
- Reporting using Dynamic Filters
- Driver Based Input Schedule
EPM Add-in How To Guides / Best Practices
- Debugging the EPM Add-in
- How to Setup User Options in EPM Add-in
- How To Recreate EVEXP and EVNXP-like Reporting Structures In EPM Add-in (Article)
- Best Practices When Reporting Against BPC on HANA utilizing the EPM Add-In (Document)
13 Comments
Matthias Maier
Like it.
Sachin Prabhudesai
Very useful demos. Very well explained. Nice Job.
Former Member
Enjoyed these videos very much. Like the length and content. Looking forward to more content like this.
Rahul Verma
Wow - good initiative - how about adding sample projects for the following as well:
Mark P Burke
Sales planning and capex and high-level HR planning is covered in the rapid-deployment solution called Extended Financial Planning (BPC 10.x NW) and is free content to licensed customers/partners of BPC.
Consolidation scenarios are covered in RDS: Financial Close & Disclosure Management (BPC 10.x NW/MSFT & FC)
Contact mark.p.burke@sap.com if you want one-on-one guidance in this area. Thanks!
Mark P Burke
There is an alternative way to write a Rolling 12 (time) EPM report, without needing to go through all the Excel formula mechanics noted in the EPM demonstration above. See the rolling time methodology deployed in the financial planning model within the SAP planning rapid-deployment solution (RDS) called Extended Financial Planning (BPC 10.x NW) or contact mark.p.burke@sap.com for a discussion on best practices in this area. The RDS is free content to SAP customers of BPC so you can download the model and documentation and explore for yourself.
Mark P Burke
For a very robust example of driver-based planning using EPM add-in and BPC Logic, please review the strategic financial planing model within the SAP planning rapid-deployment solution (RDS) called Extended Financial Planning (BPC 10.x NW) or contact mark.p.burke@sap.com for a discussion on best practices in this area. The RDS is free content to SAP customers of BPC so you can download the model and documentation and explore for yourself.
Former Member
Hello Mark,
We are planning to implement BPC 10.1 NW on HANA for one of our customers.
While going through your blog, I found that there is a readily available solution i.e. Environment which is available for customer with different business models like sales planning, capex planning, HR planning and consolidation too.
Can you guide me how can i download this Environment and related documentations.
How can i use this environment for my implementation for a telecom domain client.
Are this environment available domain specific like power/telecom/retail or there is only single solution.
thank you!!
Mark P Burke
Hello:
The main BPC RDS planning models are here: Extended Financial Planning (BPC 10.x NW), including G/L Financial Planning, Strategic Financial Planning, and Capital Planning.
The BPC RDS consolidation models are here: Financial Close and Disclosure Management (BPC 10.x NW)
Please setup a meeting with Mark.p.burke@sap.com (Mark Burke) and I can walk you through the solutions. I am based in the California time zone.
Thanks,
Mark Burke
Former Member
HI Patrick ,
I'm not able to view the videos. They are stopping in the middle abruptly.
Getting a message saying "video is corrupted".
Can you please check on this?
Thanks,
Priya
Inna Maltz
Lots of great info here! Thank you !! Any suggestions where i can get more information on customizing Data Manager packages? I'm trying to default the time dimension value so that I can schedule the calc_account and BCF packages.
Former Member
I am not able to view the videos since today (2016-06-22) morning. Yesterday they were working fine. They link to a strange files that are not videos.
This page contains a VERY essential materials.
Could you check what is happening?
Thanks.
Javier
Former Member
Everything is OK. Just download or go to the "childern page".