sap mysap bi solution

7/28/2019 SAP MySAP BI Solution

1/42

Solution overview

mySAP BusinessIntelligence


2/42

SAP AG 2003, mySAP Business Intelligence Solution overview / 2

mySAP Business IntelligenceData Warehousing with mySAP BIBusiness Intelligence PlatformBusiness Intelligence Suite

Enterprise PortalSummary

Agenda


3/42


mySAP Business Intelligence


4/42




5/42




Agenda


6/42


Extraction, Transformation and Loading

to get a complete view of your business

Open for any source

Flexible set of ETL capabilities

Integration to mySAP.com on

application level

Open to third-party tools

Support of open standards


7/42 SAP AG 2003, mySAP Business Intelligence Solution overview / 7

The information model of SAP BW

Integrated flow of data

Rich transformation toolbox.

Flexible and non-redundant data models.

Data Aging Strategies: ADK-based archiving and near-line storage with

FileTek

to model the business



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



Controlled distribution

of consistent data

Target: file or DB table

Central monitoring

Select filter criteria andcolumns

Scheduling

Full or delta mode

ODS Objects

Open Hub Service - Details



Business Modeling

Data Flow TransparencyApplied Business Structure

Data Model Transparency

Automated Administration

Data

ModelData Flow

Process

Chain

Hierarchies



Documents in SAP BW

documents for

metadata

documents for

masterdatadocuments for

transactional data



Warehouse Management

to store, update, maintain and aggregate

information according to your needs

Central and complete administration

Meta data repository: business and

technical meta data

Open Hub Service: Data from ODS-Object

and InfoCube can be distributed; full &

delta, monitoring & scheduling

Transparency across all objects and

Automation of warehouse management

processes





Agenda



Information Access & OLAP

... to enable targeted analyses



Data Mining

Behavior Modeling Decision Tree

Clustering

Scoring

Regression/MLR

Association Analysis

Value Modeling Customer Lifetime

Value (CLV)

Recency Frequency

Monetary Value (RFM)

... to detect structures and dependencies





Agenda



Business Intelligence Users

Authors and analysts... need advanced analysis functionality and ad-hoc dataexploration 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 specific information (snapshot of a particular data

set) to perform their operational tasks

... do not interact extensively with the data.



mySAP BI allows Users to ...

Easily access and explore information Analyze that information Develop insights and understanding

Leads to improved and informed decisions at alllevels

Support on strategic, tactical and operational decisions

Optimize organization and business processes

Enable collaboration on trends and exceptions

Capitalize on market and business opportunity

Manage business and strategy towards profitability

Ensure individual effectiveness

Optimize interactions with customers and suppliers

Drive success within departments


19/42


Business Intelligence Users, Needs and Functions

Query &Reporting Analysis &Exploration Deployment &User Access

Executive /

Knowledge Worker

Strategic

Operational

Query

Design

Web or Excel

Portal

Tabular

Reports

Pre-built

Report

Templates

Managed,formatted

Reports

Any Device

Interactive

Content

iViews

Role-based

Targeted

Dashboards

OLAP

Analysis

Data Mining

Ad-hoc DataExploration

Alerting

Geographical

Analysis

Packaged

Applications

Analyst/Author

Tactical

Customization Data Depth Complexity

Information Consumer


20/42


mySAP BI

Support for business decisions at all levels

Operational, tactical or strategic

Ready-to-start templates with predefined KPIs

Scalable

From static, managed reports to highly interactiveanalysis applications

Desktop or web-based

Comprehensive tool-set

For query design, reporting and analysisWeb application design

Fast deployment of personalized information

Integration into the Enterprise Portal Role and business process specific information

User Access: anytime, anywhere

Analyze information within a web browser On any device (PC or mobile)


21/42


Query Design

BEx Query Designer Ease-of use via drag & drop

Personalized access

Comfortable formula editor for

calculations

One-step web publishing

Windows-based component

Web interface for intuitive ad-

hoc analysis on the web

Only Filter and

Column Section in

tabular mode


22/42


One Design Tool - Multi-layered Analysis Options

Multiple data sources A unified view from an integrated data basis

Different data granularity and aggregation levels Summarized to line item

Flexibility in data depth and breadth

OLTP / External Data Sources

ODS Object

InfoSets

InfoCubeDataAgg

regation

MultipleIn

foProvider

BIS

uite

Business

Explorer


23/42


Reporting and Analysis

Share and analyze information via Web Browser (PC or mobile)

Windows Desktop using MS Excel

Analysis on aggregated or transaction level dataPackaged AppsBroad range of extendable reporting and analyis templates provided

Business aware Time dependency, realignment

Currency conversion (e.g. different per column)

Versioning, Aggregation rules

Intelligent Services Alerting - Identify and Handle Exceptions, Pro-active notification

Conditions

Data Mining

R ti


24/42


Reporting

Tabular Reporting

Query with diverse columns infree alignment

No distinction betweencharacteristics and key figures

Option to switch between tabularand 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

R ti I t ti ith C t l R t


25/42


Reporting - Integration with Crystal Reports

Out of the box presentation-quality reporting

Reports and documents optimized for printingand sharing

Broad range of pre-defined crystal reports:

legal, financial, etc

SAP and non-SAP data in a single

report

Seamless portal integration

Schedule and view Crystal reports

in managed web environment

Offline reporting and viewing of

reports

I t ti A l i


26/42


Interactive Analysis

Analyze different aspects of the

business

Multi-dimensional views Generic navigation and interaction

(slice and dice, drill-down, drill-

thru, pivoting, ...)

Hierarchy navigation

Global, enterprise-wide use Multi-language, multi-currency

Intelligent Services

Alerting (traffic lights)

Conditions

User access and interaction

Web-based

Windows-based via BusinessExplorer Analyzer

OLAP analysis in MS Excel

Integration point for query and

web application design

Leverage native Excel features

(i.e. office integration)

Tight integration of web- and MS

Excel-based analysis

W b b d R ti & A l i


27/42


Web-based Reporting & Analysis

Ease-of useAccess, analyze and shareinformatione within a web browser

Zero FootprintQuick ROI Packaged BI web applicationsOpen Analysis Framework Supporting standards like XML/Aand OLE DB for OLAP

Alerting Pro-active notificationAnalytical complexity whenneeded Ad-hoc query design Full interactivity (filter, drill-down,slice and dice, etc.)

Performance Precalculated web applications1:n Parametrization allows for onequery to serve multiple users

Geographical analysis Interactive maps

D i f BI W b A li ti


28/42


Design of BI Web Applications

BEx Web Application DesignerOffers the ability to create all kinds ofanalytical Web Applications

Build packaged BI Applications

Cockpits / Dashboards

Wizard-based visualization

Online & Offline Scenarios

Publishing

Device specific output generation

iView creation / Portal integration

APIs for further web design

W b A li ti F k


29/42


Web Application Framework

Web Design Tool (option)

OLAP Processor

BEx Web ApplicationDesigner

BEx Analyzer /Query Designer

BW ServerwithSAP Web ASWeb Service

Charting Engine

Web Browser

HTLM Templates InfoProvider

Anal tical Collaboration


30/42


Analytical Collaboration

Share comment

Mobile Intelligence
http://g-images.amazon.com/images/G/01/electronics/buyingguide/mikeb/crt-monitor-side-view.jpg


31/42


Mobile Intelligence

TechnologyBW Web applications areautomatically mobile- enabled

Device recognition

Device specific rendering

Device specific navigation

One tool serves all scenarios

BEx Web Application Designer

Performance

Pre-calculated reports / web

applications

Synchronization with PDA

ScenariosMobile Reporting

Timely decisions with real-time

data

Wireless connection, no access to

a networked computer

Offline reporting Portability

Snapshot of data needed for a

specific business situation (i.e at

the customer site)

Analytic functionality

Mobile Intelligence: PDA example


32/42


Mobile Intelligence: PDA example

PDA specific output

HTML with reduced JavaScript for PDA devices

Transformation of style sheets into pure HTML for PDA devices

Device-specific context menu for PDA devices

Navigation and

table display

Charts Context menu

Agenda


33/42




Agenda

Enterprise Portal


34/42


Enterprise Portal

Applications &

Legacy SystemsInternet

Data Warehouse

& DSS

Content &

Documents

Original Source

Extracted & Manipulated

Structure

d

Unstructured

Enterprise Portal

iViews & Unifiers

Internet Content &Web Services

Knowledge

Management

Business

Intelligence

Enterprise

Portal&

Business

Unification

EnterprisePortal

Solutions

Information Deployment


35/42


Information Deployment

Personalized information and

decision support for all users

Share and analyze

business information

Analytics in context

Collaborative BI

Employee

Customer

Citizen

Business

Partner

Seamless Integration of BI Web Applications into theEnterprise Portal

Agenda


36/42




Agenda

Business Content: pre-configured information models


37/42


Business Content: pre-configured information models

+90 ODS Objects

+420 InfoCubes

+1700 Queries

The ideal starting point for custom-built Analytical

Applications

Analytical Applications


38/42


Analytical Applications

Timeline for SAP BW 3 0


39/42


20022001

Timeline for SAP BW 3.0

End of

2. Quarter

From

Dec., 17

First

Customer

Shipment

Controlled

Availability

From

Sep., 22

(Oct. 15 Inst)

3.0A 3.0B

Beginning

2. Quarter

General

AvailabilityFirstCustomerShipment

End of maintenance: September 2002End of maintenance: May 2005



40/42



mySAP Business Intelligence is the first complete and

open solution that provides accessibility, collaboration anddeployment of relevant, timely and insightful information to

anyone, anywhere at anytime to understand, optimize and

align their business.

mySAP Business Intelligence Solution


41/42


mySAP Business Intelligence Solution

Business Benefits:

Increased Effectiveness of Decision Making

Cost Reduction by Reducing Time to Action

Optimization of Business Processes

Key Advantages:

End to End Solution

Business focus

Open Platform Complemented Through Partners

Business Content to Maximize ROI

Opinions about mySAP Business Intelligence


42/42

Opinions about mySAP Business Intelligence

William H. Inmon, the father of data warehousing about mySAP BI:

"...No other vendor has the same reach across all the environments in acomprehensive manner. Some vendors have software. Other vendors have

hardware. But in terms of forming a complete picture across the entire

corporate information factory landscape no other vendor can compete......

White paper available atwww.billinmon.com
http://www.billinmon.com/http://www.billinmon.com/