Transcript Presentation -- Increase the Success of your BW by 70%

100%
[email protected]
Increase BW success by
70%
Hari Guleria
icm AMERICA
Your assurance to success – partner with experience
www.icmamerica.com
Brief on icm
•
•
•
100%
19 offices in Europe and US with over 500 employees
100% senior SAP resources
BW TRACK RECORD
–
–
–
–
–
Ranked # 5 globally for BW implementations
21 BW Projects completed
16 BW projects underway
FPS partner in 3.0x (have 3.0A since Oct 2001, 3.0B since June 2002)
2 icm employees on SAP AG BW Development board
•COMPANY TRACK RECORD
Area
Projects Completed
 APO
03
 SEM
02
 eBusiness
10
 CRM
02
 SAP Implementations
176
[email protected]
Area
Projects Completed
Upgrades
100
Data Archiving
68
 BW
21
 RBE/CBI
36
 System Mergers
07
Your assurance to success – partner with experience
www.icmamerica.com
100%
SAP Reporting Options
Plan your work
& work your plan
Strategic
Third Party
Tools and
Applications
Tactical
Middle Mgmt
Functional Areas
Information Systems
LIS-COPA-FSL
Operational
Transactions + Operations
R/3
ABAP Query,
Report Painter/Writer
“Canned” R/3 Reports
[email protected]
R/3
Your assurance to success – partner with experience
www.icmamerica.com
Custom ABAP Reports
Top Mgmt
C/VP Level
Business
Information
Warehouse
(BW)
Where we are
100%
• Start: PLAN Reporting & Analytics
N
o
t
e
• The Business Reason
• The success factors in BW implementations
• Data Modeling
Data design selections
[email protected]
• End: REPORTING - Queries and Analytics
Your assurance to success – partner with experience
www.icmamerica.com
Primary Reason
100%
Key
Feature
Queries and Analytics
• Every DW is initiated for reports, analytics and/or as a data repository.
• With reports as the end, only a planned beginning can assure success
• To ensure successful Reports and Analytics from the BW we must:
[email protected]
 Collect and document all Reports/ Analytic requirements
 Model all requirements by source and computations
 The modeling phase must isolate 90% of issues and gaps
 Then deliver the required reports and analytics
Reporting
v/s
MIS
Timers
Memory
RAM
Chips
Contract
Direct
Disti
Your assurance to success – partner with experience
www.icmamerica.com
Sample Business Reasons
100%
 Supply chain informatics
 Accurate PO and Vendor information (info)
 Accurate Production capacity, output, rejections and shipment info
 Customer and material reporting
 Consolidated customer and material info across companies and regions
 Margin analytics by selection
 Margin by total company, partner companies, regions, sales offices, materials, customer and material groups, etc
 Accurate up to date and online stock information
 Material and valuation from every partner storage location
 Tactical and Strategic information
[email protected]
 Competitive analytics by market segments and regions
 Service offering trends and projections and their impact on Operations
Your assurance to success – partner with experience
www.icmamerica.com
BW 3.0x options and ROI
APO
SEM
CRM
BW
DW
100%
Upward Integration
BW 3.0x
Pure WEB
Query
Designer
CAPTURE
[email protected]
Downward Integration
SAP
Non SAP
Legacy
Your assurance to success – partner with experience
www.icmamerica.com
Where we are
100%
• Start: PLAN Reporting & Analytics
• The Business Reason
• The success factors in BW implementations
• Data Modeling
N
o
t
e
Data design selections
[email protected]
• End: REPORTING - Queries and Analytics
Your assurance to success – partner with experience
www.icmamerica.com
100%
The 7 Steps of success (SF*)
5 reasons contribute to 70% of the success
of all data warehouse projects. 2 the balance 30%
1.
2.
3.
4.
5.
1.
From a Workshops to a Pilot ‘Proof of Concept’
Conduct detailed Multi-dimensional data-modeling
Plan your Reports and Analytics
Experienced Partner selection
Planned procedures, documentation and knowledge transfer
[email protected]
6.
7.
Define Business Reasons
Proven Methodology
Implement POC / CRP
* SF = Success Factor
Your assurance to success – partner with experience
www.icmamerica.com
100%
SF 1 – Methodology
30%
Modeling
DW Best Practice
(Ralf Kimball)
70%
BW Best Practice
Construction
5%
15%
10%
50%
20%
Data Modeling
Construction
Other
Report & Analytics
[email protected]
Report Gathering
* SF = Success Factor
Your assurance to success – partner with experience
www.icmamerica.com
100%
SF 1 – Methodology II
S
o
l
u
t
i
o
n
• Collect Reports and document
Reports Track
KPI’s
 Current reports from production systems with ID
 Reports being generated off-line with ID
 Wish List reports not yet generated
• Code and track Report requirements
• Define and plan Dimensions, Characteristics,
Attributes, and ‘Key Performance Indicators’
• Map Data-Flow
40B > 46C1
DRM
FI
SD
Consolidated
DRM
Base
FI
Base
SD
Detailed
DRM
[email protected]
PSA
Building Block
* SF = Success Factor
Your assurance to success – partner with experience
www.icmamerica.com
MM
Base
MM
SF 1.2 – Proof of Concept
100%
• Must be followed after a overview understanding of BW functionalities, i.e. in
workshops
• Also known as CRP ‘Conference Room Pilot’ demonstration –
• WHY is this important
[email protected]
 Essential for end-users to understand the functionalities and limitations of BW
 Imperative for answering data-modeling questions for designing the BW
 Imperative for defining KPI’s, Calculations, formulae, change data management, etc
* SF = Success Factor
Your assurance to success – partner with experience
www.icmamerica.com
Where we are
100%
• Start: PLAN Reporting & Analytics
• The Business Reason
• The success factors in BW implementations
• Data Modeling
Data design selections
N
o
t
e
[email protected]
• End: REPORTING - Queries and Analytics
Your assurance to success – partner with experience
www.icmamerica.com
Data modeling
100%
..without a
clear goal at
the end of design
InfoCube
[email protected]
beginning
the design phase
becomes
Totally redundant..
* DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
100%
Work Plan
[email protected]
Company 1 70:30
 1 week gathering all reports
 2 weeks coding the reports
 1 week defining business drivers
 1 week defining KPI’s
 2 weeks data modeling
 5 weeks constructing
 1 week debugging
 4 weeks reporting
 Company 2 10:90
 2 weeks gathering reports
 Little coding
 Assumed business drivers
 Assumed KPI’s
 ½ day data modeling
 5 weeks constructing
 1 week debugging
 2 week reconstructing
 3 days debugging
 2 week reconstructing
 3 days debugging
 2 week reconstructing
 2 days debugging
 4 weeks reconstructing
 ……
* DM – Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
Reports and Analytics
100%
• 2 primary reason’s for every BW
(1) Reports and Analytics,
(2) End User
• Do not ever forget the End User, they are the key to the success of
every BW. Involve them
• No single OLAP tool will ever meet all end-user requirements.
[email protected]
– Start with BEx as the beginning tool
– Analyze vendors on differentiating factors (Requirement v/s how each
product compliments BEx)
* DM – Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
100%
Delivered v/s Customization

BW Resource Planning
 Data Modeling requirement
100%
Hi usage
Low usage
[email protected]
Delivered
Business
Content
Extension
Custom
Cubes
The higher the customization
higher is the Data modeling
requirement
DM = Data Modeling
Delivered
Business
Content
Extension
Custom
Cubes
The higher the customization
higher is the technical resource
requirement
Your assurance to success – partner with experience
www.icmamerica.com
100%
BW Information Architecture
Analytics
via the web
WEB
ODS
Query
InfoCube
Multi-Cube
External
Source
ODS Object
InfoCube
Simple
Query
RemoteCube
MultiCube
Query
Jump Queries
Drill Through
[email protected]
OLTP – SAP R/3
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
100%
BW Snowflake Star-Schema
Master
Master
SID Table
Text
SID Table
Master
Text
Hierarchy
Text
SID Table
Hierarchy
Master
SID Table
Hierarchy
DISTI
Master
SID Table
Text
Material
Hierarchy
[email protected]
Hierarchy
Master
Text
Hierarchy
SID Table
Hierarchy
Master
Text
Finance
FACT
Sales Area
SID Table
Text
SID Table
Hierarchy
Master
Text
SID Table
Hierarchy
Master
Text
Customers
SID Table
Hierarchy
Master
Text
SID Table
Hierarchy
Master
Text
Big Leap = 13 Dimensions = x Dimensions
Each DIM can take 248 Characteristics = Dimensions
Total Dimensions possible in BW = 13 x 248 = 3,224
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
100%
ERM
Material group
Customer
Customer no
Customer name
City
Region
Material group no
Material group name
....
Material
Material no
Material name
Material type
 color
 price
Sales Department
Sales dep. no
Sales dep. location
.......
Sales Person
Sales pers. no
Sales pers. name
.......
Sales Transaction
[email protected]
Date
Customer no
Material no
Sales pers no
Amount
Quantity
Currency
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
100%
ERM > Star Schema
Material Group
Sales Dept. Loc.
Region
Color
City
Sales Dept.
Material Type
Sales Person
Material
Customer
Price
Sales order
Customer
Ides Gmbh
Street
SalesPers
SalesRegion
Meier
Material
Unit
Date
Date
Monitor
981118
Sales Rep ID
Material ID
LastName
SalesDep
Material Name
Material Type
Material Group
Sales Org Dimension
Customer SalesPers Material Date
Ides Gmbh
Meier
Monitor
981118
Amount Quantity
1000
2
Customer ID
[email protected]
Customer Name
City
Region
Office Name
Plan
Granularity
DM = Data Modeling
Material ID
Sales Rep ID
Time Code ID
Customer ID
Sales Amount
Quantity
Unit Price
FACT
Material Dimension
Time Code ID
Year
Fiscal Year
Quater
Mounth
Day of the Week
?
Customer Dimension
Time Dimension
Your assurance to success – partner with experience
www.icmamerica.com
DM-2 __ Star Schema >
InfoCube
Sales Rep ID
Material ID
LastName
SalesDep
Material Name
Material Type
Material Group
100%
Sales Org Dimension
Material Dimension
Customer ID
Customer Name
City
Region
Office Name
Material ID
Sales Rep ID
Time Code ID
Customer ID
Sales Amount
Quantity
Unit Price
FACT
Customer Dimension
MDM/ Star Schema
Time Code ID
Year
Fiscal Year
Quater
SalesRep IDMounth
Day of the Week
Last Name
OrgStr. DIM ID
...
Time Dimension
SalesRep
SalesDep
SalesDep ID
SAP BW
Material DIM ID
Material ID
Material ID
MatType
Mat.description
MatType
...
Address
...
[email protected]
Material DIM ID
OrgStr DIM ID
Time Code ID
....
Quantity
.....
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
Plan & Strategize
100%
• Change of data management, I.e. Customer in Region 1 goes to region 2 in
the future
• Dimensions, Characteristics, and attribute relationships – and their multidimensional relationships
• SID table functionalities and plans, I.e. time dependant or not
• Other
[email protected]
 Hierarchies, Partitioning & Compression, Navigation Attributes, Variables,
Reporting alternatives, etc
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
100%
Trade offs

v/s space, access speed
Tip
v/s speed
v/s no detail
v/s single point of access
v/s random growth and confusion
v/s historical access
v/s loss of uniqueness
v/s all above
v/s fire-fighting
[email protected]








Granularity (detail)
Navigation Attributes (ease)
Aggregation (speed/ease)
Partitioning (segregation)
Design (planned)
Archiving (space)
Compounding objects (identity)
Performance (easy of use)
Roll-up Planning (planned)
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
Where we are
•
•
•
•
•
100%
Start: PLAN Reporting & Analytics
The Business Reason
The success factors in BW implementations
Importance of Data Modeling
Data Modeling
Data design selections
• End: REPORTING - Queries and Analytics
[email protected]
N
o
t
e
Your assurance to success – partner with experience
www.icmamerica.com
100%
Design Criterion – 1
Rules of changes
Option 2:
Option 1:
Security
MultiCube
Checks
&
Data
Validation
MultiCube
InfoCube
InfoCube
MultiCube
InfoCube
CLEAN
Business Rules
Option 3:
ODS
ODS
ODS
Business Rules
Business Rules
ODS
ODS
Tip
ODS
Business Rules
Business Rules
PSA
PSA
Business Rules
PSA
[email protected]
Business Rules (dev)
SS1
SS2
SS1
SS2
SS1
DM = Data Modeling
Your assurance to success – partner with experience
www.icmamerica.com
SS2
Where we are
[email protected]
•
•
•
•
•
100%
Start: PLAN Reporting & Analytics
The Business Reason
The success factors in BW implementations
Importance of Data Modeling
Data Modeling
Data design selections
• End: REPORTING Queries and Analytics
N
o
t
e
Your assurance to success – partner with experience
www.icmamerica.com
Reporting Options
100%
 Standard BEx (modified MS Excel)
• Approved BW OLAP vendors
1.
Integrating reports in the SAP Portal system:
– mySAP Workplace (now SAP Portal): Drag &
Relate, MiniApps
2.
Running reports against the
SAP Business Information Warehouse (BW):
– SAP BW: ODBO/BAPI*
3.
Running reports against
SAP, and non SAP sources:
[email protected]
– SAP R/3: RFC/BAPI**/ conversions
Your assurance to success – partner with experience
www.icmamerica.com
100%
OLAP Vendors
VENDOR Product
SAP R/3 BW
Other

SAP
arcplan
BEx
dynaSight
Brio
Business Objects
Cognos
Comshare Decision
Crystal Decisions
ESRI
IBI
MIS
SAS
Viador
Brio Report, Query
Bus Query, WebIntell
Power Play, Visualizer

Enterprise, analysis
Connect
WebFOCUS
Alea, OnVision
Enterprise Guide
E-Portal Suite
















[email protected]

Your assurance to success – partner with experience
www.icmamerica.com
100%
OLAP Vendors – S&W
[email protected]
VENDORS
Strengths
Weaknesses
B Ex
• The greatest OLAP tool to start with
• Uses an extended Microsoft Excel front end that need little training
• MS Excel limited reporting
• Limited Graphical and MIS capabilities
arcplan
• Large European Operation
•ONLY MIS Analytics supplier
• Integration with BAPI and ODBO
• Integration with SAP Business Intelligence
• Integration with R/3/ BW / SEM for write-back
• Limited reporting and ad-hoc analysis
• Low visibility in the US
Brio
Technologies
• Operational reporting for R/3
• Usability of Brio Enterprise for manipulating and formatting
• Separate product for SAP and BW
•Limited Interactive analysis with BW
Business
Objects
• Integrated reporting & analysis
• Specialized Query interface
• Publishing information to users
•Outdated rapid deployment template for SAP
• Additional cost for BusinessQuery
• No R/3 reporting capabilities
Cognos
• Complete ETL, mart, tool
• Strong reporting and mobile abilities
• Good visualization and customization
•Limited reporting via PowerPlay
• External Catalogs/mart needed for reporting
• External marts needed for applications
Crystal
Decisions
• Integration – Workplace, BW, R/3
• Operational and BW Reporting
• Totally supported and integrated with SAP, strategic partner with BW
• Minimal direct sales and consulting presence
• Limited interactive analysis for BW
Information
Builders
• Operational and BW reporting
• I-vision solutions for R/3
• Scalability and performance
• Limited ad-hoc reporting
• Lack of usability for interactive report analysis
Your assurance to success – partner with experience
www.icmamerica.com
[email protected]
OLAP Vendors – Analysis
100%
Your assurance to success – partner with experience
www.icmamerica.com
100%
InfoCube to Query Relationship – 1
Use this section to drag & drop restrict / selection of data. For example, if you want to only
view Tracking Partner 1062 you would drag Tracking partner here, right click on the object and
click on the [Restrict] selection. Next you would select tracking partner 1062. This will ensure
that THIS query only filters data of Track Partner 1062.
This section fills the
Rows headers for the
Excel BEx.
This section fills the Column
headers for the Excel BEx.
This section will provide a
preview of the design that the
query will take as objects are
attached on to the Query design
template.
The only sections that will
impact this design is the ‘Rows’
and ‘Columns’ selections
[email protected]
This
section
displays the
Cube design and
displays
all the selections
available
from the cube
for the
query / analytics.
use to resort and
recalculate the data along
defined parameters. For
example
drag Material
here to enable analysis
along Material selection.
End-User Doc
Your assurance to success – partner with experience
www.icmamerica.com
100%
What a BEx Report contains
[email protected]
W
h
e
r
e
t
o
F
I
N
D
i
t
Your assurance to success – partner with experience
www.icmamerica.com
100%
REPORT 1 – BEx Query A
D Available Stock
EURO
ASIA
MIDEST
JP
USA
GER
JP
GER
EURO
ASIA
MIDEST
[email protected]
USA
Your assurance to success – partner with experience
www.icmamerica.com
100%
REPORT 2 – BEx Query B
D Available Stock
1200000
1000000
800000
600000
D Available Stock
400000
200000
L
O
P
SY
N
VE
TO
TA
SE
R
NE
T
O
N
T
US
AM
LO
C
[email protected]
PA
R
eDI
ST
IN
SI
TE
ET
AV
N
W
YL
E
0
Your assurance to success – partner with experience
www.icmamerica.com
REPORT 3 – Enhanced MIS
100%
Timers
Memory
RAM
Chips
[email protected]
Contract
Direct
Disti
Great
Feature
Your assurance to success – partner with experience
www.icmamerica.com
Takeaways
100%
[email protected]
Don't
Forget
• PLAN YOUR WORK AND THEN ONLY WORK YOUR PLAN
• Follow tried methodologies, and proven templates
 Define Business Content
 Gather Reports and Analytics requirements
}
 Implement Proof of Concept
 Commence Data Modeling
 Partner with an experience
 Get Steering committee approval on reports and models
 Get USER commitment on reports and expectations
 Construct and Configure the BW
 Select OLAP tools and options
 GO Live
 Post go Live plan and work
Your assurance to success – partner with experience
(do not try and reinvent the wheel)
20%
40-50%
www.icmamerica.com
1 slide to tell it all
100%
[email protected]
plan it,
understand it,
schedule it,
manage it
Your assurance to success – partner with experience
www.icmamerica.com
Your Turn
100%
Q
u
e
s
t
i
o
n
s
?
Hari Guleria
icm AMERICA
[email protected]
[email protected]
Mobile:(408) 835-9552
Off: (610) 647-9000 ext 4835
www.icmamerica.com
Your assurance to success – partner with experience
www.icmamerica.com
Questionnaire format
Name
Desig.
Tel
Email
Company
City
Address
City
State
ZIP
R/3 Ver
BW Ver
BW Since
InfoAreas
Upgrade/New Plans
Approx
month/yr
100%
[email protected]
Question:
Email: [email protected]
Fax: 610.647.9177
Your assurance to success – partner with experience
www.icmamerica.com