Check your SAP Business Explorer Query Database Tables in a Single Step

  • by Uday Gupta, Business Intelligence Lead, J. Crew
  • August 30, 2011
Learn how to use ABAP ANALYZE_RSZ_TABLES to perform consistency checks on SAP Business Explorer tables.
Key Concept
The importance of analyzing SAP Business Explorer (BEx) query database tables is to ensure that the BEx query definition that is stored in multiple tables is consistent. That ensures that queries are correct, that all their elements are available to end users, and that the execution is undertaken in an optimum run time.

It is essential to have underlying SAP Business Explorer (BEx) query database tables in sync because different parts of queries are stored in different tables. ABAP ANALYZE_RSZ_TABLES is a useful tool to detect and solve different types of inconsistencies in the main query definition database tables.

Using ABAP ANALYZE_RSZ_TABLES, which is available in SAP NetWeaver BW 7.0, you can analyze your BEx tables in a single step. This ABAP tool reviews and corrects the query definition/elements stored in following BEx tables:

  • RSZCOMPDIR – Directory of reporting components
  • RSZELTDIR – Directory of the reporting component elements
  • RSZELTTXT – Texts of reporting component elements
  • RSZELTXREF – Directory of query element references
  • RSZOPRATXT – Texts of the formula operators  
  • RSRREPDIR – Directory of all reports
  • RSZCOMPIC – Assignment reusable component to InfoCube
  • RSZSELECT – Selection properties of an element
  • RSZCALC – Definition of a formula element
  • RSZGLOBV – Global variables in reporting
  • RSZELTPROP – Element properties (settings)

Uday Gupta

Uday Gupta has more than eight years of experience with SAP, including SAP NetWeaver BW, SAP BusinessObjects Planning and Consolidation, SAP R/3, and system analysis. He is also knowledgeable in software design and implementation methodologies, including SAP’s ASAP methodology. He has completed more than eight full life cycle SAP R/3, SAP NetWeaver BW, and SAP BusinessObjects Planning and Consolidation implementations. He has worked with PricewaterhouseCoopers and IBM in North America and Australia. Uday has worked in various industry sectors including media, pharmaceutical, consumer packaged goods, high tech, utilities, public sector, banking, telecommunications, and advertising. He is currently working with one of the largest retail organizations as a business intelligence lead responsible for the SAP NetWeaver BW system.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.