Optimize Report Distribution with SAP BPC's Book Publication Feature

  • by Charles "Tim" Soper, Senior Education Consultant, SAP
  • June 28, 2013
Discover the best way to design reports to be published in SAP Business Planning and Consolidation and how to configure the publisher to generate the data snapshots that you need. Learn how to:
• Create workbooks to be published
• Configure the publication template
• Use the wizard
• Display the results
Key Concept
Book publication is a new feature in SAP Business Planning and Consolidation (SAP BPC) 10.0 that generates PDF files from Excel worksheets. The PDFs with static data can then be viewed very quickly by paging through the PDFs with the Book Viewer from the Web Client.

Most reporting in SAP Business Planning and Consolidation (SAP BPC) is performed in Excel via the SAP Enterprise Performance Management (SAP EPM) add-in on live data. Users open Excel reports, refresh the data, view the initial result set, and then proceed with more analysis as needed by changing member selections or changing the axis dimensions.

Book publication is an important option when it comes to distributing reports in SAP BPC because it provides quick flash reports based on static data. There are four key advantages of book publication:

  1. The data snapshots are generated for the users in background jobs before they log in.
  2. There is no need to refresh data; therefore, the user can go through data sets very quickly.
  3. Because the data is static, the users have a stable data set to perform their analysis.
  4. The book viewer, a separate Internet Explorer session for viewing the PDFs, provides an easy-to-use interface with drop-downs for variable dimensions.

Next, I discuss how to create an Excel report in the SAP EPM Report Editor for publishing. The Report Editor is the user interface in the SAP EPM add-in used to create new reports.

 

 

Charles "Tim" Soper

Charles “Tim” Soper is a senior education consultant at SAP. For the last 17 years, he has been teaching SAP classes on a variety of topics in financial and managerial accounting, business warehouse, business consolidations, and planning. He is the planning and consolidation curriculum architect and has written SAP course manuals. He also works as an SAP Senior Educational Consultant. Early in his career, he worked for Eastman Kodak Company in Rochester, NY, as a senior financial analyst. He has an undergraduate degree in economics and an MBA in finance from the University of Rochester.

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.