SAP Knowledge Base Article - Preview

2470847 - How to Delete BW Statistics Data

Symptom

  • The BW statistics data is not getting deleted properly. 
  • Using the BI query runtime statistics, you can determine how much time the execution of certain user actions require in the front end and in the analytic engine. The system records the performance-critical parts of the processing (statistics events). It calculates the net times by calculating the runtime of an event using the difference between the start and end times (minutes the times for other events called from within the event ).
  • The BW statistics data is usually recommended to be used with queries for better results.


Read more...

Environment

  • BW, Business Warehouse 7.x
  • SAP Netweaver 7.x
  • SAP BW/4HANA

Product

SAP BW/4HANA all versions ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

delete, BW, Business Warehouse, statistics, data, RSDDSTAT, table, RSDDSTAT_DATA_DELETE, RSDDSTATAGGR, RSDDTSTATDTP, TSTMP_FINISH, TSTMP_START, RSDDSTATINFO, RSDDSTATAGGRDEF, RSDDSTATEVDATA, RSDDSTATDTP, performance , KBA , BW-BEX-OT , OLAP Technology , BW-WHM-DST , Data Staging , BW4-AE-CORE , Core Services , BW-BCT-TCT , BW Only - Technical Content and BW Administration Cockpit , BW4-AE , Analytic Engine , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.