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.
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?”
Would you like to see this full item?