Presentation Transcript
SAP Business Intelligence Overview :
Product Management BI, SAP AG SAP Business
IntelligenceOverview
Agenda :
Agenda Positioning / Value Proposition Data Warehousing -
ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap
SAP BI – The Solution at a Glance :
SAP Business Intelligence is an enterprise-class, complete,
open and integrated solution that delivers actionable insights. SAP BI – The
Solution at a Glance Data acquisition, data warehousing, OLAP, planning
framework, BI tools, dashboards and analytical applications; with
pre-configured content using best-practice models. Open, well documented APIs
and interfaces along with full functionality to integrate structured and
unstructured, heterogeneous data Scalable and reliable BI solution that is
tightly integrated with SAP NetWeaver, source transactional systems and
partner’s complementary tools Support decision-making requirements of the
entire enterprise regardless of data sources of access methods Convert data
into information, and ensure information is delivered at the right time to the
right person in the right format to support business decision making.
Pain Points, Customers without a BI Solution :
Pain Points, Customers without a BI Solution No central
access: Data relelavnt for decision-making are spread in different systems
across the IT landscape. Analyses are time consuming and not always consistent.
Time Consuming: Often, decision makers have to spend too much time on finding
relevant, timely information before they can even analyze it. Bad Performance:
The response time of complex analyses in operational systems is often not
acceptable. Complexity / IT-Dependency: Transactional systems often require
additional programming efforts to retrieve relevant information. Employees without
programming know-how are not able to run ad-hoc analyses. Missing business
process support: Exceptions are not alerted to those who should know.
The Value of SAP BI :
The Value of SAP BI Completeness: End-to-end BI solution
incorporating data warehousing, OLAP, data mining, business intelligence tools
and pre-defined business content. Openness: Allows to incorporate data from
heterogeneous systems. Supports industry standards such as XML for Analysis or
ODBO for reporting and analysis. Performance/Scalability: A proven solution
with that generated and loaded a 5.5 Tb data warehouse. Business Orientation:
Integrates business processes. Provides a centralized metadata repository with
a consistent business semantic. Ready-to go templates and best-practices –
horizontal and vertical business content. Actionable Information: Supports
decision-making requirements of every user.
SAP BI – Key Capabilities :
SAP BI – Key Capabilities Data Warehousing (SAP BW
Administrator Workbench) Extraction, transformation, and loading Data warehouse
management Business modeling BI Platform Online analytical processing (OLAP)
Data Mining Alerting Meta Data Repository Planning Framework BI Suite of Tools
(SAP BW Business Explorer) Query Design Managed Reporting and Analysis
Visualization – Web Application Design Collaboration Pre-configured Business
Content
Key Areas addressed with SAP BI :
Key Areas addressed with SAP BI Openness Open Hub Service –
dissemination of information UD Connect – directly access data to relational
database tables and OLAP systems Support of industry standards (e.g. XML, XML
for Analysis, JDBC etc.) Integration Integration of technology, tools and
applications allowing cross-enterprise analytics and closed-loop scenarios
Integration into the Enterprise Portal as single point of entry Integration of
unstructured information such as documents, files, etc. Web Offering
Interactive analysis of information via web and mobile devices Intuitive design
of web applications Ad-hoc query design via the web
SAP Business Intelligence :
SAP Business Intelligence Sources Data Warehousing BI
Platform BI Suite Data Acquisition Access Open Interface a. Web Services Data
Presentation User SAP Business Intelligence integrates all your corporate
information so you can turn information into insight, insight into action, and
action into improved business operations.
SAP BI Architecture :
SAP BI Architecture
Agenda :
Agenda Positioning / Value Proposition Data Warehousing -
ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap
Extraction, Transformation and Loading :
Extraction, Transformation and Loading …to get a complete
view of your business Open for any source Flexible set of ETL capabilities
Integration on application level Open to third-party tools Support of open
standards
Operational Data Store and Data Warehouse layer :
Operational Data Store and Data Warehouse layer Data
Warehouse Non volatile Granular Integrated Historical foundation Built with ODS
Objects Operational Data Store Operational Reporting Near Real-Time / Volatile
Granular Built with ODS Objects Multidimensional Models Multidimensional
analysis Aggregated view Integrated Built with InfoCubes ... to provide the
right information for all users
SAP‘s Data Aquisition Strategy :
E-Business Applications ^ Legacy Systems VSAM ADABAS SAP R/2
Non SAP BW Service API for SAP SAPComponents DB Connect/Flat File SAP‘s Data
Aquisition Strategy PeopleSoft Oracle DataStage ETL Components
Transformation within BW data flow :
Transformation within BW data flow Condition Handling Date
Conversion Currency Conversion Concatenation ...
Transformation Library – List of Functions :
Other functions: Skip record Abort package Check initial
value User-defined functions, that can also be re-used in other transformation
rules setup via BAdI (Business Add-In), e.g. to integrate self- defined
function modules Transformation Library – List of Functions Mathematical
functions: add, sub, mul, div, () CEIL / FLOOR ROUND, TRUNC EXP, FRAC ABS, SIGN
SQRT LOG / LOG10 DIV / MOD trigonometric functions exponents String functions:
substring concatenate to upper case shift left / right condense (no gaps) trim
left / right strlen replace left / right Logical operators: =, <>, >,
>=, <=, IF, AND, OR, NOT Date conversion: week_first_day (computes date
(Monday) of cal. week) date_conv (converts external date format into internal
format) date_diff (days between two dates) add_to_date (adds days to date)
date_weekday (computes weekday from date) date_week (computes week from date)
date_month (computes month from date) date_quarter (computes quarter from date)
date_year (computes year from date) date_fiscyear (computes fiscal year from
date) week_quarter (computes quarter from week) week_month (computes month from
week) month_quarter (computes quarter from month) month_year (computes year
from month)
BW Process Chains :
BW Process Chains Automating the BW administration Graphical
modelling and monitoring End-to-end monitoring Openness for all kinds of processes
Scheduling
Open Hub Service - Details :
Controlled distribution of consistent data Target: file or
DB table Central monitoring Select filter criteria and columns Scheduling Full
or delta mode ODS Objects Open Hub Service - Details
Agenda :
Agenda Positioning / Value Proposition Data Warehousing -
ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap
SAP BI Key Components :
SAP BI Key Components Data Acquisition Common Read / Write
Interface Open Interface and Web Services USER Interaction Access Business
Logic Presentation Data Warehousing BI Platform BI Suite Summarized,
Dimensional Data BI Services BI Suite Granular, Volatile Data ODS Master Data
Drill-Down, Drill-Through, Drill-Across Pivoting What If Slice and Dice Gallery
of ready-to-use Web Templates / Items Table, Chart Map Alert Monitor Context
Menu Business Calculations Planning and Forecasts Exception Scanning Alerting
Query Pre-Calculation Caching Background Printing Data Mining
OLAP Business Scenarios :
OLAP Business Scenarios Examples for OLAP Business Scenarios
Creation of complex formulas, down to cell level Usage of conditions and
exceptions in reports Multi-currency handling Flexible hierarchy analysis
Non-cumulative key figures to analyze data from inventory management data
Elimination of internal business volume Market share analysis Slow moving items
. . .
Metadata :
Metadata Central Metadata Repository Central display of
Metadata Objects Graphical view HTML based Download capabilities XML Metadata
exchangge
Data Mining :
Data Mining Data Mining Methods in SAP BW Classification
Decision Tree Clustering Clustering Association Analysis Approximation Scoring
Further Analyses ABC Classification Data Mining Definition Analytical approach
that look for hidden data patterns and relationships in large databases
Provides insights by analyzing past data and predicts future trends and
behaviours Enables prospective decision-making as opposed to pure retrospective
analysis
Analysis Process Designer :
Analysis Process Designer Analysis Process Designer (APD)
Scenario Data (available through all SAP BW storage media) can be explored
within a multilevel process, applying advanced analytical methods in order to
gain new insights from these data. The analytical results are persisted again
within SAP BW. Examples ABC-classification (e.g. customer/vendor) Determination
of the frequency distribution in datasets Development of Scoring information …
Feature Description Interactive modeling (drag&drop) workbench for analysis
processes Infrastructure to link up process elements, being sources (selection
of data), targets (deployment of results), pre-processing (transformation) and
visualization tools as well as data analysis methods. Analysis of data at every
step of the analysis process
SAP BI – Planning & Simulation: BW-BPS :
SAP BI – Planning & Simulation: BW-BPS Business Planning
& Simulation in SAP BW Planning & Simulation Scenarios Research /
Prognosis Estimating future situations and evaluating their impact on the
enterprise Target Setting Setting goals and milestones Budgeting Evaluating and
allocating resources for the achievement of targets Examples Sales Plan,
Resource Plan, Cost Center Plan, Profitability Planning Benefits of offering
BW-BPS with SAP BW No installation of SAP SEM Add-On necessary for usage of
planning functionality One software installation only One support package cycle
One project budget for planning and analysis
Business Planning & Simulation: Features :
Business Planning & Simulation: Features Planning and
analysis user interfaces Planning in Excel Planning in Web Interface Document
management Analysis in Business Explorer (Excel and Web) Planning Framework
MultidimensionalBusiness Structures Definition of work packages Hierarchy maintenance
Version concept User authorizations Variables maintenance Planning functions
Copy/delete Revaluate Top-down distribution Bottom-up aggregation Trend
analysis What-if-analysis Simulation Planning sequences Automatic execution of
planning functions Control and distribution of data Status and Tracking Monitor
Retractors for distribution of data to operational systems Background
processing of planning functions Modeling of Planning structures Automatic
Planning Manual Planning ProcessControl
Agenda :
Agenda Positioning / Value Proposition Data Warehousing -
ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap
BEx Overview Agenda :
BEx Overview Agenda BI End User Requirements Business
Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web
& BEx Analyzer BEx Information Broadcasting Conclusion
BEx Overview Agenda :
BEx Overview Agenda BI End User Requirements Business
Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web
& BEx Analyzer BEx Information Broadcasting Conclusion
SAP BI Delivers a Comprehensive Solution :
SAP BI Delivers a Comprehensive Solution Authors and
analysts Need advanced analysis functionality and ad-hoc data exploration
capabilities Require useful, manageable tools Executives and knowledge workers
Require personalized information in context via an intuitive user interface
Want predefined analysis paths and the option of in-depth analysis of summary
data Information consumers Need a snapshot of a particular data set to perform
their operational tasks Do not interact extensively with the data.
SAP BI User Categories :
Information Consumption, Portal-based Deployment, and
Executive Reporting 60 % OLAP Analysis and Power Reporting 30 % Authoring and
Ad-hoc Query 10 % SAP BI User Categories Analytical functionality and
flexibility Required training investment and cost High High Low Low
The Business Explorer: SAP‘s BI Suite :
The Business Explorer: SAP‘s BI Suite
BEx Overview Agenda :
BEx Overview Agenda BI End User Requirements Business
Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web
& BEx Analyzer BEx Information Broadcasting Conclusion
BEx Query, Analysis & Reporting :
BEx Query, Analysis & Reporting Key Capabilities
Unlimited Web and Mobile access via Automatic Device Recognition The system
allows access to BI data from any Web Browser or Mobile device Alert framework The system can
push BI alerts to end-users via SMS, e-mail and Portal Apps. Data
Precalculation for Online and Offline Scenarios Allows to pre-calculate SAP BW
data to have it available immediately if needed without having to go through
the OLAP Business Content Broad range of extendable dataproviders and queries
provided 1:n Personalization allows for one query to serve multiple users Open
Analysis Framework Supporting standards like XML/A and OLE DB for OLAP
BEx Query, Analysis & Reporting :
BEx Query, Analysis & Reporting BEx Query Designer
Ease-of use via drag & drop Personalized access Comfortable formula editor
for calculations access to any BW Data Provider Windows-based component Web
interface for intuitive ad-hoc design & analysis
BEx Query, Analysis & Reporting :
BEx Query, Analysis & Reporting Analysis Capabilities
Analyze different aspects of the business Multi-dimensional views Generic
navigation and interaction (slice and dice, drill-down, drill-thru, pivoting,
...) Hierarchy navigation Time dependency Currency conversion (e.g. different
per column) Versioning, Aggregation rules Global, enterprise-wide use
Multi-language, multi-currency Intelligent Services Alerting to identify and
handle exceptions, Pro-active notification Conditions Data Mining OLAP cache
Multi-user cache for BW queries for enhanced performance
Analysis Process Designer :
Analysis Process Designer (APD) Scenario Data (available
through all SAP BW storage media) can be explored within a multilevel process,
applying advanced analytical methods in order to gain new insights from these
data. The analytical results are persisted again within SAP BW. Examples
ABC-classification (e.g. customer/vendor) Determination of the frequency
distribution in datasets Development of Scoring information … Feature
Description Interactive modeling (drag&drop) workbench for analysis
processes Infrastructure to link up process elements, being sources (selection
of data), targets (deployment of results), pre-processing (transformation) and
visualization tools as well as data analysis methods. Analysis of data at every
step of the analysis process
BEx Query, Analysis & Reporting :
BEx Query, Analysis & Reporting Reporting Capabilities
Tabular Reporting Query with diverse columns in free alignment No distinction
between characteristics and key figures Option to switch between tabular and
OLAP view Foundation for formatted reporting with Crystal Reports Desktop or
web Analyze data from different sources SAP or non-SAP Extendable reporting
templates provided with Business Content
BEx Query, Analysis & Reporting Integration with Crystal Reports :
BEx Query, Analysis & Reporting Integration with Crystal
Reports Out of the box presentation-quality reporting Reports and documents
optimized for printing and sharing Broad range of pre-defined Crystal reports:
legal, financial, etc SAP BW and non-SAP BW data in a single report Seamless
portal integration Schedule and view Crystal reports in managed web environment
Offline reporting and viewing of reports
BEx Overview Agenda :
BEx Overview Agenda BI End User Requirements Business
Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web
& BEx Analyzer BEx Information Broadcasting Conclusion
BEx Web: Key Capabilities :
BEx Web: Key Capabilities Provide and analyze information
via a Web Browser (PC or mobile) Ease-of use Zero Footprint Quick ROI Packaged
BI web applications and predefined BI Patterns Alerting Pro-active notification
Analytical complexity when needed Full interactivity or guided navigation
depending on end-user requirements Filter Drill-down Slice and dice flat lists
etc. BEx Web Analyzer for Power Users Performance HTML Compression
Precalculated or cached data optional usage of the Portal cache
BEx Web: Design of BI Web Applications :
BEx Web: Design of BI Web Applications BEx Web Application
Designer Offers the ability to create a wide range of easy to use Web Apps
Direct access via Web & Mobile devices Build intuitive & custom BW Web
Applications Cockpits / Dashboards DropDowns, Radio Buttons Tickers Charts
& Maps Guided Navigation Device specific output generation Portal
integration APIs for further web design
BEx Web Application Example :
BEx Web Application Example Example: Analyze Sales vs.
Market Potential in the States of the US
BEx Web Application Example :
BEx Web Application Example
BEx Web: BI Patterns for Quick ROI :
BW Business Content will be based on consistent UI Patterns
(starting November 2004) Pattern 1 (“Casual User”) Pattern 2 (“Information
Consumer”) Pattern 3 (“Knowledge Worker”) Pattern 4 (“Analyst”) BEx Web: BI
Patterns for Quick ROI low high BI knowledge
Information Consumer Pattern (all features) :
Information Consumer Pattern (all features)
BEx Web Application Framework :
InfoProvider BEx Web Application Framework Web Design Tool
(optional) OLAP Processor BEx Web Application Designer BEx Query Designer BW
Server with SAP Web AS Web Service Charting Engine Web Browser HTML Templates
BEx Analyzer :
BEx Analyzer Share and analyze information via a Windows
Desktop using MS Excel Queries & Solution Workbooks embedded in MS Excel
Wide Range of delivered content Additional MS Excel Functionality
(Calculations, Charts etc.) VBA Programming Workbook Precalculation Seamless
integration of Query Designer Seamless integration between BEx Web & BEx
Analyzer
BEx Overview Agenda :
BEx Overview Agenda BI End User Requirements Business
Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web
& BEx Analyzer BEx Information Broadcasting Conclusion
BEx Information Broadcasting (1) :
BEx Information Broadcasting (1) Information Broadcasting
allows the distribution of BI information ... via different channels ... )
E-Mailü(
) Enterprise Portalü(
... in different formats ... ) HTML, MHTMLü( ) BEx Analyzer Workbooksü( )
ZIP Filesü(
… of different sources … ) BI Web Applications - Dashboards, cockpitsü( )
BEx Analyzer Workbooksü( ) Queriesü( … in different modes… ) Onlineü( & pre-calculated
BEx Information Broadcasting (2) :
BEx Information Broadcasting (2) Information Broadcasting
supports different business scenarios ) Event based (“Intelligent push”)ü(
Integration into process chains E.g. If new data is loaded into the data
container (InfoCube) ) Ad hocü( BEx Broadcasting Wizard for one-step distribution )
Scheduledü(
BEx Broadcaster Guided scheduling times (for end users / information consumers)
Scheduling at any time (for power users / administrators)
Slide 52:
User-Type Specific Information Broadcasting
Information Broadcasting – BEx Portfolio :
Information Broadcasting – BEx Portfolio Queries, Workbooks,
BI Applications as KM Documents KM Document: Pre-calculated query, workbook or
application KM Link: Online BW report Use KM Services for: Subscription
Feedback Discussion Collaboration Rating TREX search Notes Download
Information Broadcasting & Collaboration Rooms :
Information Broadcasting & Collaboration Rooms Queries,
Web Applications & Workbooks can be broadcasted into Collaboration Rooms
Collaboration Rooms Services Chat Application Sharing Notes Meeting Pad
Discussion Forums Instant Messaging My Portal Contacts
The Broadcaster Wizard :
The Broadcaster Wizard The BEx Broadcaster Wizard can be
conveniently launched from the context menu
BEx Overview Agenda :
BEx Overview Agenda BI End User Requirements Business
Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web
& BEx Analyzer BEx Information Broadcasting Conclusion
SAP BI Delivers a Comprehensive Solution :
SAP BI Delivers a Comprehensive Solution Authors and
analysts Need advanced analysis functionality and ad-hoc data exploration
capabilities Require useful, manageable tools Executives and knowledge workers
Require personalized information in context via an intuitive user interface
Want predefined analysis paths and the option of in-depth analysis of summary
data Information consumers Need a snapshot of a particular data set to perform
their operational tasks Do not interact extensively with the data. Executives
and Knowledge Workers: BEx delivers.. Easy to use web applications with eg.
push buttons, drop downs, interactive charts Role based and personalizable
access from any web browser and mobile device Pro-active alerting with
extensive drilldown capabilities Authors and analysts: BEx delivers.. Windows
and Web based Query & AdHoc Query Design Intuitive design tool for
Dashboards Intuitive Distribution & Broadcasting channels Powerful OLAP
capabilities and seamless Integration into MS Excel Information Consumers: BEx
delivers.. Pattern based Business Content (e.g. for casual users, information
consumers…) flat reports and/or guided navigation Integrated KM services
Business Explorer – Users, Needs and Functions :
Business Explorer – Users, Needs and Functions Query,
Analysis & Reporting BEx Web & BEx Analyzer EP Integration &
Information Broadcasting Knowledge Worker Analyst / Author Information Consumer
Query Design Ad hoc Query Design OLAP Analysis Web Application Design / VB
macros Web Application Publishing Static and / or Guided Navigation BEx
Analyzer / BEx Web Analyzer / Web Queries Solution Workbooks Web Applications /
Dashboards BEx Broadcaster BI iViews BEx Broadcaster Wizard BEx Portfolio
Pro-Active Alerts
Download Scheduler for Offline Reporting :
Download Scheduler for Offline Reporting Scheduled or
immediate Download Web Templates, Excel Sheets Excel Sheets Web Templates Web
Templates (optimized for PDAs)
Information Deployment :
Information Deployment Personalized information and decision
support for all users Share and analyze business information Analytics in
context Collaborative BI Seamless Integration of BI Web Applications into the
Enterprise Portal
Overview: BW Open Analysis Interfaces and BI Java SDK Architecture :
OLE DB for OLAP Based Component Object Model (COM) Driver
(DLLs) installation on clients Windows platform only OLAP BAPIs Business
Application Programming Interface Based on Remote Function Call (RFC) RFC
library available on any SAP platform XML for Analysis Based on XML as exchange
format Based on HTTP/SOAP protocol Any platform Overview: BW Open Analysis
Interfaces and BI Java SDK Architecture BI Java SDK Object Oriented Java API
for consuming XMLA services Encapsulates communication protocol (HTTP,SOAP),
MDX generation and parsing Web API aimed at Web designers that want to create
Web applications for highly individual scenarios based on Java Script, Dynamic
HTML and/or ABAP OO XML Query Result Simple Web Service-based interface for
accessing BW queries or query views XML as result format ODS Read BAPI
Interface for accessing data from ODS objects Open Hub Service Interface for
mass data transfer from SAP BW to 3rd party products Delta capabilities and
enhanced monitoring
Agenda :
Agenda Positioning / Value Proposition Data Warehousing -
ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap
SAP Netweaver™ Turning Enterprise Services Architecture Vision Into Reality :
SAP Netweaver™ Turning Enterprise Services Architecture
Vision Into Reality SAP Netweaver™ Composite Application Framework PEOPLE
INTEGRATION Multi channel access Portal Collaboration INFORMATION INTEGRATION
Bus. Intelligence Master Data Mgmt Knowledge Mgmt PROCESS INTEGRATION
Integration Broker BusinessProcess Mgmt APPLICATION PLATFORM J2EE DB and OS
Abstraction ABAP Life Cycle Mgmt … The open integration and application platform
for TCO reduction Integrate people, information and processes… … in 1 hub … …
across technologiesand organizations. Enterprise-scale Java and ABAP
application platform .NET and WebSphere interoperability and extensibility
Pre-configured with business content Adapters to non-SAP
Information Integration and BI :
Information Integration and BI DB and OS Abstraction SAP
Netweaver™ Information Integration People Integration Knowledge Management
Knowledge Management Integrate & unify multiple sources of unstructured
content Common services Indexing, classification, search Publish &
subscribe Authoring, versioning, … Rating, discussion forum, … For use in
business applications & stand-alone What it means for BI: Base decisions on
hard & soft facts Common context for reports & documents Explain
insights and definitions (e.g. terminology) Annotate BI data and meta-data
Share & disseminate insights Participate in knowledge management services
Enterprise search
People Integration & Business Intelligence :
People Integration & Business Intelligence DB and OS
Abstraction SAP Netweaver™ Information Integration People Integration Portal
Simplify the life of the user Role-based & personalized Unify complex
application landscape Any source, secure & robust Provide task context
Enable new composite applications What it means for BI: Empower more people
within & beyond the enterprise Disseminate the right information to the
right user at the right time Alert timely and allow for immediate action BI for
the masses Close the loop from insights to action Task context Seamless
navigation
Collaboration & Business Intelligence :
Collaboration & Business Intelligence DB and OS
Abstraction SAP Netweaver™ Information Integration People Integration
Collaboration Enable teams Easily share information and applications across
roles Communicate in real-time or asynchronously Manage team activity SAP and
non-SAP collaboration technologies What it means for BI: Support the decision
making processes Broadcast BI data to teams and individuals Integrate data into
collaboration rooms Send alerts to teams & individuals Subscription
services The Solution: Information
Broadcasting Poweredà
by SAP BI
Web Application Server & Business Intelligence :
Web Application Server & Business Intelligence DB and OS
Abstraction SAP Netweaver™ Information Integration Application Platform Process
Integration People Integration Web Application Server Homogeneous
infrastructure for J2EE-based and ABAP-based applications Brings together the
benefits of a proven, scalable and reliable infrastructure with the
interoperability and flexibility of Web Services technology Powerful Java
platform What it means for BI: Complete database and operating system
portability Consistent user accecess Common alert framework
Universal Data Integration :
Universal Data Integration Universal Data Integration BI
Java Connectors to provide access to any data (relational, OLAP) Based on
industry standards for interoperability (JDBC, XMLA, ODBO) Universal Data
Connect to integrate data into the BW platform BI Java SDK for custom built
Java Applications SAP OLTP non SAP SAP Query XMLA JDBC ODBO BI JavaSDK OLAP
Custom-built Applications SAP Enterprise Portal Universal Data Connect 1. BI
Java Connectors JDBC, XMLA, ODBO, SAP Query 2. Universal Data ConnectSAP BW
Integration 3. BI Java SDK Java API, Examples, Documentation BEx BW Staging SAP
BW
BI Java Connectors :
BI Java Connectors Connectors for various data sources Leverages SAP Web AS 6.40 J2EE connectivity
for SAP BWà Basis for Universal Data Connect and BI Java
SDKà
Relational Sources BI JDBC Connector Industry Standard API for relational DBMS
Connectivity to 190+ JDBC drivers providing data access to: Oracle, MS SQL
Server, Teradata, MS Access, DB2, Sybase, Excel, text files (CSV), etc. See
http://java.sun.com for more information BI SAP Query Connector Connectivity to
operational SAP applications SAP R/3, SAP CRM, Ad-hoc, operational OLAP Sources
BI OLE for OLAP Connector Industry Standard OLAP API for MS Windows platforms
Connectivity to MS Analysis Services, SAS, MS PTS, SAP BW BI XMLA Connector Web
Service-based, platform-independent access to OLAP sources Connectivity to MS
Analysis Services, Hyperion, MicroStrategy, MIS, SAP BW The set of connectors
will be extended in further SAP BW releases
SAP Web AS Integration – BI Web Services :
SAP Web AS Integration – BI Web Services BI Web Services
Definition of Web Service A Web Service is a software component that can be
described, discovered and executed using open Internet standards such as WSDL
(Web Service Description Language), SOAP, XML, HTTP For the caller or sender, a
service is a black box that may require input and delivers a result. Web
Service cover the provision of services for integration within an enterprise,
as well as cross-enterprise services on top of any communication technology
stack, whether synchronous or asynchronous Web Services are a new feature of
SAP Web AS 6.40 Scenarios and Features Following Features are released as web
services and can be accessed via open standards XML Data Load XML for Analysis:
Connection of 3rd party front-end vendors to BW OLAP Engine XML Query Result
Set (additional query format XML in addition to XLS and CSV) Example: XML Data
Load The meta data for the XML Data Load (function module, DataSource, data
fields) can be queried via WSDL The caller can now use XML and HTTP/SOAP to
push data into the SAP BW delta queue Example: XML Query Result Set Easy to
call: <SAP_BW_URL CMD=‘EXPORT’ DATA_PROVIDER=‘MyDataProvider’
FORMAT=‘XML’> Compatibility Prerequisite: SAP Web AS 6.40
SAP Web AS Integration – Central Alert Framework :
SAP Web AS Integration – Central Alert Framework The
distribution of BW alerts via the central alert framework leverages functions
of two SAP NetWeaver components: SAP BW and SAP WebAS. The central alert
framework provided by the WebAS can serve as the central hub distributing
alerts from all installed applications. The central alert framework of the SAP
WebAS, provides the following additional functions: Send short text message via
SMS or Pager. Send long text message via e-mail as well as via Fax. Recipients
have the option to subscribe/unsubscribe for the alert. Existing alerting
scenarios (using the Reporting Agent alerting options) can be adapted easily
for alerting scenarios using the central alert framework of the WebAS. Both
scenarios may be run in parallel.
BW Alerts: Options with SAP BW :
BW Alerts: Options with SAP BW Web Application Server
Reporting Agent BEx Query with Exception Central Alert Framework BW Send an
E-Mail Create an Alert Monitor Entry Export via BAdI Send a Short Text via SMS
or Pager Send a Long Text via E-Mail or Fax Other Applications
Exchange Infrastructure & BI :
Exchange Infrastructure & BI DB and OS Abstraction SAP
Netweaver™ Information Integration Process Integration People Integration
Exchange Infrastructure Provides a technical infrastructure for XML-based
message exchange Delivers business-process and integration knowledge to the
customer Provides an integrated toolset for building new business scenarios by
defining and maintaining all integration-relevant information What it means for
BI: XI delivers message based realtime data Complements the
session-oriented(scheduled) data load Real-time data address Operational
Reporting requirements
SAP Exchange Infrastructure (XI) Integration :
SAP Exchange Infrastructure (XI) Integration Inbound Message
Processing Scenario Global Spend Scenario SAP XI as single point to channel
information exchange between various systems Using SAP XI as additional source
for SAP BW Event-driven and transaction-oriented New Guideline with SAP BW
Guideline of integrating SAP XI 2.0 and 3.0 as a SAP BW source on basis of
existing technologies (XML, http/SOAP) Compatibility Prerequisite:SAP XI 2.0or
SAP XI 3.0
Master Data Management & BI :
Master Data Management & BI DB and OS Abstraction SAP
Netweaver™ Information Integration People Integration Master Data Management
SAP MDM enables companies to store, augment, and consolidate master data
Ensures consistent distribution to all applications and systems within the IT
landscape. What it means for BI: Content consolidation Master Data
Harmonization Central Master Data Management
SAP BW / MDM Integration Scenarios (1) :
SAP BW / MDM Integration Scenarios (1) SAP MDM deliveres
identifying navigational attributes for SAP BW Master data is mainly managed in
the MDM Clients For Content Consolidation master data has to be load into the
MDM system, where the Content Integrator Engine consolidates the master data by
finding duplicate records based on predefined matching processes.Global key
mapping information is the result of this process. MDM key mapping information
can be used in BW as a grouping attribute for global analysis needs
MDM Content Consolidation and SAP BW :
MDM Content Consolidation and SAP BW SAP MDM SAP BW SAP ERP
MATNR MATNR MATNR MATNR 1 ERP Solutions Business ContentAreas Operational
Reporting(localized, unified) XI MDM Scenario 1:Content Consolidation
Identifying Attr.
SAP BW / MDM Integration Scenarios (2) :
SAP BW / MDM Integration Scenarios (2) Dedicated Consolidated
InfoObjects as MDM Business Content in BW For Master Data Harmonization reasons
master data is mainly created in MDM and can be enhanced with local aspects
after the distribution to the MDM Clients Consolidated Info Objects in BW are
capable to implement the entire master data description from MDM in BW. Local
aspects of master data administration have to be loaded seperately from the MDM
clients into the BW
Master Data Harmonization between BW and MDM :
Master Data Harmonization between BW and MDM Material CRM
Products Articles ... SAP MDM SAP BW SAP ERP MATNR ... ... ... General Products
2 Operational Reporting(localized, identified) Strategic(global, consolidated)
All Global Attr. Global Attr. Global and local Attributes XI MDM Scenario 2:MD
Harmonization
Agenda :
Agenda Positioning / Value Proposition Data Warehousing -
ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap
Business Content – Definition :
Business Content – Definition Predefined, role-based and task-oriented
information models Provide technical definitions, such as extraction and
transformation rules Predefined templates for reporting and analysis. For
various industries and business areas
SAP BW Business Content Benefits :
SAP BW Business Content Benefits Ready-to-go reports, data
models, extractors, transformations Significant cut down of implementation time
and costs Easily extensible Integrated view of corporate data Immediate access
to interpreted information Consistency Rich set of standard key performance
indicators Best practice models Integration of e-Business and ERP systems Tight
integration with mySAP applications Integration with non-SAP data Web-enabled
Validated and comparable information Cross-system/cross-application
Business Content – Overview (1) :
Business Content – Overview (1) Customer Relationship
Management Financial Accounting Controlling Strategic Enterprise Management
Human Capital Management Product Lifecycle Management Supply Chain Management
Supplier Relationship Management Cross X Marketplaces Non SAP System
Integration Tealeaf (E-Analytics) Oracle Oracle Financials (General Ledger and
Oracle Receivable) AC Nielsen (Market Analytics) Dun & Bradstreet (Market
Analytics)
Slide 84:
Aerospace and Defense Apparel and Footwear Automotive
Chemicals Consumer Products Distributor Reseller Management Financial Services
Banking Insurances Financial Service Provider Profit Analyzer Healthcare High
Tech Media Oil&Gas Pharmaceuticals Public Sector Real Estate Retail Service
Providers Telco Utilities Business Content – Overview (2) Industry Solutions
Customer – and Partner Content :
Customer – and Partner Content Customer / Partner Content
Scenario Customers centrally create templates which can be rolled out to
subsidiaries (Enterprise DWH) Partners create own content which can be
delivered individually to interested customers Feature Description Release of
feature, which has been piloted in SAP BW 3.0B Content for objects in SAP BW as
well as extractors in Service API in SAP source systems This denotes content in
addition to SAP delivered Business Content Content can be shipped via
transports Support of partner content only by partner Partner Content can be
certified by SAP
Agenda :
Agenda Positioning / Value Proposition Data Warehousing BI
Platform BI Suite Netweaver Integration Business Content Roadmap
Roadmap – Timeline and Focal Points :
Roadmap – Timeline and Focal Points Q1/2003 Q1/2004 2005 SAP
Netweaver BW 7.0 SAP BW 3.5 Information Broadcasting Universal Data Integration
Embedded BI – Integration into SAP Netweaver Business Planning & Simulation
Unicode SAP BW 3.1 BI Content 3.2 Add-On BI Content 3.3 Add-On BI Content 3.5.1
Add-On BI Content 3.5.2 Add-On BI for the Expanded Enterprise Active Business Intelligence
Integrated planning Advanced user experience BI Content 3.1 Add-On BI Content
3.5.3 Add-On Start of Ramp-Up
No comments:
Post a Comment