SAP ABAP IMG Activity BW_ISET (Settings for InfoSets)
Hierarchy
☛SAP_BW (Software Component) SAP Business Warehouse ⤷BW (Application Component) SAP Business Information Warehouse ⤷RS (Package) BW: General Business Information Warehouse
Hypertext: Object Class - Class to which a document belongs.
Document Name
BW_ISET
Use
When queries are executed on an InfoSet with a large number of single value selections, selections are often missing in the where condition of the generated SQL statement. This results either in poor system performance or in termination due to limitations of the relevant database platform.
In this activity, you can specify a numerical value to represent the upper limit for single value selections (such as 300). If a characteristic has 300 single value selections, these are still displayed as a where condition. If a characteristic has 305 single value selections, a virtual InfoProvider is generated dynamically and added to the join. The single value selections are no longer processed using the where statement, but using the dynamically generated virtual InfoProvider.