3629734 - Value help of filter is slower when filter has enabled cascading effect in SAC BW live connection story

Value help of filter is slower when filter has enabled cascading effect in SAC BW live connection story

SAP Analytics Cloud

1. Open a SAC story of BW live connection, which contains at least two filters/input controls.
2. Call value help of a filter/input control, e.g. Region.
3. It takes around 1s to finish loading the value help of filter 'Region'.
4. Cancel the dialogue, or reopen the story.
5. Set a filter for another story filter/page filter, for example, set filter 'Country' as 'Germany'.
6. Call value help of filter 'Region' again.
7. It takes around 20s to finish loading the value help of filter 'Region', and the filter 'Region' is automatically updated to show only regions within Germany. 

Cascading effect is enabled for corresponding filter.
When cascading effect is enabled for filter, changes made to a story or page filter affect related filters in the same story or page(Story filter changes affect both story filters and page filters in the story.). This cascading effect leads to additional backend calls to narrow the result set of the values for filtering. In network trace, observe that Q Access mode(ReadMode: "BookedAndSpaceAndState") is used for the value help call when cascading effect is enabled. While the result value list is more precise and displays less value, and performance is usually slower.
Be aware of the cascading effect when using multiple filters and do not overuse this behavior. 

Please consider whether enabling cascading effect is needed in your business scenario. If it is not needed, to improve performance, it is recommended to turn off the cascading effect in the settings for the filter or input control. When the cascading effect is turned off, any filter value selection changes made in this filter do not affect other filters, and any filter value selection changes made in other filters do not affect this filter. 

• Effects of Multiple Filters (Cascading Effect)
• Input Help (F4)
• SAP Note 1565809-BW Query Input(F4) Help: Settings and Properties

Performance, Cascade effect, Input Control, Access mode, Only Posted Values for Navigation, Q mode, BookedAndSpaceAndState , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem