september 2014.
List of all SAP BW Users
Sometimes you want to know which users are created on a Business Warehouse system and if these have access or have been blocked from by incorrect logon. For this you can use the transaction rsusr200. In the transaction you can see the last login, the users validity, etc.
- Call transaction rsusr200
- Run
- List of all users appears
SAP BW Authorization check
Sometimes you have to check the rights of users. For this you can use the transaction su53.
Activate all inactive transformations
If you adjusts many objects in the Business Warehouse, a lot of transformations are automatically inactive. So you don't have to activate each transformation by hand, there is a ABAP program named RSDG_TRFN_ACTIVATE.
- Call transaction se38
- Run program RSDG_TRFN_ACTIVATE
How to check the InfoCube scheme
There are several ways to look at the structure of an InfoCube. One way possibility would be to analyze it on the transaction rsa1. Another way to show the structure of an InfoCube is the transaction listschema.
- Call transaction listschema
- Choose a type of InfoCube
- Select a specific InfoCube
- Run
Connecting via VBA to a SAP system
If you want to create automated reports with data from an SAP ERP or Business Warehouse system, you first need to connect to a SAP system. The connection can be used later to access system tables in the ERP or Business Warehouse or to trigger various other action.