SAP BusinessObjects Planning and Consolidation: Use Data Manager Effectively

  • by Ryan Leask, Senior Director, Solution Strategy for SAP’s Business User and Line of Business Sales Organization
  • Prakash Darji, Vice President and General Manager, Data Warehousing Solutions and SAP HANA Platform, SAP
  • August 23, 2010
Data Manager in SAP BusinessObjects Planning and Consolidation enables you to import and export data as well as execute background tasks and planning logic. Discover best practices for setting up Data Manager, including setting up packages, working with transformation files, and working with conversion files.
Key Concept
A Data Manager package is an object you use to execute SAP BusinessObjects Planning and Consolidation functions, such as loading data or executing planning logic. A transformation file is an Excel file that maps the source data you load into SAP BusinessObjects Planning and Consolidation. A conversion file is a Microsoft Excel file that defines the mapping from the source to the target for a particular dimension.
Data Manager is an SAP BusinessObjects Planning and Consolidation module that helps you manage loading, transforming, and manipulating data. Not only is running Data Manager packages a business user activity, building Data Manager packages is also an activity that the business owns. Typically, the creation of Data Manager packages is owned by a power user in the line of business who is familiar with the different sources of data that the business may need to load into SAP BusinessObjects Planning and Consolidation for use within their planning applications. We discuss setting up Data Manager packages, working with transformation and conversion files, running and scheduling packages, as well as monitoring the status of packages.

Ryan Leask

Ryan Leask currently runs the SAP BusinessObjects Planning and Consolidation solution management team for SAP, based out of Palo Alto, CA. Prior to this position, he led the EPM solution architecture team with a main focus on the design of SAP BusinessObjects Planning and Consolidation 7.0, version for SAP NetWeaver. Ryan has also worked on SAP xApp Analytics, SAP NetWeaver Visual Composer, SAP NetWeaver BW, SAP SEM, ABAP, SAP CRM, analytics/data mining, and whatever else seemed interesting. He has also co-authored SAP xApp Analytics (SAP PRESS, 2006), written many articles, and presented at numerous conferences.

See more by this author

Prakash Darji

Prakash Darji is an experienced professional with more than 10 years of end-to-end experience in enterprise software. He has a broad depth of experience including corporate strategy, sales, product management, architecture, and development. He has experience in product launch activities, including positioning, packaging, and pricing. He has delivered numerous product releases in a variety of capacities through his career. He thrives on building high-performing, scalable teams to achieve strategic deliverables, whether they close strategic sales deals, roll in product features, or roll out new releases. He is a recurring author for several publications and a speaker at SAP conferences around the world. Prakash is on LinkedIn at

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.