Programmatic Access to BW for Visual Studio
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?