Skip to Content

Getting Application Server Name using VBA code in Business Object Analysis for Excel

Dear Experts,

I need help on the following. I am trying to get the details of a Data Source in SAP Business Object Analysis for Excel(64bit) using following code

DataSrcName = Application.Run("SAPGetSourceInfo", "DS_1", "DataSourceName")
Systemname = Application.Run("SAPGetSourceInfo", "DS_1", "System")

The Systemname i am getting as "SY1" , Is there a way to get the value "test123.test-sap.com"(Please refer the attached image selectdatasourcewindow.png) i.e acutall application server name of the DataSource?.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06 at 10:40 PM

    Hi Hyder,

    I cannot think of any way to retrieve the value you are looking for. It would be nice if the Description of the Datasource could be retrieved, but it does not look like it.

    Dan

    Add comment
    10|10000 characters needed characters exceeded