Tips for beginner: SAP BW

[Former Member]

Hello everyone,

Not so long ago I started working with SAP BW (now about 10 months). Some tips from my colleagues and wide internet, which really helped me at the beginning.

So I decided to share some tips and make beginning a bit easier:

Killing process in os level ECC side (NOT RECOMMENDED):

     This is helpful when you create DataSourcer enchantment and write some incorrect user exit ABAP code. Then data extraction process can go on for weeks and sometimes you can't stop it in any other way, then this will help:

ECC -> se38 -> RSBCOS0 -> tskill <pid> -> enter

But remember this, it is not recommenced and your admin will not be very happy about it :smile: .

Check setup table record number:

     When you use transaction SBIW and load data to setup tables, sometimes you find asking yourself how much records is loaded? . This can be answered be doing this:  

Program: RMCEX_SETUP_ENTRIES to do this you should know application (13, 03, 11 and etc.)

ECC -> SE38 -> RMCEX_SETUP_ENTRIES -> Source code -> Display -> Press F8 -> Select application

If transport goes wrong:

     Transportation in SAP BW simple to understand but from time to time it can get tricky. So if transport is not successful and error log does not make much sense try this:

1. Check object directory entry package: Double click object -> Extras -> Obj. directory Entry -> If package is TMP change to your Z* package.

2. If you don't see new workbook after transporting with query from DEV to PROD next transport role for which report is assigned, it should help.

3. If package is correct but when you activate object it does not ask request then its assigned to other request.You can check this at SE10 selecting all users.

4. Check if all newly created objects was in transport: STMS -> Double click on request  (sample: BID123456) -> Browse transport objects

Some helpful daily transaction:

SAP BW:

SM50 - Process Overview (If your process goes for very long time you can cancel it with or without core. If this does not wotk tip above.

RSA1 - Modeling: DW Workbench

SE10 - Transport Organizer

SE03 - Tranport organizer tools (this transaction is helpful when you need to solve transport problems like object lock ant etc.)

PFCG - Roles maintenance

ECC:

LBWG - Delete data from setup tables

SBIW - Using this transaction you can load data to setup tables and more action with application

LBWQ - Empty the queue by deleting the entries

LBWE - LO Data Extraction: Customizing Cockpit

This is my first blog post, so any comment is welcome.