Hidden Tool Provides Query Information on a Single Screen

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • May 19, 2010
SAP NetWeaver BW has a little-known transaction called the query definition tool that provides a comprehensive view of any query. Discover where to find this tool and how to use it to your advantage.
Key Concept
The query definition tool provides one place to view all relevant details about a query without going into BEx Query Designer. The tool enables you to view the details of the query on one screen, rather than having to view the details over several BEx Query Designer and Query Monitor screens. The query definition tool offers a good place to troubleshoot, analyze, or document queries.

Typically, if you want to view all the data for a query, you have to go to several screens in BEx Query Designer. You then must also gather data from the Query Monitor (transaction RSRT). However, you can use the query definition tool instead to view these details on just one screen.

The query definition tool is available only on SAP NetWeaver BW 7.x. I’ll show you where to find this tool and provide tips for using it.

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

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.