Category Archives: SAP BW

While being displayed with their human readable description in the BW Administration Workbench (RSA1) some BW transportable objects are identified with a technical name (in UUID format) in the Transport Request object list. This can be quite annoying when one is trying to troubleshoot transport related errors. For instance when someone is trying to determine which Transformations, DTPs or Query Elements are contained in a given transport.

The following program lists all the objects of a transport by their human readable name. The program is in SAPLINK format.

Up to BW 7.3 included program RSDMD_DEL_BACKGROUND could be used to run MD deletions within Process Chains.
However already in 7.3 this program is obsolete and is to be replaced by a new program: RSDMDD_DELETE_BATCH. See note “1705824 – Old master data deletion is obsolete“.

‘ Find the GRID item by name and unhide it plus a range that is offset to the row below it
For Each oBexItem In oBexItems
If (oBexItem.Name = “GRID_1”) Then
‘Set range1 = oBexItem.Range
‘set the correct worksheet
Application.Worksheets(oBexItem.Worksheet.Name).Activate
Dim lFirstDataCell As Variant
lFirstDataCell = oBexItem.DataProvider.Result.Grid.firstdatacell
MsgBox oBexItem.Range.Row
MsgBox oBexItem.Range.Column
MsgBox lFirstDataCell.X
MsgBox lFirstDataCell.Y

I found a blog post describing a program that allows you to change the BEx query “External Access” flag en masse. Very useful if you start integrating SAP BO and SAP BW and want to expose your existing queries.

The blog author is named Campbell Skene and here is the link to his blog:

You can maintain the application component hierarchy in RSA6. There are options to create/delete/rename and move hierarchy nodes under the Hierarchy menu.

To transport a modified version of the RSA6 application component hierarchy you will have to manually add it to a transport by adding R3TR DSAA APCO (to transport the inactive version of the hierachy use R3TR DSAD APCO).

If the application hierarchy is in the $TMP package you first have to set it to a transportable package as follows:

If your application component hierarchy is assigned to local object then first you need to change the package.

Go to TCode: SE03
For Object Type Selection use: DSAA
Object: APCO
Now change object directory from $TMP to the one being used in your project.

See SAP note 382471 – BW-OLTP-APCO: How do I transport it?
Also check OSS note 542454