Working with Query Views
Use
A query view is a modified view of the data for a query or an external InfoProvider. A query view contains a section or a navigational state of a query or an external InfoProvider.
You can define multiple query views for a query. You define query views by saving the current state of a data provider in a BEx application.
You execute a query with its initial view for and change the initial view by navigating in the data for example, and save this new navigational state as a query view. If you change the initial view of the query subsequently in BEx Query Designer, this change has no effect on the query view previously saved. The query view already exists as an independent object.
An important feature of query views is that they reflect the navigational state of a query in the BW system and define a view of an external InfoProvider as well.
Like with queries, you can use query views as data providers in a BEx Web application. Using data providers of type Query View, you can easily define a BEx Web application that displays external data. By creating multiple data providers, you can display internal and external data simultaneously in a BEx Web application. You can use all Web items in this type of BEx Web application.
BEx Web Analyzer is a BEx Web application for example that displays both internal and external data.
Prerequisites
At least one query is available in the BW system. For an external InfoProvider, you need to have specified an external system in the system landscape of the portal.
External systems can be connected using JDBC. The data from the external systems is available as external InfoProviders.
External systems are only visible in BEx Web Analyzer if the BW Directory Provider property has been activated for the system object in the system landscape.
More information:BI Java Connectors
Procedure
Defining Query Views
A query view is based on a query or an external InfoProvider. Using navigation and filtering, you can tailor the state of a query to the state you require. By saving this navigational state, you create a query view.
A query view is therefore defined by modifying the navigational state of a query or an external InfoProvider.
You can define query views in the following BEx tools:
- To define a query view based on a query in Microsoft Excel in BEx Analyzer, choose Open → Open Query in the analysis toolbar and select Query View as the type in the open dialog.
More information:Open
- In BEx Web Analyzer, choose New Analysis to define a query view based on a query or an external InfoProvider in the Web browser.
More information:Pushbutton Functions, Navigation Pane, and Context Menu
Saving Query Views
You can save query views in the following BEx tools:
- In BEx Analyzer, choose Save → Save View in the analysis toolbar to save the current navigational state (view) of the data provider assigned to the design item in the active cell.
More information:Saving
- In the context menu for BEx Web Analyzer, choose Save View.
More information:Pushbutton Functions, Navigation Pane, and Context Menu
- In SAP BI Content systems, query views are saved without variables by default. You can override and change this setting for Business Explorer using the user parameter RSZSAVEVIEWWITHVARof a BW system. More information: Editing User Defaults and Optionssapurl_link_0003_0006_0016
You can override the default setting in Web Analyzer specifically for BEx Web. To do this, choose Save View from the context menu in Web Analyzer. In the dialog box that appears, select the checkbox Save Variable Values.
Displaying Query Views
You can display query views in the following BEx tools:
- To display a query view in Microsoft Excel in BEx Analyzer, choose Open → Open Query in the analysis toolbar and select Query View as the type in the open dialog.
More information:Open
- In BEx Web Analyzer, choose New Analysis or Open to display a query view in the Web browser.
More information:Pushbutton Functions, Navigation Pane, and Context Menu
Distributing Query Views
Distribute the query views as precalculated documents or online links to the portal, by e-mail to other users, or to the printer for printing. You make the required settings in BEx Broadcaster. This is a Web application for precalculating and distributing BEx objects.
Call BEx Broadcaster from BEx Web Analyzer by pressing Send or choosing Broadcast from the context menu.
More information:Precalculating and Broadcasting Queries, Query Views, Web Templates, and Reports
Using Query Views
You can use query views as data providers for the following BEx applications:
- To perform data analysis or planning in BEx Analyzer workbooks, use the query views as data providers for design items in BEx Analyzer.
More information:Configuring Data Providers
- To perform data analysis or planning in BEx Web applications, use the query views as data providers for Web items in BEx Web Application Designer.
More information:
Creating Web Applications with BEx Web Application Designer
- To display the data in a formatted report, also known as an enterprise report, use the query views as data providers in BEx Report Designer.
More information:From the Query to the Report
Deleting Query Views
If you no longer require query views, delete them in the Open dialog in BEx Analyzer:
- In the open dialog, choose Query View as the type.
- Choose Delete in the upper right area of the dialog box.
You cannot delete query views in BEx Web Analyzer.
More information:The Open Dialog
Transporting Query Views
To make query views available in various BW systems, transport them.
If the transport system is activated, the query views are written to the standard BEx transport request when they are saved.
The technical name of the object type (TLOGO) for query views in transport requests is QVIW.
More information: