Discover the Advantages of Using EvDRE with SAP BusinessObjects Planning and Consolidation

  • by Smruti Pattani, SAP BI-BPC Solution Specialist, The Principal Consulting
  • Anupam Gupta, EPM Practice Manager, The Principal Consulting
  • November 11, 2009
Learn how to design and develop reports and input schedules using EvDRE. Also find out best practices for reporting and performance improvement tips when using EvDRE with SAP BusinessObjects Planning and Consolidation (both Microsoft and SAP NetWeaver versions).
Key Concept
EvDRE ([Everest] Data Range Exchange) is the SAP BusinessObjects Planning and Consolidation reporting function that you use to build static and dynamic reports, as well as input schedules for planning and analysis. The reports retrieve data from the database as an Excel interface, whereas input schedules update the data and send it from the Excel spreadsheet back to the SAP BusinessObjects Planning and Consolidation database. Input schedules share the same functionality and formatting features as reports.

One of the most common financial planning scenarios is Cost Center Planning. Once the top- level budgets are distributed to the respective cost centers (or cost center groups), the individual cost center managers, planners, or department heads split this budget into a more granular level of cost elements and other planning objects. These detailed planning layouts are specific to that cost center (or department). A predefined EvDRE ([Everest] Data Range Exchange) template is an ideal starting point for the planners. They can reuse an existing template and make adjustments and enhancements to suit their specific cost center needs. This saves considerable effort in learning and development.

EvDRE transfers a range of data at a time, thereby optimizing the network bandwidth. This makes it a preferred choice over cell-specific functions. Such optimization is critical to a global business planning scenario, which covers a range of bandwidth situations. 

SAP BusinessObjects Planning and Consolidation offers dynamic report and input schedule templates with predefined formats. You can use these dynamic templates as a baseline for creating custom reports or input schedules. The EvDRE function generates a control panel automatically as part of a template for reporting requirements. The control panel contains built-in expansion functions that automatically create the correct MDX queries to run against the database. Thus, the control panel is helpful in customizing the format and content of the template.

Smruti Pattani

Smruti Pattani is an SAP NetWeaver BW and SAP BusinessObjects Planning and Consolidation solution specialist with The Principal Consulting. She has more than six years of business analysis and SAP application development experience. She has worked on multiple implementations building solutions using SAP tools such as SAP NetWeaver BW, SAP BusinessObjects Planning and Consolidation, and SAP BusinessObjects. Her strong analysis and technical skills have helped clients map their business requirements to SAP technology.

See more by this author

Anupam Gupta

Anupam Gupta works as a practice manager at The Principal Consulting (TPC), managing its enterprise performance management (EPM) practice. He has more than 10 years of development and global consulting experience with SAP solutions in the areas of financial planning, reporting, and consolidation. He has significant experience advising clients on IT strategy and technology road maps. He is responsible for the development of EPM competencies, knowledge management assets, and TPC-developed solutions spanning a range of SAP products such as SAP NetWeaver BW, SAP BusinessObjects, SAP Business Planning and Consolidation, and SAP Strategic Enterprise Management.

See more by this author


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.