Skip to Content
avatar image
Former Member

Programmatic Access to BW for Visual Studio

Hi,

I've recently started using SAP Analysis for Excel at work and I really like all the report I am able to create. I would like to take these reports one step further and rather than creating Excel reports, I would like to programmatically access the data source through Visual Studio and retrieve the necessary data for one of the applications I have already written.

Is this possible? What API or .DLL is required to access the data source directly? Are web services an option if an API is unavailable?

Thanks,

Alex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 08, 2015 at 10:20 PM

    Hi Alex - I haven't done this myself, but SAP's David Stocker has a series of blogs on Visual Studio with Analysis Office - please see his content @David Stocker

    Roll Your own Analysis Office Features (Part III) - When, where and why you would use VBA or VSTO

    Roll Your own Analysis Office Features (Part IV) - Building Your First VSTO Based App (1 of 2)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Tammy!

      I suppose that is a good start and I could make the Excel window hidden and just read data from the cells once it is refreshed, but I was really hoping for a method that completely bypasses Excel and just connects to the data source directly. I have a standard Windows Forms application where I want to display results from querying the SAP BW source.

      -Alex