Skip to Content
avatar image
Former Member

SAP Bex Query Refresh Automation (SAPExecuteCommand)

Hi I'm pretty much new to VB world and I'm to automate reports from SAP Bex Analyzer.

I came up with following codes and when I run the following it gives me the error message of Run-time error '1004' saying the macro may not be available in this workbook or all macros may be disabled.

Sub Refreshdata()

Dim Refresh

Dim Filtering


Refresh = Application.Run("SAPExecuteCommand", "RefreshData", "BP_1")
Filtering = Application.Run("SAPSetVariable", "0PROFIT_CTR", "100012000", "INPUT_STRING", "BP_1")
End Sub

I have SAP Bex Analyzer excel add-in installed and ran a query with one report, just want to make a code that filters different variables (periods) within the same report.

I want to learn more about Bex analyzer and if there is any documentation that may be helpful, please share!!

Thanks,

Ryan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers