on 03-29-2006 12:53 AM
Are the BEx VBA API functions/subs no longer available in 2004s (ie, SAPBEXsetFilterValue)? If the functions are not supported, does anyone know if SAP is replacing them?
Kenneth
Hi,
what Ifound out so far is :
the new BI7 Queries in Excel BEX will not support the API that could be used in BW3.x.
The API is still available but for example the hidden sheets like Filters and queries are not existing anymore.
I severely used the API but presently there is no API ( at least I haven't found an API documentation describing how to filetr or navigate by help of macros.
For most customer it is essential to 'remote control' the functionality.
Hope that helps
Joerg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kenneth,
We have not changed any API in 2004s.
For API's and its definition kindly refer to the following link.
http://help.sap.com/saphelp_bw21c/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/frameset.htm
All the workbooks defined in 3.X are compatible in 2004s.
Should you require further info., let me know,
Kind Regards,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would like to point out that the <b>new 2004s BEXAnalyzer.xla does not support ALL of the functions from 3.5</b>.
I'm trying to determine what SAP is providing as an alternative solution. I understand that I can physically use the old 3.x analyzer, but I'm trying to get away from it.
Kenneth
The following is copied from BEXAnalyzer.XLA:
Public Function SAPBEXcopyFilterValue(fromCell As Range, Optional atCell As Range) As Integer
'Not supported in 7.0
extErrorBegin ("3.x API SAPBEXcopyFilterValue called - NOT SUPPORTED IN 7.0!")
SAPBEXcopyFilterValue = 700
p_extErrorText = "API not supported in 7.0"
End Function
Public Sub SAPBEXpauseOn()
'Not supported in 7.0
extErrorBegin ("3.x API SAPBEXpauseOn called - NOT SUPPORTED IN 7.0!")
p_extErrorText = "API not supported in 7.0"
End Sub
Public Sub SAPBEXpauseOff()
'Not supported in 7.0
extErrorBegin ("3.x API SAPBEXpauseOff called - NOT SUPPORTED IN 7.0!")
p_extErrorText = "API not supported in 7.0"
End Sub
Kenneth,
The VBA XLA file within the new BEx Analyzer in 2004s is completely unlocked. You can launch the Analyzer open the Visual Basic Editor and peruse through the various functions available.
Hope this helps.
Cheers,
Scott
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.