Download - Sap bw bi
![Page 1: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/1.jpg)
BW Overview
BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s
Roadmap from BW to BI
Implementation Experience
www.solitairesoft.com
![Page 2: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/2.jpg)
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Roadmap from BW to BI
Implementation Experience
www.solitairesoft.com
![Page 3: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/3.jpg)
SAP BW – A success story
Active BW Customers > 6,500
How do you planto leverage SAP BW?
Mixed data: 64%
SAP data only: 36%
Are you satisfiedwith SAP BW?
Yes95%
No5%
50 - 25039%
1,000 - 10,00013% < 50
24%
> 10,0001%
250 - 1,00023%
Number of Users
100 - 500 GB32%
500 GB - 1 TB18%
> 5 TB1%
0 - 100 GB26%
1 - 5 TB23%
Approximate DataVolume
www.solitairesoft.com
![Page 4: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/4.jpg)
Key Features of a Data Warehouse• Data from across all relevant sources
internal & external to the business • Separated Transactional & Analytical
environments• End user report creation• Cross functional & targeted reporting• Detailed & summary data• A single version of the the truth
www.solitairesoft.com
![Page 5: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/5.jpg)
Information Management ‘Best of breed’ technologies Rich Business Content -pre-configured Information models,
reports, KPI’s and extractors Industry Specific Business Content Configurable to specific requirements
Data Extraction Built on the SAP Entity Model SAP and non-SAP data extraction Powerful Data Maintenance and Administration
Powerful Information Analysis Innovative, intuitive user interface Powerful OLAP analysis Web & MS Excel based front-ends Easy integration with Portal
An integrated end-to-end Data Warehouse solutionSAP Business Warehouse (BW)
www.solitairesoft.com
![Page 6: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/6.jpg)
SAP Business Intelligence
Dashboards Targeted reports
OtherOther3rd PartySalesInterfaces
CreditControl
Sales Finance &Projects
Self-service Reporting
Business Warehouse
(BW)Business Content
www.solitairesoft.com
![Page 7: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/7.jpg)
SAP BI - Reporting and Analysis For All User Types•Authors and Analysts
– Need to dig into the data – explore & find trends
•Business Managers – Need personalized information specific to their function
– Summary – but with the ability to drill down to the detail
•Executives– High level analysis (dashboards) - alert to key business issues &
actions
www.solitairesoft.com
![Page 8: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/8.jpg)
ã SAP AG 2004, Title of Presentation / Speaker Name / 8
Authors & Analysts
www.solitairesoft.com
![Page 9: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/9.jpg)
Business Managers
Alert Driven
Targeted
Emailed
www.solitairesoft.com
![Page 10: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/10.jpg)
Executives
www.solitairesoft.com
![Page 11: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/11.jpg)
Information Broadcasting11
Universal Data Connection
NetWeaver Integration
Business Planning & Simulation (BPS)44
33
22
BW release 3.5 Overview
Advanced Analytic functionality55
www.solitairesoft.com
![Page 12: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/12.jpg)
In this example the Report was sent in an MHTML-Format and is now available in the personal Inbox of the Receiver.
Information Broadcasting via E-Mail
www.solitairesoft.com
![Page 13: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/13.jpg)
What Are The Broadcasting Channels?
• SAP Enterprise Portal 6.0 SP3– Knowledge Management Folders (“BEx Portfolio”)
• Available KM Services: e.g. Indexing & Search engines (TREX), Subscription, Downloads, Rating, etc.
– Portal Content Catalog (part of the Portal Content Directory)
– Collaboration rooms & discussion forums• Email– BW users, BW roles or email addresses– Online queries, workbooks & web applications are sent as URLs– Pre-calculated queries, workbooks & web applications are sent as
attachments or as inline mail body (MHTML)www.solitairesoft.com
![Page 14: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/14.jpg)
What Are Reporting Documents? • Pre-calculated, online and offline reporting documents…
– BI Web Applications - Dashboards, cockpits– BEx Analyzer Workbooks– Queries
• ... in different formats ...– HTML
• Device specific (Web Browser, Mobile devices, etc.)
– BEx Analyzer Workbooks– Excel files– Emails using Multipart Html (MHTML) – ZIP Files
• ... containing different kinds of information.– OLAP data, Alerts, Embedded Documents and Filter Navigation
www.solitairesoft.com
![Page 15: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/15.jpg)
Information Broadcasting – BEx Portfolio
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
Queries, Workbooks, BI Applications as KM Documents
www.solitairesoft.com
![Page 16: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/16.jpg)
Information Broadcasting11
Universal Data Connection
NetWeaver Integration
Business Planning & Simulation (BPS)44
33
22
BW release 3.5 Overview
Advanced Analytic functionality55
www.solitairesoft.com
![Page 17: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/17.jpg)
Universal Data Integration
BI Java Connectors to provide access to various data sources (via interfaces JDBC, XMLA, OLE DB for OLAP, SAP Query)
Based on industry standards for interoperability (JDBC, XMLA, ODBO) Universal Data Connect to integrate data into BW platform BI Java SDK for custom built Java Applications
SAP
nonSAP
SAPQuery
XMLA
JDBC
ODBO
BIJavaSDK
OLAP
Custom-builtApplications
SAPEnterprise Portal
UniversalData
Connect
1. BI Java Connectors JDBC, XMLA,ODBO, SAP Query
3. BI Java SDKJava API, Examples, Documentation
BExBW
Staging
2. Universal Data ConnectSAP BW Integration
www.solitairesoft.com
![Page 18: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/18.jpg)
BI Java Connectors
•Connectors for various data sources
• Leverages SAP WebAS 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 200+ 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 DB 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 3.x
– The set of connectors will be extended in further SAP BW releases
www.solitairesoft.com
![Page 19: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/19.jpg)
SAP BW – Non SAP-DW Integration Scenario
ERP
DW
Reporting
SAP HR Cubes
BW
Local Skills Database
Non SAP-DW
Various SourcesSAP HR Data
Listing
Personnel Deployment vSkills profile
www.solitairesoft.com
![Page 20: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/20.jpg)
Information Broadcasting11
Universal Data Connection
NetWeaver Integration
Business Planning & Simulation (BPS)44
33
22
BW release 3.5 Overview
Advanced Analytic functionality55
www.solitairesoft.com
![Page 21: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/21.jpg)
DataSources
BW and XI
PSA
realtime updateDelta-Queue
mySAP.com(via BW Service-API)
SAP BW
http / SOAP
Near RealtimeInfoPackage
Standard Staging
OperationalData Store
Realtime Data Acquisition
Delta-QueueOpen Service
PSAPSA
RFC
SAP XI
www.solitairesoft.com
![Page 22: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/22.jpg)
Information Broadcasting11
Universal Data Connection
NetWeaver Integration
Business Planning & Simulation (BPS)44
33
22
BW release 3.5 Overview
Advanced Analytic functionality55
www.solitairesoft.com
![Page 23: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/23.jpg)
Planning in mySAP BI – EvolutionFuture Planning
Environment
mySAP BI
SAP BW Data Management Modelling Planning Framework Process Coordination Analysis
mySAP FinancialsSEM-BPS Planning Financial Planning ApplicationsSEM-BPS Planning
Financial Planning Applications
Modelling Planning Framework Process Coordination
mySAP BISAP BW Data Management Analysis
Current Planning Environment
mySAP Financials
www.solitairesoft.com
![Page 24: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/24.jpg)
Planning cycles
August December
Strategic Planning
Strategic Planning and Target setting on group level
Operational Planning
Operational Planning and Budgetingin the business units
Headcountplanning
Sales planning
Production planning
Marketing planning
Reconciliation of operational plans
with strategic targets
Strategic Targets(Operating Profit + 4%,
Market share+10%)
Plan evaluation
www.solitairesoft.com
![Page 25: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/25.jpg)
SAP BI Planning Architecture
Data Acquisition
AutomaticPlanning
Manual Planning/Analysis
Process control
Access / Storage
Master DataDimensional
Data Granular Data
Common Read / Write Interface
Planning Framework
DWH Layer
Business Logic
Planning Front EndsPresentation
Open Interface and Web Services
Modeling
Portal based Excel Inplace Excel Client ALV GridHTML in GUI
User Interaction
www.solitairesoft.com
![Page 26: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/26.jpg)
Information Broadcasting11
Universal Data Connection
NetWeaver Integration
Business Planning & Simulation (BPS)44
33
22
BW release 3.5 Overview
Advanced Analytic functionality55
www.solitairesoft.com
![Page 27: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/27.jpg)
ã SAP AG 2004, Title of Presentation / Speaker Name / 27
Advanced Ad-hoc Reporting
New web template for ad-hoc analysis Extensibility: Easy support of customer adaptations in Web App Designer Enhanced usability and new look-and-feel New functionality within the template tool bar
www.solitairesoft.com
![Page 28: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/28.jpg)
Web Application Designer
Chart Designer Wizard (ReducedOverview)
Result
www.solitairesoft.com
![Page 29: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/29.jpg)
Data Mining Methods - Explorative
A B C 20% of customers generate
60% of sales
Clustering
ABCClassification
AssociationAnalysis
WeightedScore Tables Customer Age Gender Income
… … … …
… … … …
Score
…
…
Weight
www.solitairesoft.com
![Page 30: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/30.jpg)
?Age
Sales
Complaints
# of Products
Gender
Income
Buy
Yes
No
Complaints
Gender
Income
Data Mining Methods - Predictive
>4<=4
MF
<=30 k >30 k
Regression
Decision Trees
No
No Yes
Yes
www.solitairesoft.com
![Page 31: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/31.jpg)
Analysis Process Designer
– Graphical modeling (drag&drop) and execution of Analysis Processes that make use of Data Mining to gain new insights and take action – closed loop
– Examples of “Analysis Processes” would be the definition of ABC classes, the calculation of frequency distributions or the determination of Scoring information.
![Page 32: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/32.jpg)
Composite Scenarios: Customer Retention
A B C
ABC ClassificationDecision Trees Clustering
B
C
ALoyal
At Risk
AssociationAnalysis
Cross-SellingRules
Marketing Campaign
TransferKnowledge
Goal: Reduce Customer Churn
www.solitairesoft.com
![Page 33: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/33.jpg)
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Roadmap from BW to BI
Implementation Experience
www.solitairesoft.com
![Page 34: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/34.jpg)
Analytical Applications11
BI Accelerator
Enterprise Data Warehousing
Enhanced Web & Excel Reporting 44
33
22
NetWeaver 2004s
Integrated Planning55
www.solitairesoft.com
![Page 35: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/35.jpg)
SAP NetWeaver™The total integration and application platform for lower TCO
• Unifies and aligns people, information and business processes– Integrates across
technologies and organizational boundaries
– A safe choice with full .NET and J2EE interoperability
• The business foundation for SAP and partners– Powers business-ready
solutions that reduce custom integration
– It’s SAP Enterprise Services Architecture increases business process flexibility
SAP NetWeaverCO
MPO
SITE
APP
LICA
TIO
N F
RAM
EWO
RK
PEOPLE INTEGRATION
Multi channel access
Portal Collaboration
INFORMATION INTEGRATION
Bus. Intelligence
Master Data Management
Knowledge Mgmt
PROCESS INTEGRATION
Integration Broker
Bus. ProcessMgmt
APPLICATION PLATFORM
J2EE
DB and OS Abstraction
ABAP
LIFE CYCLE MAN
AGEM
ENT
...
www.solitairesoft.com
![Page 36: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/36.jpg)
Architecture Source: Gartner (CPM, 2004)
Web Presentation/Portal/Mgmt Reporting
Mod
elin
g an
d O
ptim
izatio
n
Cons
olid
ation
Bala
nced
Sc
orec
ard
Budg
etPl
an/F
orec
ast
Stat
utor
yRe
porti
ng
Ad H
oc Q
uery
an
d Re
porti
ng
DataMart DataMart DataMart DataMart
Data Warehouse
Integration Broker
ERP/CRM/SCM/External Sources
Busi
ness
Pro
c. M
anag
emen
t
Cont
ent
Man
agem
ent
Know
ledg
e M
anag
emen
tPresentation
CPMApplications
BIInfrastructure
DataSources
The Business Intelligence Platform
www.solitairesoft.com
![Page 37: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/37.jpg)
Web Presentation/Portal/Mgmt Reporting
Mod
elin
g an
d O
ptim
izatio
n
Cons
olid
ation
Bala
nced
Sc
orec
ard
Budg
etPl
an/F
orec
ast
Stat
utor
yRe
porti
ng
Ad H
oc Q
uery
an
d Re
porti
ng
DataMart DataMart DataMart DataMart
Data Warehouse
Integration Broker
ERP/CRM/SCM/External Sources
Busi
ness
Pro
c. M
anag
emen
t
Cont
ent
Man
agem
ent
Know
ledg
e M
anag
emen
t
Process Integration
Strategic Enterp.Management
Powered bySAP NetWeaver
SAP NetWeaver
People Integration
Information Integration
SAP delivers the complete, end-to-end, reliable and open BI Solution.
The SAP NetWeaver BI Platform
www.solitairesoft.com
![Page 38: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/38.jpg)
Analytical Applications11
BI Accelerator
Enterprise Data Warehousing
Enhanced Web & Excel Reporting 44
33
22
NetWeaver 2004s
Integrated Planning55
www.solitairesoft.com
![Page 39: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/39.jpg)
Controlling(BW)
Logistics(SCE)
Sales(CRM)
Production(SCP)
Fulfillment (FC)Fin.-Dptm.
(FIN)Customer
Creation & Release Delivery Request
4
UpdateInventory Accounting
7Update
Inventory
6
DeliveryExecution
5
Request Global ATP
2
Global ATP Check
3
ReceivesASN
9
ReleaseASN
8
1
Creation Sales OrderFulfillment
Request
Creation Purchase
Order
WHAT IS “NEW” ANALYTICS?Example: Sales Order Fulfillment process
www.solitairesoft.com
![Page 40: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/40.jpg)
WHAT IS “NEW” ANALYTICS?
“360° View of the Customer”
“Is customer credit-worthy?”
“smooth shipping Process?”
“sufficient stock of inventory?”
“extra effortcosts $$$?”
Questions & Insights lead to process improvement!
www.solitairesoft.com
![Page 41: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/41.jpg)
Visual Composer Model
www.solitairesoft.com
![Page 42: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/42.jpg)
www.solitairesoft.com
![Page 43: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/43.jpg)
Analytical Applications11
BI Accelerator
Enterprise Data Warehousing
Enhanced Web & Excel Reporting 44
33
22
NetWeaver 2004s
Integrated Planning55
www.solitairesoft.com
![Page 44: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/44.jpg)
BI AcceleratorPerformance OptimizationSAP NetWeaver 2004s provides various tools to increase the data load and query performance significantly – among them the innovative high performance analytics approach. Thus, the implementation of large enterprise data warehouses is facilitated.
BI AcceleratorA new paradigm for high performance
data access. Query performance is boosted by orders
of magnitude Simultaneously the realignment
processes roll-up and change run are improved significantly
HPA is used in connection with KM search engine TREX
Provides linear scalability and can fully leverage grid and adaptive computing capabilities
www.solitairesoft.com
![Page 45: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/45.jpg)
Target
BI Accelerator
Very fastQuery Response Time
StableQuery Response Time
High Scalability Low Maintenance
Performance ImprovementBy Factor 10 in average,
Up to Factor 1000 !
Stable Good QueryResponse Time – Independent
From Database Features,Caches, Aggregates, …
Support of New HardwareParadigms like
Grid Computing, AdaptiveComputing
No Aggregate Maintenance,Unnoticeable ‘Roll-up’,
No Change Run
www.solitairesoft.com
![Page 46: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/46.jpg)
InnovationColumn-Based
Data Storage andAccess / Vertical
Table Decomposition
Column-BasedData Storage andAccess / Vertical
Table Decomposition
In-MemoryProcessing
In-MemoryProcessing
Highly ParallelData Access /
Horizontal Partitioning
Highly ParallelData Access /
Horizontal Partitioning
Dictionary-based,Smart Compression
Using Integers
Dictionary-based,Smart Compression
Using Integers
What makes SAP BI with the BI accelerator
so fast?
What makes SAP BI with the BI accelerator
so fast?
www.solitairesoft.com
![Page 47: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/47.jpg)
Introducing BI Accelerator Appliance - 1
SAP NetWeaver
BI Server
datadata
data
data
actionable information
Business User
IT Department
System Performance
System performance declining when increasing utilization
![Page 48: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/48.jpg)
SAP NetWeaver
BI Server
Introducing BI Accelerator Appliance
datadata
data
actionable information
Business User
IT Department
System Performance
Increase scalability and flexibility, w/o impacting architecture
BIacceleratorappliance
blade
blade
blade
data
2004s2004s
2004s2004s
![Page 49: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/49.jpg)
BI Accelerator of SAP NetWeaver – Architecture
SAP NetWeaver BI
HPA EngineUsing
Adaptive Computing
DataAcquisition
InfoCubes
AnalyticEngine
AnySource
SAP NetWeaver2004s
SAP NetWeaver2004s
Preferred Technology Partner
Preferred Hardware Partners
SAP NetWeaver2004s
SAP NetWeaver2004s
BusinessExplorer
Any Tool
www.solitairesoft.com
![Page 50: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/50.jpg)
Analytical Applications11
BI Accelerator
Enterprise Data Warehousing
Enhanced Web & Excel Reporting 44
33
22
NetWeaver 2004s
Integrated Planning55
www.solitairesoft.com
![Page 51: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/51.jpg)
Modeling the EDW - FlexibilityData ModelingSAP NetWeaver 2004s provides additional flexibility for implementing new data models and changing existing ones.
Re-Modeling Toolbox Changing InfoCubes without rebuilding them from scratch – improved flexibility
Enhanced DataStore objects(formerly: ODS objects)Improved performance and flexibility
Enhanced InfoSets Improved flexibility
Integrate InfoCubes into join condition
www.solitairesoft.com
![Page 52: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/52.jpg)
Modeling the EDW - DataSource ConceptData Acquisition SAP NetWeaver 2004s improves and streamlines the DataSource definition. In addition, it enhances remote access capabilities.
New DataSource conceptUnified and improved maintenance
E.g. Web Service (XML), UD Connect
Additional DataSources enabled for remote access (including flat files and DB Connect)
Enhanced remote capabilitesRemote master data access –no data replication, low TCO
Remote access of masterdata from source systems www.solitairesoft.com
![Page 53: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/53.jpg)
Modeling the EDW - Transformation concept
Transformation SAP NetWeaver 2004s significantly improves transformation capabilities. The improved graphical UI contributes to decrease TCO.
TransformationImproved performance, flexibility and usability
Graphical UI Unification and simplification
of transfer and update rules New rule type: end routine New rule type: expert
routine (pure coding oftransformation)
Unit Conversion Capabilities for unitconversion during dataload (and reporting) www.solitairesoft.com
![Page 54: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/54.jpg)
Running the EDW - Real-Time Data Acquisition
Data Flow ControlSAP NetWeaver 2004s improves and streamlines the data flow definition and the process chain set-up. In addition, it provides new real-time data acquisition capabilities that facilitate operational reporting:
Enhanced real-time data acquisition capabilitiesXML Web service
Direct push into PSA (instead of Service API/Delta Queue)
Near-real-time InfoPackage & DTP Daemon-based update from
delta queue (BW Service API) Daemon-based update of
DataStore objects(ODS layer) – including leanstaging (with minimizedlogging)
www.solitairesoft.com
![Page 55: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/55.jpg)
EDW – Further enhancements• Modeling the EDW
– Data Warehousing Workbench
• Improved usability and lucidity– Content Analyzer and Content Browser
• New overview-, search- and analysis capabilities for Business Content
• Running the EDW– Process Chains
• Additional functionality and process types– Data Quality
• Improved error handling– Re-partitioning
• Supports attaching, combining partitions or complete re-partitioning – New Analysis Authorization concept
• Higher flexibility and simplified modeling
www.solitairesoft.com
![Page 56: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/56.jpg)
Analytical Applications11
BI Accelerator
Enterprise Data Warehousing
Enhanced Web & Excel Reporting 44
33
22
NetWeaver 2004s
Integrated Planning55
www.solitairesoft.com
![Page 57: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/57.jpg)
Query, Reporting & Analysis – Designing a Report
Designing a Report
Report design takes place in the Business Explorer (BEx) Report Designer - a new, VB .Net-based tool that allows to create formatted, print-optimized reports.
Standard formatting: Font styles (e.g. bold, italic) and colors, etc.
Group level changes with individual formattings
Layout options, for example Height of rows, width of columns Multiline column headers Flexible positioning of fields Merger of cells
Support of hierarchies Rules for the presentation of special
characteristic values Integration of texts, pictures, and charts Header and footer for reports and pages
www.solitairesoft.com
![Page 58: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/58.jpg)
Query, Reporting & Analysis – Designing a Web Application
Designing a Web Application
Web application design takes place in the Business Explorer (BEx) Web Application Designer, a Visual Basic .NET-based, Unicode-compliant tool.
Model-driven BI application building Wizards for charts, maps, command
editing Wizard for layout elements (e.g.
buttons) „Intellisense“ support for Web API
developers Easy integration of native HTML
commands New layout elements (Tab strips etc.) New Web items New chart types, e.g. GANTT chart,
MTA chart Design of planning aware business
applicationswww.solitairesoft.com
![Page 59: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/59.jpg)
Intuitive Ad-Hoc Analysis – BEx Web Analyzer
•Web-based Ad-hoc Design Leveraging Drag & Drop – Easy navigation, when dropping characteristics on top of rows or columns– Easy filtering, when dropping a characteristics to filter area– Personalized Filters– Saving and distribution of analysis results through strong portal integration– Close integration to
Information Broadcasting and Knowledge Management
– Wizard-based definition of exceptions and conditions
– Query creation on top of SAP BW and 3rd party data(via XMLA Connectors) Drag and
Drop
www.solitairesoft.com
![Page 60: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/60.jpg)
BEx Web Printing • Comfortable PDF based BEx Web printing
– Any type of BEx Web query, Report or Web Application can be converted to PDF and printed
– Leveraging the SAP NetWeaver AS integration with Adobe Document Service
– Adobe Acrobat Reader required, no plug-ins necessary– Printing options can be maintained globally or individually by an
end-user
pdf-conversion of a web item
www.solitairesoft.com
![Page 61: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/61.jpg)
Excel integration - Workbook Design with BEx Analyzer
• Application-building in Excel (similar to Web Application Designer)
• New Options for Queries with 2 Structures– Excel Formulas allow access to any
cell of the result set– Excel Formatting options can be fully
leveraged for BEx Workbooks (e.g blank lines, fonts etc.
– Combining Excel Formulas and Excel Formatting allows the design of High-End Formatted solution workbooks
• Integration of Business Planning
Workbook Design
![Page 62: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/62.jpg)
Analytical Applications11
BI Accelerator
Enterprise Data Warehousing
Enhanced Web & Excel Reporting 44
33
22
NetWeaver 2004s
Integrated Planning55
www.solitairesoft.com
![Page 63: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/63.jpg)
Business Planning and Analytical Services – Wizard Mode
Planning Model Design – Wizard Mode –
– Create a simple model of BI integrated planning by means of the Planning Wizard• Web based modeling environment for planning
related tasks • Using the “Road map Pattern”
![Page 64: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/64.jpg)
Business Planning and Analytical Services – Planning Layout Design-time
Drilldown Hierarchical data in rows
and columns Calculated key figures Structures Unit conversion
AlertsConditionsGraphicsAd-hoc currencyCurrency translation
Query Design (BEx Query Designer)Queries that are based on aggregation level are able to write back to the InfoProvider
BEx Web Application Designer Create a layout Configure a layout Choose data binding Configure interaction
www.solitairesoft.com
![Page 65: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/65.jpg)
Business Planning and Analytical Services – Run-time 2Web Application Design – Example
www.solitairesoft.com
![Page 66: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/66.jpg)
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Roadmap from BW to BI
Implementation Experience
www.solitairesoft.com
![Page 67: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/67.jpg)
Key Business Challenges
Ineffective Decision Making ProcessesDecisions delayed, or made on ‘gut feel’ onlyKey stakeholders not involvedSolid information only available to small ‘elite’
Execution not aligned with StrategyStrategy not communicated clearlyIndividual objectives not aligned with strategyPoor measurement, and no corrective actions
Increasingly Complex Operational EnvironmentLack of insight into customer behaviour and trendsOpportunities frequently missed
Compliance RequirementsCalls for transparencyIncreasing criticality of trustworthy data
Budget ConstraintsNeed to do more with less, and need to justify expenditures
![Page 68: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/68.jpg)
Business Advantage of NW2004s
• NW 2004s - Analytical Applications• Business actions based on informed decisions.
Ineffective Decision Making ProcessesDecisions delayed, or made on ‘gut feel’ onlyKey stakeholders not involvedSolid information only available to small ‘elite’
www.solitairesoft.com
![Page 69: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/69.jpg)
Business Advantage of NW2004s
• NW 2004s - Enterprise Data Warehousing• Truly scaleable solution• Supporting all BI needs of the organisation
Increasingly Complex Operational EnvironmentLack of insight into customer behaviour and trendsOpportunities frequently missed
www.solitairesoft.com
![Page 70: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/70.jpg)
Business Advantage of NW2004s
• NW 2004s - BI Accelerator• Truly scaleable solution• Lower administration cost• Consistent and quick user response
Budget ConstraintsNeed to do more with less, and need to justify expenditures
www.solitairesoft.com
![Page 71: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/71.jpg)
Business Advantage of NW2004s
• NW2004s - Integrated Planning• Integration platform for analysis and
planning. • Planning systematically delivered to all
levels of the organisation
Execution not aligned with StrategyStrategy not communicated clearlyIndividual objectives not aligned with strategyPoor measurement, and no corrective actions
www.solitairesoft.com
![Page 72: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/72.jpg)
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Roadmap from BW to BI
Implementation Experience
www.solitairesoft.com
![Page 73: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/73.jpg)
Deployment of BW
R/3 Reporting
Information delivery in mySAP solution Data Warehouse
where SAP is one of the ERP solution
Standalone Data Warehouse
Analytical Application
BI Complexity
SAP
Pene
trati
on
www.solitairesoft.com
![Page 74: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/74.jpg)
Multi-BusinessData Warehouse
Phased Roll Out
Business UnitData Warehouse
Subject SpecificData Mart
Size
Time
Think bigbut start small
www.solitairesoft.com
![Page 75: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/75.jpg)
Start small and fast
Scope of project
BW skill customer
Additional Subjectareas
ExtendingContent
External Data
BW Content
Delivery Cycles
Concepts
www.solitairesoft.com
![Page 76: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/76.jpg)
Rapid Implementation step by step• Selected subject area • Defined scope• Business Content as a basis for implementation• Minor but User-significant enhancements• Achieve the 80% solution and demonstrate results• Receive feedback
– Incorporate into subsequent delivery cycles• Rollout to other subject area (maybe in parallel)• Parallel work in frontend, extraction and datamodel team• Use the „power“ of BW
– Extend with external data sources– Combine information from different applications
www.solitairesoft.com
![Page 77: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/77.jpg)
Benefit of the Rapid Implementation
Rapid ROI / deliverable benefit to the business Establish positive view of the product within user base Establish stable technology infrastructure early in
project Transfer overall product knowledge to ensure
subsequent implementations are appropriately resourced
Train members of the implementation team
www.solitairesoft.com
![Page 78: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/78.jpg)
Suolution Manager & Accelerated BW Method & Tools
• Highest Level : Maps to ASAP• Lowest Level : Incorporates BW-Specific Activities / Accelerators
• Key Enablers : Included to Assist the Customer and Consultant• Evolving : Continually Being Refined and Enhanced by BW experts
in development and consulting
www.solitairesoft.com
![Page 79: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/79.jpg)
Skills• The skills required will be driven by the scope of the
implementation• Scope of Implementation
– Business Contents with minor enhancements?– Significant non-SAP data sources?– Enterprise Data Warehouse?
• Skills– BW Implementation experience– Operational users– SAP source knowledge – Data Warehousing architecture– BASIS / WAS knowledge
www.solitairesoft.com
![Page 80: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/80.jpg)
Project Team Structure
DW Architect
BW Solution Architects
BW Administrator
BusinessKey Users
BusinessKey Users
BusinessKey Users
IT BusinessPr
ojec
t Ma t
urity
www.solitairesoft.com
![Page 81: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/81.jpg)
Implementation Team - Mix of Resource
SAP/ Partner
Internal
Time
Consulting Effort
www.solitairesoft.com
![Page 82: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/82.jpg)
Key Success Factors• Management buy-in• Involve user community early in the project life
cycle• Strong implementation team
– Business understanding & empowerment– SAP skills– BW knowledge – DW skills
• Rapid, step-by-step, reiterative implementation– delivery cycle concept – early success– feedback
www.solitairesoft.com
![Page 83: Sap bw bi](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c6e58e4a795979608b45b7/html5/thumbnails/83.jpg)
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Roadmap from BW to BI
Implementation Experience
www.solitairesoft.com