Merging SAP BW Queries (Specifics for SAP BW)
Improve performance by saving time, round-trips, and memory by merging backend calls for multiple charts within a story.
Activate the query merge option for your story by clicking 
(Edit Story) 
Query Settings
. Select Enable Query Merge.
Select Visualize Query Merge to display colored charts in Edit mode. The same color in different charts indicates that queries have been merged.
Instead of sending single queries for each chart widget, combine requests with each other. The following chart types support the query merge option:
-
Bar/Column
-
Combination Column & Line
-
Combination Stacked Column & Line
-
Stacked Bar/Column
-
Stacked Area
-
Line
-
Bullet
-
Numeric Point
In general, charts within a story need to have the same query and the same variables as a basis in order to combine 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 story 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.