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