Programmatic Access to BW for Visual Studio

[Former Member]

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

[TammyPowlas]

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

[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