on 05-11-2009 3:51 PM
Hello,
we like to extend a workbook with VB code. That means users shouldn't use BEx menu bar to refresh the workbook. they should get a button in the workbook, which starts function SAPBExRefresh. The workbook is created with BI 7.10. If we execute workbook with BEx Analyzer BW 3.5, function refresh works fine and variable screen will open. If we execute workbook with BEx Analyzer BI 7.10, function "refresh" doesn't work correctly and no variable screen will open. Does someone know what the problem could be? Are there any selection to do in the query/workbook?
Many thanks for your help.
Regards
Friedrich
Hi Friedrich,
Function "refresh" doesn't work correctly in BI 7 version, instead you try with the "Change Variable" funtion, it works.
regards
Dev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry to be refreshing this old thread, but I am looking for a solution to the same problem.
Can I use SAPBEXrefresh procedure in 7.0? It doesn't seem to be doing anything, although it seems like this API is still supported - it says in the description of the SAPBEXrefresh function:
'In the 7.0 Analyzer, ALL the items in the workbook can be refreshed, but refreshing
'a query individually is not supported.
Is there any SAP documentation desciribing differences between 3.5 and 7.0 from the VBA angle?
Seems as if I managed to find a solution to my problem. It seems that the Refresh button doesn't call the variables box anymore in 7.0 , that's why it doesn't seem to be doing anything (it reuses saved variables, right?). Instead, one needs to use Change Variables to be able to get to the variables box.
So, in order to refresh all queries (with an option to enter variables) I used the following code:
Sub RunReportButton()
Dim ReturnCode As Integer
ReturnCode = Run("BExAnalyzer.xla!MenuRefreshVariables")
End Sub
In order to run the VBA in SAPBEXOnRefresh I had to change 2 things:
- In BEXInterfaceModule change the code to:
Public Function BEx() As Object
Set BEx = Application.Run("BExAnalyzer.xla!GetBEx", ThisWorkbook)
End Function
- second: go to TOOLS --> References anda check out the "SAP BEX Analyser API"
Your VBA code should work fine now.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.