Overview
There are two main OT processing blocks during the query runtime:
- OLAP Processor (or Analytic Engine) is the layer responsible for receiving and processing frontend requests. Depending on the navigation, the frontend sends information what characteristics are in the drilldown (rows and columns), what values have been filled into variables and what dynamic filters might have been set. This information is summarized (and merged with the fixed filters) into an OLAP request and handed over to the Data Manager. The Data Manager then retrieves the data from the respective InfoProvider, and hands it back to the OLAP Processor which then performs the calculations, currency translations, eception aggregations etc defined in the query. See note 1151957 where some more information is provided regarding the processing sequence.
- Data Manager (DM) is the layer responsible for translating the OLAP request for data retrieval from the different InfoProvider-types (e.g. Basis Cube, MultiProviders or Virtual Cubes). It also creates the necessary (SQL) statements which are finally processed by the data base/BWA/HANA.
In this part of the OT Wiki you can find more information to the DataManager and some related topics. See also the "Main Processing Layers" of page OLAP Core.
Topics
- DataManager called by Query / LISTCUBE
- Inconsistent Time Dimension
- Number Overflow in BW Processes
- Function RSDRI_INFOPROV_READ
- Data Base Partitions
- Compressing InfoCubes
- Temporary BW Objects
- Transaction RSRV
- Selective Deletion
- Data Federator Facade RSDRI_DF
- Reading Archived Data (Near-Line Storage)
- Technical Key Figure 1ROWCOUNT
- DataMarts
- Convex Hull
- Remodeling
- Master Data and SID Table
BWonHANA and BW/4HANA specific topics
- Operation and Administration of HANA DB
- BWonHANA: Large Data Volumes and Partitioning
- BWonHANA: Temporary BW tables
SAP Consulting Notes at a glance
Top 10: all of them highly recommended
- 590370 Too many uncompressed request (f table partitions)
- 1388570 BW Change Run BW7x
- 1557321 Numeric Overflow during standard BW processes
- 1174503 Analysis for incorrect results using aggregates
- 1587759 Duplicate Records in InfoCube Dimensions
- 1772036 Inconsistent Time Dimensions
- 1139396 Temporary database objects in BW 7.X
- 1016185 ORA Repartitioning: Merging partitions
- 1016184 ORA repartitioning: Attaching partitions
- 1008833 Supplementary SAP Note about Repartitioning
- 407260 FAQs: Compression of InfoCubes