Create Flexible Planning Workbooks Using Analysis for Office and SAP BPC 11.0

  • by Pravin Datar, Director, SAP BusinessObjects Planning and Consolidations Solution Management
  • December 11, 2017
Learn how you can create flexible planning workbooks with measures, local calculations, and local hierarchies using the SAP Business Planning and Consolidation 11.0 embedded model and Analysis for Office.
Learning Objectives

Reading this article, you’ll learn how to:

  • Create local measures in the planning sheet
  • Create local calculations in the planning sheet
  • Create local hierarchies in the planning sheet
Key Concept

SAP Business Planning and Consolidation 11.0 and Analysis for Office allow you to create planning workbooks that leverage the enterprise data warehouse models and to enhance them locally.

SAP Business Planning and Consolidation (SAP BPC) 11.0, version for SAP BW/4HANA introduced many new features. SAP BPC 11.0, version for SAP BW4/HANA supports both the embedded and standard models of SAP BPC. The recommended front end for the standard model is Analysis for Office with the Enterprise Performance Management (EPM) plug-in, whereas for the embedded model, the recommended front end is Analysis for Office with the Analysis for Office plug-in (AO plug-in). I include only information about the embedded model for SAP BPC 11.0, version for SAP BW4/HANA and how you can create sophisticated planning workbooks with it using the Analysis for Office AO plug-in.

Pravin Datar

Pravin Datar works as director in the Enterprise Performance Management (EPM) Solution Management team at the SAP BusinessObjects Division. He has more than 20 years of business experience that includes management consultancy, ERP project management, and SAP SEM, BPC RIG, and EPM solution management. He holds a master’s degree in industrial engineering and an MBA from University of California.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.