Downtime Announcement: Please note the SAP Community Wiki will be unavailable due to a system upgrade on Thursday, September 24th between 6 and 7 AM CEST
Skip to end of metadata
Go to start of metadata

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

BWonHANA and BW/4HANA specific topics

SAP Consulting Notes at a glance

Check out if you know all of them:

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

All Others

SAP Support Troubleshooting Guideline

SSG BW-BEX-OT-DBIF