on 07-02-2015 1:18 PM
Hello, gurus.
We decided to move our workbooks from 3,5 version to 7.x version. At last. And we have faced with whole bunch of problems.
So, we have to change a lot of VBA programs. In these programs there are many calls of functions from SapBEX.xla like this:
Run "SAPBEX.XLA!SAPBEXcopyFILTERVALUE", filter_val_year, filter_tgt_year
So, as I know, I can't use such constructions in 7.0 version. Is there is any information about relations between old functions and new ones? Is it possible to understand how to translate it to new version? Even if it is possible at all. I'm speaking not only about SAPBEXcopyFILTERVALUE but many other functions.
The next issue in following constructions:
Set filter_val_year = Range("SAPBEXqueries!" & "SAPBEXq0025" & "f0FISCYEAR")
I cant find any names collection in application in 7.x version, I mean application.names is null. So I can't use this construction any more. Is it possible to calculate ranges of filters and variables in new workbooks?
Another issue is quantity of queries in our workbook. So is it possible to find somewhere table/worksheet/something else with information about properties of data providers and other elements (and their location in WB too) of workbook?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Michael,
The properties of the workbook is not possible. The properties are saved internally on XLS* file format on BW Repository.
But, some few information can be get it from tables * like workbook names, IDs, last change, Queries assigned and so on...
I use this space to refer the BW tables (generally I use for queries):
http://wiki.scn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BW+7.x
* for wbs, are just these 5 tables:
RSRWBINDEX List of binary large objects (Excel workbooks)
RSRWBINDEXT Titles of binary objects (Excel workbooks)
RSRWBSTORE Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE Assignment of Excel workbooks as personal templates
RSRWORKBOOK Where-used list for reports in workbooks
Best Regards,
Edward John
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.