Skip to Content
0
Former Member
Jan 14, 2008 at 12:40 PM

How to use Bex API in 7.0?

204 Views

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