Query View Web Items Increase User Functionality and Improve Performance

  • by Ned Falk, Senior Education Consultant, SAP
  • February 1, 2005
Query views offer you a powerful tool that can make life easier for end users and enhance overall system performance. You can maintain and name views so that end users more readily identify and access them. While they are very powerful, views are not used enough because many don’t know how useful they are.
Key Concept
The query view Web item is a predefined query state that navigates to specific, predefined tables or charts via a drop-down selection menu. One SQL query executes the view. This transaction would otherwise take at least four clicks or require a custom-coded command sequence.

Since the launch of BW 3.5, working with views has become much easier. This latest version of BW provides the new view selection Web item, so different global views can be swapped for a specific Web item on a page. In addition, with the appropriate Web item properties, you can allow end users to create and delete views. You can also target a Web item to receive the data from the global query view you select, such as a table or chart.

Views are beneficial because they deliver data more easily and efficiently. They ease navigation for analysts and basic users when they slice information in various ways. A sales manager, for example, can access a view and learn all about a customer group and month then switch to an individual sales representative, customer, and day — all in one click.

You can scale back query proliferation with views. Because queries are easy to create, many companies support a large number of power users in the same functional area who all create queries. Creating good queries is more difficult, however, so your resources may be wasted on maintaining mediocre or even worthless queries. Views mitigate these issues by offering an alternative to authoring queries for the masses. Users can create views tailored to their individual needs rather than deploying more queries. Views are navigations, so their proliferation does not pose the same problem that query proliferation does.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

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.