Handy BW trick

| 0 Comments
SAP Business Intelligence (BI) 7.0 allows you to access the ABAP code behind a transformation easy via RSA1 > Transformation > Extras > Display Generated Program.

ur_debug_3x_00.png

However, there will be times when you will need to place soft-breaks and debug an older 3.x Update Rule.  Finding the generated program in 3.x is cumbersome and frustrating when the RS-table name escapes you.

If you ever need to find yourself in this situation, then here are the steps.  

Step 0. In our example, we will find the program for the update rule from export datasource 8ZSDDS115 to infocube ZAPO_C03.

ur_debug_3x_01.png
Step 1. Go to SE16 for table RSUPDINFO.  Enter your cube name in the INFOCUBE selection parameter, a value of "A" for OBJVERS.  Execute.

ur_debug_3x_02.png
Step 2.  Find the entry with your datasource or infosource.  In our example, our infosource is 8ZSDDS115.  Make a note of the value in the column URPROGID.  (click on the below image for the full picture)

ur_debug_3x_03.png

Step 3. Go to SE38 and enter the prefix "GP" with the URPROGID value from the above step. Click the DISPLAY button.

ur_debug_3x_04.png
Step 4. Navigate to the Start Routine or Object Routine that you would like to debug.

ur_debug_3x_05.png
Step 5. Place a soft-break(s) and exit.

ur_debug_3x_06.png
Step 6 and beyond.  With the soft-breaks in place, go head and load some data to the PSA and have fun. 

Leave a comment

Recent Entries

Orange Cat Sleeping Oceanside at the Waikoloa Hilton
During our last trip to Kaua'i, there were chickens at the Hilton. This time around on The Big Island,…
Happy New Year's Eve from Kona, Hawaii
Funny how things work out. I spent the better part of an hour trying to capture the sunset from…
Island Bound!
Flight attendants are wearing leis and serving Mai Tais. I think we're on the right plane. =P Posted via email…