Monitor Your Queries and Workbooks

  • by Iliya Ruvinsky, Managing Partner, Skywind Consulting, Ltd.
  • May 1, 2005
It’s a challenge to identify when a workbook or query was changed if many consultants are working on a project. You need that information when you are deciding which workbooks to transport. Learn about a method to monitor workbook changes.
Key Concept
In BW, it is important to have instruments for object monitoring. These tools are not a standard part of current versions of BW (3.0-3.5). You can use the application described in this article as part of your object monitoring strategy. It can provide you with a quick and easy understanding of the relationships among InfoCubes, queries, and workbooks.

Many BW projects have large groups of consultants heavily engaged in the development of Business Explorer (BEx) or Web Application Designer (Web AD) reports. Projects of this type usually encounter control and transport architecture problems.

For instance, picture this scenario. Ten people are working simultaneously to develop 20 BEx reports in a day. The reports are then transported to your test and production environments. After six months, BW BEx architecture involves hundreds of queries and workbooks that are constantly rebuilt and updated according to end-user demands. Every day these updates and corrections must be transported from development back to test and production environments, along with the newly developed reports.

When working in this type of environment, you might ask yourself, “Who developed this specific workbook? When was it developed? Who has changed it and when? Which queries are related to which workbooks and vice versa? How many queries or workbooks were developed since yesterday or last week?”

Iliya Ruvinsky

Iliya Ruvinsky is a managing partner at Skywind Consulting Ltd., Israel. He is an SAP-certified BW consultant and instructor with more than 12 years of experience working with SAP BW and SAP BusinessObjects. He is an implementation and project management expert, serving for more than eight years as a trusted advisor to a wide range of Israeli enterprises, including in the insurance, energy, sales, and logistics industries. He is a graduate of the University of Tel Aviv, Israel, holding an MBA in information systems analysis.

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.