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 Start of the navigation path(Edit Story) Next navigation step Query SettingsEnd of the navigation path. 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.

Chart Types

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

Prerequisites for Combining Queries

In general, charts within a story need to have the same query and the same variables in order to combine the queries.

Note

The query merge process is triggered when opening the story (also triggered with the Set variables dialog when Automatically open prompt when story opens is set) or when manually refreshing the story by clicking Refresh.

Conditions that Allow Query Merges

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.

  • Presentation types are the same.

  • Queries are part of the same receiver group if they use linked analysis.

Conditions that Prevent Query Merges

You can't merge queries if the following factors apply:

  • The story has filters defined inside the threshold panel.

  • Queries contain the same thresholds, but they have filters.

  • The widget has a local filter on a dimension that is also used in a restriction in SAP BW.

  • The widget has a local filter on a member of the secondary structure of a query.

  • The widget has a local filter set when unbooked data is active.

  • The widget filter is defined as a complex tuple or range filter.

  • Dimension is selected in a chart in combination with a hierarchical widget filter or hierarchical drilldown filter on the same dimension.

  • Zero Suppression for the query is active when any dimension is selected in the chart.

You may also want to look at the following information:
Related Information