Skip to Content
author's profile photo Former Member
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

0 Answers