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 BI application.
For example, you execute a query with its initial view, change the initial view by navigating in the data, and save this new navigational state as a query view. If you later change the initial view of the query in the 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 a query view not only reflects the navigational state of a query in the BI system, but can also define a view of an external InfoProvider.
In the same way as 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.
For example, the BEx Web Analyzer is a BEx Web application that displays both internal and external data.
Prerequisites
At least one query is available in the BI system. For an external InfoProvider, you must have specified an external system in the system landscape of the portal.
External systems can be connected using XMLA or ODBO. The data from the external systems is available as external InfoProviders.
External systems are only visible in BEx Web Analyzer when the BI Directory Provider property is 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:
● In the BEx Analyzer, to define a query view based on a query in Microsoft Excel, choose Open → Open Query in the analysis toolbar and select Query View as the type in the open dialog.
In the BEx Analyzer, you can only use queries as the basis for query views.
More information: Open
● In the BEx Web Analyzer, choose New Analysis to define a query view based on a query or an external InfoProvider in the Web browser.
In the BEx Web Analyzer, you can use queries and external InfoProviders as the basis for query views. Instead of using the BEx Web Analyzer, you can also use a BEx Web application that allows you to save query views.
More information: Pushbutton Functions, Navigation Pane, and Context Menu
Saving Query Views
You can save query views in the following BEx tools:
● In the BEx Analyzer, choose Save → Save View in the analysis toolbar to save the current navigational state (view) of the data provider that is assigned to the design item in the current active cell.
More information: Saving
● In the context menu of the 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 RSZSAVEVIEWWITHVAR
of a BI system. More information:
Editing User Defaults
and Options
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:
● In the BEx Analyzer, to display a query view in Microsoft Excel, choose Open → Open Query in the analysis toolbar and select Query View as the type in the open dialog.
More information: Open
● In the 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 the BEx Broadcaster, which is a Web application for precalculating and distributing BEx objects.
Call the BEx Broadcaster from the BEx Web Analyzer by choosing the Send pushbutton or by choosing Broadcast in 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 BI applications:
● To perform data analysis or planning in BEx Analyzer workbooks, use the query views as data providers for design items in the 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 the 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 the 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 of the BEx Analyzer:
...
1. In the open dialog, choose Query View as the type.
2. Choose Delete in the upper right area of the dialog box.
You cannot delete query views in the BEx Web Analyzer.
More information: The Open Dialog
Transporting Query Views
To make query views available in various BI systems, transport them.
If the transport system is activated, the query views are written to the standard BEx transport request when they are saved.
Note that you cannot create query views on the Web if the standard transport system is active because this requires the transport request dialog box.
The technical name of the object type (TLOGO) for query views in transport requests is QVIW.
More information: