Planning and Consolidation, Version for Microsoft: Add an Excel Tool to Your Monitoring Capabilities

  • by Shameel Mohamedali, Sr. BI/BPC/EPM Consultant
  • September 16, 2011
Learn how to simplify the monitoring and logging of the performance of SAP Business Planning and Consolidation, version for Microsoft jobs using an Excel-based tool. It fills in gaps in Management Console monitoring.
Key Concept
SAP launched SAP BusinessObjects Planning and Consolidation, version for Microsoft with versions 5.1, 7.0, 7.5, and 10 in the last four years. The planning and consolidation application comes with a built-in, HTTP-based SAP Management Console (SAP MC) tool from version 7.x onward for monitoring performance. The SAP MC serves as a central point of access for monitoring and logging system performance of SAP BusinessObjects Planning and Consolidation, version for Microsoft. In the previous version, much of the information was obtained from other monitor tools and direct server console access.

The new SAP Management Console (SAP MC) in SAP BusinessObjects Planning and Consolidation, version for Microsoft offers several useful features for analyzing the Web server, database, and logging. However, it does not offer monitoring for some processes, including monitoring the size of write back (WB), Fac2, or fact tables of SAP BusinessObjects Planning and Consolidation applications. It also does not monitor record level locking that may occur in Data Manager scheduled jobs or standard tasks such as Lite Optimization or Currency Translation.

Note
SAP has come up with a dual platform strategy for business planning and consolidation, one for companies that prefer to stay in the Microsoft platform and another for companies that have SAP NetWeaver BI. This article focuses on the Microsoft platform for monitoring the SAP BusinessObjects Planning and Consolidation application.

To fill these gaps, SAP BusinessObjects Planning and Consolidation administrators can use my Excel-based performance monitoring tool on a day-to-day basis to monitor performance. You can see how to download, customize, and run this tool.

The monitoring tool focuses on the following areas:

  • Fact table sizes (write back, Fac2, and fact) and indexes for a given SAP BusinessObjects Planning and Consolidation application set
  • The locks on Data Manager, Send Governor service, Lite Optimization, admin optimization, and Currency Translation
  • Backups on the SQL SAP BusinessObjects Planning and Consolidation application set database and audit database
  • Any SAP BusinessObjects Planning and Consolidation-related SQL database jobs
  • Scheduled jobs
  • SQL users, sessions, and process (a SQL standard stored procedure to list information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine)

Shameel Mohamedali

Shameel Mohamedali is a senior BI/BPC/EPM independent consultant and lead who specializes in financial planning and consolidation applications and management dashboards. He holds an MS degree in computer applications. He started his career as a programmer analyst in the manufacturing industry, and then moved to different positions during the last 16 years. During that time, he has worked with Big-5 companies in the pharmaceutical, medical and life science, oil and gas, and automotive industries. He is currently working on a SAP implementation project with SAP Business Planning and Consolidation, version for SAP NetWeaver, in Pennsylvania. 

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.