Free Webinar: ForgeRock Launches On Demand Training


SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Reporting and Planning

  • Tuition USD $4,090
  • Reviews star_rate star_rate star_rate star_rate star_half 945 Ratings
  • Course Code BPC430-v017
  • Duration 5 days
  • Available Formats Classroom, Virtual

Skills Gained

  • Learn how to report and plan in the EPM add-in.
  • Learn how to use BPC process control features.

Who Can Benefit

  • Project Team Members
  • Advanced Business Analysts
  • Application Consultants
  • Business Process Owners / Team Leads / Power Users
  • Program / Project Managers
  • Trainers


  • Essential:
       -Experience with Excel
  • Recommended:

Course Details

Course Content

  • Overview of SAP Business Planning and Consolidation Version 11.0
       -Introducing SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA
       -BPC Modeling
  • Reporting and Planning with the Web Client
       -Navigating in the Web Interface
       -Using Business Process Flows
  • Reporting with the EPM Add-In
       -Introducing the EPM Add-In
       -Creating Ad Hoc Reports in the EPM Add-in with Member Recognition and the EPM Pane
       -Connecting and Configuring the Microsoft Excel Interface of the EPM Add-In
       -Using the EPM Report Editor
       -Using the Member Selector
       -Using the Account Types and the Measures Dimension
       -Linking Reports
       -Generating Worksheets
       -Creating Microsoft Office PowerPoint and Word Reports with the EPM Add-in
  • Advanced Reporting with the EPM Add-In for Microsoft Office Excel
       -Formatting Reports with the EPM Formatting Sheet
       -Advanced Formatting
       -Using Local Members
       -Reporting on Multiple Sources
       -Creating Butterfly Reports
       -Analyzing Data with Time-Dependent Hierarchies
       -Using EPM Functions
       -Using Advanced EPM Functions
       -Using the Drill-Through Feature
       -Publishing Workbooks
  • Planning with the EPM Add-In for Microsoft Office Excel
       -Explaining the Prerequisites for Input Forms
       -Using Built-in Planning Functions: Disaggregation, Spread, Trend, and Weight
       -Positioning and Using Comments in the EPM Add-In
       -Working with Comments in Web Input Forms
       -Managing Comment Data
  • Advanced Planning with the EPM Add-In for Microsoft Office Excel
       -Using the EPMOlapMember for Rolling Forecast Input Forms
       -Executing VBA and API Functions
       -Configuring Distribution and Collection
  • Use SAP Analysis for Microsoft Office for BPC and Best Practices
       -Using Delivered Reports
       -Options for Reporting BPC Standard Data
       -Creating Reports Using Best Practices in a End to End scenario


  • This course is revevant for the following SAP Business Planning and Consolidation (SAP BPC) applications:
       -SAP Business Planning and Consolidation, version for the Microsoft platform
       -SAP Business Planning and Consolidation, version for SAP NetWeaver
       -SAP Business Planning and Consolidation, version for SAP BW/4HANA This course applies to versions 10.0, 10.1, and 11.0.

Course based on software release

  • SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA

Is ExitCertified an authorized SAP training partner?

Yes. ExitCertified is one of the largest authorized training partners in North America. We have over 10 years’ experience and 1000’s of courses delivered through our SAP partnership.

Do SAP courses use live systems as part of the training?

Yes. SAP courses have live labs in real-time SAP systems. 

How do we access live labs for a virtual public course?

SAP courses use a Citrix plugin to access remote labs or the new OneClick platform that is browser-based (about 60% of all courses now use this method).  After registration, an email is sent with easy access instructions.

Do I get a certificate of completion after I take the course?

Yes. You will receive a confirmation directly from SAP showing you have completed your authorized SAP training course.

Do I get a certification after I take the course?

No. Most SAP certifications require 3 or more courses that make up the certification material for an exam. All SAP exams are proctored online through a separate program: CER006- SAP Certification in the Cloud.

Do I get a course manual as part of the class?

All SAP courses include a course manual. Virtual classes get a digital copy (can be printed), and live public courses or in-person private deliveries get a hard copy.  

Do you offer courses on ECC6 and S/4Hana?

Both traditional ERP/ECC6 courses are still being taught as well as courses on the new S/4Hana platform. 

What if I don’t see the date I need on the schedule?

As an SAP partner, we can add courses to the virtual public schedule with 3 students. 4-6 week timeframe needed to add dates to the schedule. Please contact us if you have 3 students and want to add a date.

Can this course be offered as a private delivery for a larger team?

Yes. We specialize in private deliveries for new implementations, upgrades, or SAP projects as needed. Please contact us to discuss setting up a private SAP delivery for your organization.

The course for Cognos Enterprise Admin was wonderful! Learned a lot and have started applying what was learned. Thanks.

There were minimal errors. The labs were great but the learning environment was difficult to navigate and certain components needed to stay on the screen that covered up parts of the presentation slides.

The courses are very in-depth and useful to get a good idea of everything and get going from there.

I really enjoyed the course. It was well designed given that it was online. I would recommend that the higher level courses be taken on-site, but this course was very thorough for those looking to get started with an AWS Certification.

The software installation instructions needs to be more clear. We spent a lot time on installing and setting up the environment.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward