How you can produce documentation about SAP BeX queries

SAP has made available a report that can be used to document SAP BeX queries.

To do so, proceed as follows:

Start transaction SE38 and enter RSRQ_QUERYDEFINITION











 After starting the report, provide the name of the BeX Query you need to document.

Use the search help to select the query name



Run the Report, after selecting your options



The report shows you the MultiProvider (and the components), Filters, Rows / Columns, Cells, Table View, Input Variables and Exceptions / Conditions.
All these topics can be expanded to have a detailed view.

 

The report can be printed and can so be used as (part of the) documentation.

How to locate SAP BEX Exit variables

Many times it happens that you want to know where Exit Variables, as populated in CMOD code, are used.
This blog tells you how to located the variables.

Open Admin Workbench (RSA1) and choose Transport Connection --> Object Types --> Query Elements --> Variable --> Select Objects.

Switch on the technical name view.

ETL data load - performance check

In this post I will describe a way how to analyse the performance of an SAP BW transformation. In this case, it is the transformation from Data Acquisition Layer into Data Warehouse Layer.

While running the transformation, start in another SAP GUI session SE30 - ABAP Objects Runtime Analysis:

Transactions in my Favorites

After some time working with SAP BW, I collected a list of transactions that are used frequently. This list is base on the so called "Back End" activities, like ETL.

My list is the following:

Debugging CMOD user exit variables

This posting is about how to debug the CMOD code for user exit variables. These variables are used in BEX query development.

 Start transaction CMOD and select the required Project (ZGL_VAR in our case)

 

 Select the Function exit (double click)

Welcome to SAP Business Intelligence

In this blog I will document the result of my struggele to get myself skilled in the SAP BW 7.0 environment.
It will contain tips and tricks which can be used by SAP consultants when performing SAP BW activities.
Let me know when you find this useful (Follow me) or let me know when you notice any issues.