SAP BW

BW systems offered Standard BEx queries, Info providers along with data flow to load and analyze various statistical data within the system. With BW/4HANA, delivered CDS views are available through which we can do reporting on statistical data. This blog explains the architecture for Statistical reporting using the delivered CDS views.

Query Runtime Statistics

Query runtime statistics are used to analyze the average query execution time in different layers such as the front end, OLAP, or data manager.

This can also be used to determine the execution time of certain user actions in the front end and in the analytic engine. The system records all these processing steps in the statistical tables, which are known as statistics events. It calculates the net time taken for processing a query by calculating the runtime of an event using the difference between the start and end time.