Want to learn ABAP for FREE with direct access to community of students and ABAP experts?

Category: BW

How to load data into data target only from PSA

-> Go to particular data source-> then go to data source manage-> select the particular request which you want-> below you have the option like ” update with scheduler “-> then it will show the info package click start the load Then the will load the data to target from PSA If no data targets...

Dump CX_RSR_X_MESSAGE during 3.x load into InfoCube

Problem During 3.x load into InfoCube (DataSource -> PSA -> InfoCube), loading status stays in the yellow status. Looking into ST22, the following short dump comes up with the exception CX_RSR_X_MESSAGE. Diagnosis The data update was not finished. A short dump has probably been logged in BI. This provides information about the error. System Response...

How to delete BW Query from ABAP code?

BW Query is stored as component(reusable element) in database table RSZCOMPDIR. To delete it, you need to search for query’s component UID (COMPUID) for existing query’s technical name saved in COMPID field. DATA: lv_compuid TYPE sysuuid_25, lv_subrc TYPE sysubrc. CALL FUNCTION ‘RSZ_X_COMPONENT_DELETE’  EXPORTING   i_compuid = lv_compuid          “hashed UID   i_delete_variables = rs_c_false “delete all related variables ...

How to debug BEx (Query designer)

To be able to debug external application, which uses RFC functions, you have to use external degugging. Sometime, this external breakpoint does not work. If so, firstly start RSRTRACE transaction, and now the breakpoint will work. QD uses class CL_RSZA_QUERY and its methods.Method that loads the query -> LOAD_QUERY (FM that loads the query element...

BEx Query designer – Introduction

Helpful presentations for BEx beginners Overview:Unit 1 – Introduction to BW ReportingUnit 2 – First steps in query designerUnit 3 – Restricted and Calculated Key figuresUnit 5 – Query variablesUnit 6 – Query propertiesariablesUnit 7 – Exceptions and conditions To see full screen presentations, click on provided link before each presentation Unit 1 – Introduction...

Exception condition “INCONSISTENCY” raised.

 I have encountered this error after saving Query using ABAP FM (usually you do this using Query Designer) The case is usually that in database tables are still stored some referencies for elements (RSZELTXREF), that are not present in element table (RSZELTDIR) To find out, where is the problem, run ANALYZE_RSZ_TABLES program through SE80 or...