Hello,
For overview reasons it is necessary to create a workbook that holds all important data in a wanted format.
- For the queries are not shown in that format in BexAnalyzer I wanted to get all needed queries and then put them into one excel sheet. ( Bex 3.x: SAPBEXembedQuery )
- If those queries do already exist in excel I just need to refresh them. ( Bex 3.x: SAPBEXrefresh )
- After that I would derive the wanted data by using VBA functionality and put it into the fields with the right formatting.
However, the function SAPBEXembedQuery is not supported anymore in Bex 7.0.
- Are there other possibilities under 7.0?
- Or can anybody give input on whether there is a new API that does support BEx 7.0?
- Where can I find documentation on VBA programming in BI 7.0?
Thank you very much for any answer that is given.
Cheers,
Thomas