SAP documentation for working with BExRepositorySheet?

[Former Member]

Can someone point me to where I can find some documentation for programmatically working with the BExRepositorySheet, in particular reading from and writing to the embedded XML script within that sheet.

As I wrote in an earlier thread (), what I'm trying to do is re-program a very elaborate Excel VBA solution we built for BEx 3.5 to automate the processing of BEx reports by reading the stored variable values in the SAPBEXqueries sheet, but with that sheet gone in BEx 7.0 now, and all that meta-data being stored in BExRepositorySheet XML script instead, I need to be pointed in the right direction as to how to work with the BExRepositorySheet in BEx 7.0.

Thank you kindly for any information.

[matthias_gemmel · Accepted solution]

Hi Stephan,

as mentioned in the other thread. This XML is the metadata which is not intended to be changed. The way to manipulate the workbooks is to use the command API (same as BW ABAP Web API). This can be used via button items in BEx Analyzer. You may place the buttons to a hidden sheet and call the ButtonXY_Click function from your VBA code.

Regards

Matthias

[Former Member · Accepted solution]

Thanks again Matthias. Can you also point me to a few good resources on working with the BW ABAP Web API?

[matthias_gemmel · Accepted solution]

Hi Stephan,

please see link [http://wiki.sdn.sap.com/wiki/display/VC/WhatisWebAPI|http://wiki.sdn.sap.com/wiki/display/VC/WhatisWebAPI] that contains a reference to a 300+ pages PDF document describing the Web API commands. It is describing the ABAP Web Runtime for BW 3.5 which also exists in BW 7.0.

Best regards

Matthias

[marco_simon2]

Hi Stephan,

I'm looking for the same since some while but didn't succeed till today.

When I tried to maniplulate the BEx-Repository-sheet manually in the past, then this always lead to a corrupted workbook - even for minimal modifications.

So - good luck and please let me know if you found something helpful.