SAP ABAP Data Element RSRMATERIALIZEQUERYLAYER (Materialize Intermediate Query Result)
Hierarchy
☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSROA_MISC (Package) OLAP: Various
Basic Data
Data Element RSRMATERIALIZEQUERYLAYER
Short Description Materialize Intermediate Query Result  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type RS_BOOL    
Data Type CHAR   Character String 
Length 1    
Decimal Places 0    
Output Length 1    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 MAT LQ 
Medium 20 Materialize Result 
Long 40 Materialize Intermediate Query Result 
Heading 55 Materialize Intermediate Query Result 
Documentation

Definition

If the query property "Operations in SAP HANA/BWA" is set to "Exception Aggregation" or higher, a major part of query processing takes place in SAP HANA/BWA.

Within this processing intermediate results are calculated. If the query contains many characteristics with subtotals in drill, these intermediate results can be reused during result calculation.

Normally it is faster to recalculate the intermediate results each time, because in this case subtotal level specific optimizations can be used. In some exceptional cases it is faster to materialize the intermediate result sets.

These cases involve a combination of the following:

  1. A large number of characteristics in drill, each with subtotals
  2. A huge reduction of data by standard aggregation
  3. Nearly no reduction of data based on filters

Use

If the performance of a query is insufficient, changing this parameter might help. In general it is not recommended to be set.

Dependencies

This property is only available in SAP HANA systems, not in BWA systems. In addition it is only considered if "Operations in SAP HANA/BWA" is set to "Exception Aggregation" or higher.

Example

The infoprovider contains 2 billion rows. Within the data there are:

  • 500 distinct material numbers
  • 20 countries
  • 5 billing types
  • 12 months

The query counts material numbers per country, country and billing type, country and billing type and month. The intermediate result set is the finest granularity of tuples needed within the query. If all combinations of the characteristics exist, this intermediate result size is 500*20*5*12 = 600000 rows

This intermediate result contains more than 1000 times less records than the infoprovider. Therefore the cost to calculate this intermediate result once and reuse it several times is probably cheaper than the optimizations that can take place when calculating the subtotal levels individually from the infoprovider data.

History
Last changed by/on SAP  20141013 
SAP Release Created in 740