Skip to Content
avatar image
Former Member

Calling Business Objects 4.1 from Excel VBA

I'm not sure if any of you do this. We currently have Excel VBA that calls Deski reports, opens them, passes in variables, refreshes, and downloads the data into Excel.

There are many valid reasons for my users to do this, and they need to continue with this process once we move to 4.1 But Deski will no longer be there so we need to come up with a new way to do this. I could code just about everything except for the part that asks the user to save or open the file.

How can I get around this? Is there something I might be missing? They need to run their process on demand so scheduling a report won't work for us.

Thanks so much for any help you might be able to provide.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 22, 2015 at 06:36 PM

    Hi Anna,

    Official SDK for Web Intelligence in 4.x is REST Web Services. Using them, you can write some code that can be called and process the workflow you described.

    http://service.sap.com/~sapidb/012002523100011674692015E/sbo41sp6_webi_restws_dg_en.zip

    Another option is to use SAP Live Office, where your users can directly import Web Intelligence report element's data in the spreadsheet.

    Regards

    ~~cas

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 06:58 PM

    I do not know that much VBA and I've never used it, but I think that it is possible to call REST WS from VBA.

    If yes, then the REST WS can be used to connect to the SAP BI platform, get the WID, refresh it (and answer prompts).

    Then perhaps the tricky point might be to programmatically get the data from the report and properly parse it in order to fill the spreadsheet.

    ~~cas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yeah, the tricky part is definitely getting the data out of the report.

      I'm trying the LiveOffice route right now, but I'm not sure if I'll be able to code the authentication part.

      I know I can make HTTP calls from VBA, and I'm able to code just about everything until I get to the part where I need to save the data. The save or open dialogue is very difficult to get around, for security purposes I'm sure.

      Thank you both, I will update if I ever get this figured out.