NetWeaver BI, Queryview, Web Service, C# |
 Unloading fact data from SAP BI 7.0 using the Queryview Web Service and C#
|
This paper describes how to unload fact data from SAP NetWeaver BI using C# and the “queryview” Web service. The paper contains a walk-through of how to use the queryview Web service within a C# console program in order to unload fact data from SAP NetWeaver BI without the need of any additional driver or library installation.
|
1/2009 |
SQL Server 2005/2008, BI |
Using SQL Server 2008 Integration Services with SAP BI 7.0 |
This white paper demonstrates the use of the Microsoft Connector 1.0 for SAP BI in Microsoft SQL Server 2008 Integration Services packages. It shows how to load data into SAP BI by using the SAP BI destination, how to extract data from SAP BI by using the SAP BI source, and how to prepare extracted data for analysis in SQL Server Analysis Services.
|
12/2008 |
SQL Server 2005/2008, BI |
Table Partitioning in SAP BI on Microsoft® SQL Server™ 2005/2008 |
SQL Server 2005/2008 supports range table partitioning which SAP BI can use to partition PSA and fact tables. The basic idea of table partitioning is to create separate physical parts but one logical view. This helps especially to maintain huge tables with many millions of rows. In SQL Server2005/2008 one table can have a max of 1000 partitions.
|
11/2008 |
NetWeaver BI Hierarchies, SAP BI 7.0 |
How to unload Hierarchies from SAP BI 7.0 |
This paper describes how to unload hierarchies from SAP NetWeaver BI 7.0. In SAP NetWeaver BI master data usually consists of attribute, text and hierarchy data. A simple example could be data about employees like name, age, title and so on in a SAP BI system. In addition one could store hierarchy information which describes the organization chart (who is a manager and who reports to whom?). The official interface in SAP NetWeaver BI to unload data is called Open Hub Service. It allows unloading master data of type “attribute” and “text” but has no option to unload hierarchy information. This raises the question how it could be accomplished to unload hierarchical information using other interfaces or mechanisms.
|
9/2008 |
BI, NetWeaver BW, XMLA |
Unloading Master Data from SAP BI 7.0 using XMLA and C# |
This paper describes how to unload data from SAP NetWeaver BI using C# and the SAP NetWeaver BI XMLA Web service. The paper contains a walk-through of how to use the XMLA Web service within a C# console program in order to unload master data from SAP NetWeaver BI without the need of any additional driver or library installation.
|
2/2008 |
BI, NetWeaver BW, SQL Server Integration Service |
Unloading Master Data from SAP BI 7.0 using Open Hub Service |
This paper describes how to use SAP Open Hub Service for unloading data from SAP NetWeaver BI for integrating with Microsoft Business Intelligence (Microsoft BI). The paper contains a detailed walk-through of how to configure SAP NetWeaver BI for unloading the master data and retrieving this data in Microsoft SQL Server by using SQL Server Integration Services (SSIS).
|
2/2008 |
BI, NetWeaver BW |
 Video: SQL Server Reporting Services and SAP BW - Video
|
Video that provides an example of integrating
SQL Server Reporting Services and SAP BW.
|
12/2006 |
BI, NetWeaver BW |
Video: Microsoft BI for SAP Data Warehousing Scenario |
Video that provides an example of integrating Microsoft BI with SAP BW. |
12/2006 |
BI, NetWeaver BW |
Video: How to Connect to SAP BW via the Microsoft .NET Data Provider |
Video: How to Connect to SAP BW via the Microsoft .NET Data Provider for NetWeaver BI and leverage the new query designer to quickly build a report. |
04/2006 |
BI, NetWeaver BW, Open Hub Services |
Loading Data from SAP BW into Microsoft Analysis Services Using Open Hub Service |
The following paper should help to get a quick start on how to load data from
SAP BW into an external Microsoft Analysis Services MOLAP cube using the BW Open Hub Service. Unlike
using the SAP Connector for .NET to access one of the BW APIs, its not necessary to write any code.
Open Hub Service is the officially recommended way to unload data from SAP BW into external data
targets. Whenever you extract data from a mySAP BI environment into 3rd-party target systems, your SAP
BW Enterprise Data Warehouse functions as an Open Hub Platform. Since extracting data from SAP BW by
any means requires additional licensing, please make sure to contact your SAP representative.
|
06/2005 |
NetWeaver BW, .NET |
Access to the SAP BW ODS BAPI using C# and SAP Connector for Microsoft .NET 2.0 |
The following paper will help to get a quick
start on how to access the ODS BAPI in SAP BW
using the new SAP .Net Connector 2.0. The main
focus is to demonstrate how easy it became to
call the BAPI functions as SAP .NET Connector
generates all the code which is necessary to
handle the RFC ( Remote Function Call ) part.
|
09/2004 |
NetWeaver BW, .NET |
Access to the SAP BW OLAP BAPI using C# and SAP Connector for Microsoft .NET 2.0 |
The following paper will help to get a quick
start on how to access the OLAP BAPI in SAP BW
using the new SAP .Net Connector 2.0. The main
focus is to demonstrate how easy it became to
call the BAPI functions as SAP .NET Connector
generates all the code which is necessary to
handle the RFC ( Remote Function Call ) part.
|
09/2004 |
