3399277 - 'Result set too large' message when filtering on linked dimension with active hierarchy

In a SAC Story you have two widgets with same structure built on two different queries and linked on a dimension with active hierarchy. When you apply filter for a hierarchy child node of this dimension, one of the widgets is not filtered and shows following message:

'Result set too large. Data procurement restricted by configuration'

• SAP Analytics Cloud
  
  
• SAP NetWeaver 7.5 SP20 and higher
• SAP NetWeaver 7.51 SP11 and higher
• SAP NetWeaver 7.52 SP7 and higher
• SAP NetWeaver 7.53 SP5 and higher
• SAP NetWeaver 7.54 SP3 and higher
• SAP NetWeaver 7.55 SP1 and higher
• SAP NetWeaver 7.56 
• SAP NetWeaver 7.57
• SAP BW/4HANA 1.0 SP18 and higher
• SAP BW/4HANA 2.0 SP7 and higher
• SAP BW/4HANA 3.0

1) Create a Story based on a Live Data Model

2) Create one table based on a original model and another table based on the other model (both models should have one same dimension with active hierarchy)

3) Make sure that tables have same structure (dimensions, axis etc.)

4) Link models on the mutual dimension with active hierarchy

5) Apply story filter in a hierarchy child node of the dimension

RSADMIN parameter BICS_ABAP_RESULT_SET_LIMIT_MAX  allows you to avoid returning result sets that are too large and that can have a negative impact on the performance and quality of Web applications.

In this case this parameter is set to a value that is less than number of cells that requested result set consists, thus resulting in 'Result set too large' message.

Additionally, when linked dimension with hierarchy is a part of the process, a confusing behavior is observed - the 'Result set too large' message is only shown for "receiver" widget, while "sender" widget is getting filtered correctly. This is happening because when the filter is set on a linked dimension that has hierarchy active in both widgets/models and you choose a value, SAC fires a call to "sender" query with this filter, but without any hierarchies active and gets a filtered flat representation result set from backend. And at the time, flat representation result set might have more cells than hierarchical presentation result set and can trigger the message.

Set RSADMIN parameter BICS_ABAP_RESULT_SET_LIMIT_MAX to a higher value.

SAP Note ##2948174 - BICS : Safety belt for large resultsets for BICS InA and oData based clients

Support Content - Filtering Across Models in Active Hierarchy Display

linked dimension, filter, hierarchy filter, hierarchy node filter, child filter, result set too large, restricted by configuration, linked dimension filter, table not filtered, linked dimension not filtered, hierarchy node not filtered, hierarchy not filtered , KBA , BW-BEX-OT-BICS-INA , BW INA provider , Problem