Skip to Content

SAPBEXSetVariables not refreshing BEx query data


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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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

    Add comment
    10|10000 characters needed characters exceeded