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
IMG Activity
ID BW_ISET Settings for InfoSets  
Transaction Code S_BR8_35000011   (empty) 
Created on 20031112    
Customizing Attributes BW_ISET   Settings for InfoSet 
Customizing Activity BW_ISET   Settings for InfoSet 
Document
Document Class SIMG   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.

See also SAP Note 673575.

Requirements

Standard settings

Activities

Example

Business Attributes
ASAP Roadmap ID 201   Make global settings 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG BW_ISET 0 ARS0000022 Warehouse Management 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
RSADMINCV19 V - View RSCUSTV19  
History
Last changed by/on SAP  20031112 
SAP Release Created in 720