Merging SAP BW Queries in Charts

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

To activate the query merge for SAP BW queries in your application, click Start of the navigation path(Edit Analytic Application) Next navigation step Query SettingsEnd of the navigation path. Select Enable Query Merge.

Note

To activate the merge for SAP HANA calculation views in your application, click Start of the navigation path(Edit Analytic Application) Next navigation step Query SettingsEnd of the navigation path and select 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.

Chart Types Supporting Query Merging
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