SAPBEXSetVariables not refreshing BEx query data

[former_member199935]

Hi,

I’m trying to refresh BEx workbook via VBA with following code. When I execute below code in VBA, I can see “processing” message at the bottom of status screen in excel but data is not getting updated.

Run "BExAnalyzer.xla!SAPBEXsetVariables", Sheets("Sheet1").Range("VarRange")
Set shtRefresh = ThisWorkbook.Worksheets("Sheet1")
strVBA = Run("BExAnalyzer.xla!SAPBEXrefresh", False, Sheets(shtRefresh.Name).Range("$A$2"))

Cell A2 is part of DataProvider table design item. Varibales are set in VarRange as shown below.

(Please note that VarRange has needed information to populate mandatory variables as I verified that data is properly getting refreshed when I insert design item with parameters as shown below that also uses VarRange.

Only issue is above VBA code is running successfully but not updating data. We are on BW 7.4 HEC SP11 (BEx SP 5 Patch 1). Appreciate any help.

[Former Member]

Try this.

VAR_NAME_1 0 Var technical name

VAR_VALUE_EXT_1 0 Var value name

VAR_NODE_IOBJNM_1 0 Info object name => only if its hierarchy variable