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 Enable Query Merge.
. SelectTo activate the merge for SAP HANA calculation views in your application, click Enable Query Batching. Here you can also determine the number of queries to be merged (at least 4 and at most 20).
and selectIn 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.
-
Bar/Column
-
Combination Column & Line
-
Combination Stacked Column & Line
-
Stacked Bar/Column
-
Stacked Area
-
Line
-
Bullet
-
Numeric Point