Transcript Business Intelligence with the world’s most popular business productivity suite and most widely deployed information platform Empower Your People Improve Organizational Effectiveness Increase IT Efficiency Self-service access.

Business Intelligence with the world’s most popular business productivity suite and most widely
deployed information platform
4
Empower Your People
Improve Organizational
Effectiveness
Increase IT
Efficiency
Self-service access &
insight
Collaborative across
your value chain
Trusted, scalable &
secure
Familiar interface &
tools you own today
Alignment,
accountability &
ownership
IT management &
developer productivity
Get more out of products you already own
Business User Experience
Business Collaboration Platform
Information Platform
Familiar User Experience
Self-service Access and Insight
Data Exploration and Analysis
Predictive Analysis
Data Visualization
Contextual Visualization
Integrated Content and Collaboration
Thin Clients
Dashboards
BI Search
Content Management
Compositions
Information Platform
Analysis Services
Reporting Services
Integration Services
Master Data
Data Mining Services
Data Warehousing
Master and Meta Data reusability
Data Governance
Flexible Data Integration Scenarios
Integrate SAP Dimensions/hierarchies into local Reporting solutions
Integrate SAP facts/transactions into local Reporting solutions
Integrate non-SAP data and SAP data to form a Unified Dimensional Model
Integrate external data sources
Tight ntegration with Sharepoint and Office
-
Part of NetWeaver
- Comprises
Data Warehousing
BI Platform
BEx Suite
-
Approximately 1/3 of R/3 customers deployed BW
-
Previous Release: BW 3.5
- Current Release: BI 7.0
Source : SAP
Microsoft .Net Provider for SAP NetWeaver Business Intelligence
Sharepoint 2010 with BI tools
PowerPivot & Excel Services
SAP R/3
/
SAP mySAP
SAP BW
/
NW BI
Open Hub
XML/A
MS Connector 1.1
RFC  ADO.Net
SQL 2005/08 Integration Services
Microsoft .Net Provider for SAP mySAP Business Suite
SQL 2005 / 2008
Reporting Services
SQL 2005/08
Data Mart
SQL 2005/08
Analysis
Services
SAP BW
3.5 or 7
Embrace BW
XML/A
SQL 2005/2008
Reporting Services
- Both SQL Server Reporting Services 2005 and 2008 support query on SAP BW/BI “Query” objects
- We do not do table level access
- We access through the SAP XMLA interface to any InfoProvider exposed. This can be a
“Query” object, an InfoCube (of different types) or a Multi-Provider
New features in Reporting Services 2008 include:
New SAP connection string editor.
Support for single sign on.
Improved metadata load times.
Enhanced variable support.
Display Technical Names option: shows the SAP technical name of elements beside their friendly name. Toggled on/off by a button on the
toolbar.
Collections of cubes, dimensions and hierarchies are displayed sorted alphabetically for easy navigation.
Added support for cubes containing two SAP structures: the contents of each structure (key figures and characteristics) can be accessed
transparently.
Simplified SAP variable support: each report is now automatically parameterized according to any SAP variable available in the cube.
Prerequisites
The provider has been developed for and tested against SAP BW 3.0, 3.5 & SAP BI 7.
Support Package 20 for SAP BW 3.5
For Windows Integrated Authentication the provider was developed for and tested against the following systems:
SAP Portals 6.40 Support Package 20
SAP Portals 7.0 Support Package 11
SAP Duet 1.0
SQL 2005
Reporting Services
SAP BW
3.5
OHS
Use BW but feed data into other DM
SQL 2005 Integration Services
SQL 2005
Data Mart
SQL 2005
Analysis
Services
Download April 2009 SQL Server Feature Pack
Extract or load data into SAP BI 7.0 using Microsoft Connector 1.1 for SAP BI which consist of:
SAP BI Source—The SAP BI source is a data flow source component that lets you extract data from an SAP NetWeaver BI version 7 system.
SAP BI Destination—The SAP BI destination is a data flow destination component that lets you load data into an SAP NetWeaver BI version 7
system.
SAP BI Connection Manager—The SAP BI connection manager connects either an SAP BI source or SAP BI destination to an SAP NetWeaver BI
version 7 system.
Note: MS Connector for SAP BI uses Open Hub Services
SQL 2005
Reporting Services
SAP R/3
4.7
(running IDES)
ETL data from transaction DB (SAP)
RFC  ADO.Net
SQL 2005 Integration Services
SQL 2005
Data Mart
SQL 2005
Analysis
Services
Language: English only
Includes adapters for:
• SAP
• Siebel
• Oracle Database
Includes ADO.NET providers for:
• SAP
• Siebel
http://www.microsoft.com/biztalk/evaluation/adapter/default.mspx
Available for Integration Scenarios:
a. Microsoft Office SharePoint Server 2007
b. SQL Server Integration Services 2005,
2008
c. BizTalk Server 2006 R2
d. Stand Alone SKU available
DimProductHierarchy
Solution notes:
Classic star-schema.
All Type1 SCDs.
Initial load only.
Some complexity
removed.
DimMaterial
DimUnitofMeasure
DimSalesOrgHierarchy
DimSalesOrg
DimCustomer
DimSalesOffice
FactSalesOrderLine
PK order_number
FactScheduleLine
PK order_line
DimCurrency
PK order_number
FactDeliveryLine
PK order_line
PK order_number
PK FactBillingLine
order_line
PK
PK
DimCustomerGroup
DimSalesPerson
billing_document_ID
billing_item_ID
DimSalesGroup
DimPlant
DimDivision
DimDistributionChannel
*List above notes only example primary extract tables, many other text tables are used in each mapping to resolve IDs, lookup texts and construct meaningful
hierarchies
• Add 15 attributes to product xrb019
• Information workers can’t edit dimensions
ERP - USA
Warehouse or
analytic app
• Which is the real XYZ Corp?
• Resolve XYZ Corp’s address
• Does product xrb019 = fft019?
Operational MDM – Difficulty coordinating multiple systems
Analytic MDM – Difficulty managing dimensions
SQL Server MDS – solving for both
ERP - Europe
Master Data Hub
Master Data Platform
Stewardship Portal
Stewardship Process
Hierarchy and attribute
management
API support for all
operations
Master data
maintenance
Workflow
Versioning
Transaction logging
Data quality and
cleansing
Master Data
Any domain
Hub
Security
Model deployment
Master Data
Platform
ModelingStewardship
Portal
Model documentation
Import and export
Stewardship
Process
Notifications
Business rules
Validation
- SQL Server Reporting Services feeds SAP data to PowerPivot thereby
enabling Self Service BI
- Use of Open Hub
- Excel as a source for PowerPivot
- Ease of use for the business user to manipulate SAP data
- Metadata, column names etc already setup in report; business user can
simply consume and analyse
Connect to Sources, Design and author
Browser
View and Interact
Excel
Connect to data, Analyze & Report
High quality web rendering
Zero-footprint
Interactive: Set parameters,
sort, filter, explore
S a v e y o u r Wo r k b o o k
Excel
Export/Snapshot into Excel
Open in Excel for rich exploration and analysis
Open snapshots
Spreadsheet calculation and rendering
External data retrieval and caching
100% calculation fidelity
100% IT monitor
applications
Programmatic Access
Set values, perform calculations, get updated values via
web services
Use any Reporting & Analytic solution against the “Cube”
Align systems
Reduce Process
Cost
Eliminate Expense
of bad data
• Master Data Hub – authoritative source
• Stewardship UI -- enables people to contribute
• API – enables systems to contribute and consume
• Workflows and business rules – ensure the data is right
• Hierarchy and Attribute management
http://www.theobald-software.com/cms/en/haupt/produkte-l-sungen.html
http://www.everyangle.nl
http://www.erplink.com/index.asp
http://www.sitrion.com/
http://www.simba.com/sql-to-mdx.htm
http://www.winshuttle.com/index.html
http://www.simplement.us/public/default.aspx
http://www.syskoplan.com/syskonet/index.php?StoryID=137
Integrate your SAP BW system with SQL server. With a few clicks of the mouse, you can
extract and load mass data, extraction of hierarchies, BW cubes, tables, BAPI, reports….
A key advantage of ERP-Link’s iNET.BI for SAP connector, is that
it facilitates the loading and processing of an Analysis Services
cube directly from SAP R3, BW ODS and InfoCube structures,
without having to persist data in intermediate relational
repositories
Usable SAP Objects
SAP R/3 Query Objects
SAP R/3 Report Objects
SAP R/3 BAPIs/RFCs
SAP R/3 Table Views
BW ODS Queries
BW Info Cubes
BW Cube Queries
BW ODS Table Views
SAP BW – PS CPM. Phase 1 rollout to
Commercial Marine for Capital Projects,
solution feeds BW PS data to MS
Performance Point Server and accessed by
users via SharePoint Portal Server, eventually
to be rolled out across multiple business
divisions to 6,000+ users.
SQL 2005 RS
Local BEx
SAP R/3
4.7c
3TB current
3-5TB endstate
E
T
L
SAP BW
3.5
x6 MSO BW instances
10-15TB each
Country clusters (geo)
SAP BW
3.5
PPS 2007
S
Q
L
IS
SQL Data
Mart
Sales
Cube
HP DL585
Win 2K3 Svr
SQL 2005
Mart: 2TB endstate
Cube:<1TB endstate
Customer Reference
Large Anglo Dutch Consumer Co.
Project: Sales Analysis
Requirement:
Flexible, functional OLAP solution without SAP upgrade
High degree of integration with MS Office & Sharepoint
Scenario:
Implement SAP BW as ODS
Extract from BW into SSAS using Open Hub
SQL Server Reporting Services and PerformancePoint Services
SAP Details:
SAP R/3 4.7
SAP BW 3.5
600 GB SSAS Data Model from 6 SAP sources of 100 GB
Other MS – SAP integration References
Linklaters (UK)
http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000000171
Bouygues Construction (France)
http://www.microsoft.com/France/Temoignages/Fiche-Temoignage.aspx?EID=6f7a928e-d2a8-465c-9991-44ae8b294b4b
Energizer (US)
http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000000706
Raymond James (US)
http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000004239
Northumbria University (US) http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000004670
Microsoft | SAP Alliance BI interop
http://msdn.microsoft.com/en-us/library/dd299430.aspx
http://msdn.microsoft.com/en-us/library/cc974473.aspx
http://msdn.microsoft.com/en-us/library/dd300592.aspx
http://www.microsoft.com/learning/en/us/Books/12513.aspx
www.microsoft.com/mdm
http://sqlblog.com/blogs/mds_team/
http://social.msdn.microsoft.com/Forums/en-US/category/mdm