Download - SAP MS BI[1]
-
8/8/2019 SAP MS BI[1]
1/18
Microsoft Business Intelligence
on SAP NetWeaver data
Stephan Stoltze
-
8/8/2019 SAP MS BI[1]
2/18
SAP BI Landscape
Requirement:Reporting and analysis on data held in SAPtransactional systems (e.g. mySAP ERP / R/3)
Multiple vendor solutions:SAP NetWeaver Business Intelligence
Microsoft SQL Server
Other BI vendor solutions:Business Objects
Cognos
-
8/8/2019 SAP MS BI[1]
3/18
SAP BI Choice
1. Choose the SAP solutionPros
Integrated with SAP mySAP / R/3
Who knows SAP data better than SAP?
Pre-defined business contentSingle vendor transaction processing and businessintelligence solution
ConsQuestionable performance and scalability
Difficult to integrate non-SAP data
Difficult to customize and extend business content
-
8/8/2019 SAP MS BI[1]
4/18
SAP BI Choice
2. Choose a Microsoft solutionPros
Leverage SAP BW business content and R/3 integration
Flexible free-form reporting on SAP BW
Enables integration of non-SAP data
Deployment using market leading OLAP server
Fexibility, through deployment options
ConsSome limitations in different scenarios (see solutionscenarios)
-
8/8/2019 SAP MS BI[1]
5/18
Open Hub
SQL 2005 Integration Services
Solution ArchitectureMicrosoft SQL Server 2005 BI solution
SAP R/3
SAP BW/Net-
Weaver
XML/A
RFC ADO.Net
Microsoft .Net Provider for SAP NetWeaver Business Intelligence
Microsoft .Net Provider for SAP mySAP Business Suite
SQL 2005Data Mart
SQL 2005AnalysisServices
SQL 2005Reporting Services
PerformancePoint Server
Office SharePoint Server
Excel
-
8/8/2019 SAP MS BI[1]
6/18
Solution Scenario 1
Overview:Reporting Services as a client tool for SAP BW, usingMicrosoft .Net Provider for SAP NetWeaver BusinessIntelligence
Issues addressed:SAP BW reporting
Uses SAP security (no additional layer)
Known issues:Provides support for InfoCubes, QueryCubes andMultiproviders only. ODS objects can be exposedthrough QueryCubes.
SAP BW/Net-
Weaver
XML/A SQL 2005Reporting Services
Embrace BW
-
8/8/2019 SAP MS BI[1]
7/18
Solution Scenario 1
-
8/8/2019 SAP MS BI[1]
8/18
Solution Scenario 1 Tips and Tricks
Test the SAP BW XML/A ProviderUse Internet Explorer to open the XML/A providersURL
Succes look like
-
8/8/2019 SAP MS BI[1]
9/18
Solution Scenario 1 Tips and Tricks
Enabling a QueryCube for XML/A AccessIn BEx Query Designer open the Query Propertiesdialog box and click the Extended tab
Select : Allow ExternalAccess to this Query
-
8/8/2019 SAP MS BI[1]
10/18
Solution Scenario 1 Tips and Tricks
VariablesOnly in QueryCubes
Similar to the parameter feature of Analysis Services
2005Populate Report Parameter Values by creating a newdataset
-
8/8/2019 SAP MS BI[1]
11/18
Solution Scenario 1 Tips and Tricks
PropertiesAdditional properties for key figures
VALUE (Default)
FORMATTED_VALUE
FORMAT_STRINGBACK_COLOR
FORE_COLOR
Additional properties for dimensionsMEMBER_CAPTION (Default)
MEMBER_UNIQUE_NAME
Syntax: Fields!FieldName.PropertyName
-
8/8/2019 SAP MS BI[1]
12/18
SQL 2005 Integration Services
Solution Scenario 2
Overview:Use SAP Open Hub Service (OHS) to extract data into SQLServer 2005, from where Analysis Services and ReportingServices are used for analysis and reporting
Issues addressed:SAP BW reporting (re-use of business content)Flexibility to incorporate non-SAP data sourcesMOLAP technology - better performance and scalability
Known issues:OHS does not support extraction of BW hierarchies; need to useABAP reportSAP security applied only at time of export; need to maintainsecurity in Analysis ServicesCustomer needs to purchase SAP OHS license
SAP BW/Net-
Weaver
SQL 2005Data Mart
SQL 2005Analysis
Services
OHS
Use BW but feed data into other EDW
Excel
SQL 2005Reporting Services
-
8/8/2019 SAP MS BI[1]
13/18
Solution scenario 2 - demo
-
8/8/2019 SAP MS BI[1]
14/18
Solution Scenario 3
Overview:Extraction of data directly from SAP R/3 using IntegrationServices and the Microsoft .Net Provider for SAP mySAPBusiness Suite into a SQL Server 2005 data mart, whereAnalysis Services and Reporting Services are used to deliver ananalysis and reporting solution
Issues addressed:Alternative solution to SAP BW (no SAP BW license required)
Flexibility to incorporate non-SAP data sources
More productive ETL / Cube development environment
Known issues:Direct access to SAP R/3 tables is not recommendedSAP do not support a non BW BI solution
No access to SAP BW business content
SAP security applied only at time of export; need to maintain
security in Analysis Services
SQL 2005 Integration Services
SAP R/3
RFC ADO.Net SQL 2005Data Mart
SQL 2005
AnalysisServices
Excel
SQL 2005Reporting Services
ETL data from transaction DB (SAP)
-
8/8/2019 SAP MS BI[1]
15/18
Solution scenario 3
Integration Services - Extraction, Transformation and Loading
-
8/8/2019 SAP MS BI[1]
16/18
Solution scenario 3
Analysis Services Unified Dimensional Model
-
8/8/2019 SAP MS BI[1]
17/18
Solution scenario 3
Reporting Services Enterprise Reporting
-
8/8/2019 SAP MS BI[1]
18/18
Solution Summary
Flexible deployment options based on customerrequirements
Any customer may implement all scenarios
Microsoft extends the SAP NetWeaver platformby followingGreater reporting flexibility and features
MOLAP technology - better performance and scalability
Multi-language support
More productive ETL / Cube development environment
Better integration with .Net development environment and otherMicrosoft products (e.g. SharePoint, PerformancePoint Server)