Skip to Content

SAPBEXSetVariables not refreshing BEx query data

Nov 09, 2016 at 07:48 AM


avatar image
Former Member


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.

design-item.png (8.7 kB)
variables.png (12.7 kB)
design-item.png (8.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jun 21, 2017 at 02:06 PM

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

10 |10000 characters needed characters left characters exceeded