Problem Statement: Sometimes we have a requirement to remove a query from BW Accelerator which is built on a cube on which a lot of other queries are also built. Some classic scenarios are:
1–>Pre Go Live Business Validation stage
2–>When data in BW and BWA fail to match due to some reasons.
In scenarios like this we want to remove that particular query from BWA by keeping the cube indexed and all other queries in the cube still fetching data from BWA.
Below is the Step by Step Process to achieve this.
Step 1: Go to T Code SE16 and enter the table name as RSZCOMPDIR.
Step 2: Click on Table Contents or Press Enter. You will get the screen below.
Step 3: Enter the fields OBJVERS (Version) as ‘A’ and COMPID (Query) with the technical name of the Query as shown below.
Step 4: Click on Execute (F8) to get the COMPUID (ID) field value.
Step 5: Now Go to T Code SE16 and enter the table name as RSRREPDIR and Click on Table Contents or Press Enter. You will get the screen below. Here Put the COMPUID filed with the value of Step 3 and OBJVERS as ‘A’.
Step 6: Execute and view the table entry.
Step 7: Change the field NOHPA (Do not Use HPA) shown below to ‘X’.
It’s done. Now this cube will not fetch data from the accelerator. Setting this field back to blank will enable it to start getting data from BWA.