THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Microsoft OLAP by Mosha Pasumansky

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.
 
Published Monday, June 13, 2005 11:07 PM by mosha
Anonymous comments are disabled
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement