Loading data from SAP BW into Analysis Services
In this
whitepaper Hermann Däubler he exlplains step by step how to load data from SAP BW into Analysis Services cube using SAP's Open Hub Services. To me SAP BW always looked like something very complex that I didn't even know how to approach, so I was excited to see documentation which explained exactly that. Here is the summary of the whitepaper:
Summary
The following paper should help to get a quick start on how into an external Microsoft Analysis Services MOLAP cube Service. Unlike using SAP .NET Connector to access one necessary to write any code. Open Hub Service is the officially unload data from SAP BW into external data targets.
As an example, here are two screenshots of the hierarchy tree, first is the original hierarchy in BW and the second one - the migrated hierarchy in Analysis Manager.
