SAP Knowledge Base Article - Preview

3377848 - BW Query generation performance problem

Symptom

Query generation is slow for a BW Query in tcode RSRT.

Large access count on tables RSZELTPROP, RSZELTDIR and/or RSZELTXREF is observed during this time.


Read more...

Environment

  • SAP NetWeaver 7.5x
  • SAP BW/4HANA 1.0
  • SAP BW/4HANA 2.0
  • SAP BW/4HANA 2021

Product

SAP BW/4HANA all versions ; SAP NetWeaver all versions

Keywords

Query, generation, structures, resolve algorithm, property collisions, priority handling, RSZELTPROP, doc_status, FEMZ, Variable, Constant, Formula, GET_STRUC_MEMBER_PROPERTIES, _SET_LOOKUP_QUBH_REC, CL_RSR_RRI2_LRECH, optimization  , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-CORE , Core Services , Known Error

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.