Monitor Your Queries and Workbooks: Part 2

  • by Iliya Ruvinsky, Managing Partner, Skywind Consulting, Ltd.
  • August 1, 2005
The relationship report part of the MONitoring Application (MONA) allows you to quickly display relationships among InfoCubes, queries, and workbooks. Learn how to create your own time-saving relationship report.
Key Concept
Relationships among InfoCubes, workbooks, and queries are many-to-many. For instance, workbooks often contain multiple queries and relate to more than one InfoCube. InfoCubes can contain workbooks with multiple queries. Tracking the status of queries, InfoCubes, and workbooks is an essential task that is difficult without a central monitoring system such as MONA’s relationship report.

Finding timely and important information about the hundreds of queries, workbooks, and InfoCubes that BW system administrators and BEx developers deal with each day can be a struggle. I created a tool called the MONitoring Application (MONA) to quickly display information about InfoCubes, queries, and workbooks. MONA compiles the data in a central location and provides a quick overview of what is happening in your BW system.

Workbook monitor is a part of MONA, which I introduced in my May 2005 article, “Monitor Your Queries and Workbooks.” That article explained how to create a BEx report to monitor workbooks and transports with MONA.

I’ll now describe another useful part of MONA: the relationship report. Using this report, you can find out at a glance how a query, InfoCube, and workbook are related. The relationship report shows the current status of a query, workbook, or InfoCube (Figure 1).

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.