Blog

SAP BW 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
SAP Business Warehouse activate all transformations
These posts might also be interesting:

How to check the InfoCube scheme

Replicate SAP BW DataSource

Unlock InfoObjects in Business Warehouse

Infoset throws dump while checking or activating
author.

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
5. September 2014
How to check the scheme of your InfoCube.
SAP Business Warehouse transaction listschema

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
These post might also be interesting:

Explosion of structured items 2LIS_03_BF

Relocation of OLAP functions on SAP HANA

SAP BW 7.4 Maintrain characteristics

SAP COPA key figure assignment
author.

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
5. September 2014

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.

Function Connect_to_SAP()

Dim myConnection As Object
Set myConnection = CreateObject("SAP.Functions")

With myConnection
  .Connection.System = "ABC" 'Systemname
  .Connection.client = "100" 'Client
  .Connection.user = "xyz" 'User
  .Connection.password = "123" 'Password
  .Connection.Language = "DE" 'Language
  .Connection.systemnumber = "00" 'Systemnumber
  .Connection.hostname = "" 'Hostname
End With

'Establish connection.
If myConnection.Connection.logon(0, False) <> True Then Exit Function
'System Logoff
myConnection.Connection.LOGOFF

End Function

Due to the parameters False in the connection following Logon screen appears. Should this not be displayed, the parameter must be changed from False to
True.

Update:

Since Analysis Office the connection is a little bit different, you now have to use the Analysis Office API command SAPLogon. Here is
an example Application.Run(„SAPLogon“, „DS_1“, „MyClient“, „MyUser“, „MyPWD“, „EN“)

You may also be interested in these posts:

author.

Hi,

I am Tobias, I write this blog since 2014, you can find me on LinkedIn and
YouTube. I work as a Data &
Analytics Consultant. If you want, you can leave me a PayPal coffee donation.
You can also contact me directly if you want.

4. September 2014

Blog

SAP BW activate all inactive transformations

author.

How to check the scheme of your InfoCube.

author.

Connecting via VBA to a SAP system

author.