Merge SAP BW Queries in Charts

You can improve the performance in terms of saving time, round trips, and memory by merging backend calls for multiple charts within an analytic application.

To activate the query merge for SAP BW queries in your application, select Start of the navigation path (Edit Analytic Application) Next navigation step Query Settings End of the navigation path . Switch on Enable Query Merge.

Note

To activate the merge for SAP HANA calculation views in your application, select Start of the navigation path (Edit Analytic Application) Next navigation step Query Settings End of the navigation path and switch on Enable Query Batching. Here you can also determine the number of queries to be merged (at least 4 and at most 20).

Prerequisites for Merging Queries

In general, charts within an application need to have the same query and the same variables as a basis in order to merge the queries.

You can merge queries if the following factors apply:

Queries contain the same dimensions with the same hierarchies and drill.
Queries use the same sorting and ranking, but don't have any filters.
The application does not have filters defined inside the threshold panel.
The widget does not have a local filter on a dimension that is also used in a restriction in SAP BW.
Queries are part of the same receiver group if they use linked analysis.
The widget does not have a local filter on a member of the secondary structure of a query.
The widget filter is not defined as complex tuple or range filter.
Presentation types are the same.
Zero Suppression for the query is not active when any dimension is selected in the chart.

Supported Chart Types for Query Merge

Instead of sending single queries for each chart widget, you can combine requests with each other. The following chart types support the query merge:

Bar/Column
Combination Column & Line
Combination Stacked Column & Line
Stacked Bar/Column
Stacked Area
Line
Bullet
Numeric Point