Transcript 2004s

BI in SAP Netweaver 2004s
Features, Benefits, Upgrade Issues
Sergei Peleshuk
December 15, 2006
What We’ll Cover …
• Introduction to Netweaver 2004s
• What is New in Release 2004s
• Technical vs. Functional Application Upgrade
• Summary
2
Resources
• SAP TechED 2006, Amsterdam
 New BI Modeling Capabilities in SAP Netweaver 2004s
 Upgrade and Migration Aspects for BI in SAP Netweaver
2004s
Where
to
FIND it
• Dr. Bjarne Berg, MyITgroup Ltd.,
SAP Projects 2006, Orlando
 Creating an upgrade plan and strategy for SAP
NetWeaver 2004s
3
SAP NetWeaver: Big Picture
NetWeaver is a set of solution
components that provides a
comprehensive architecture.
Multichannel access
Portal
Collaboration
INFORMATION INTEGRATION
Bus.
Bus.Intelligence
Intelligence
Knowledge
Mgmt
Knowledge
Mgmt
Master Data Management
PROCESS INTEGRATION
Integration
Broker
Bus. Process
Mgmt
APPLICATION PLATFORM
J2EE
LIFE CYCLE MANAGEMENT
COMPOSITE APPLICATION FRAMEWORK
PEOPLE INTEGRATION
ABAP
DB and OS Abstraction
...
Source: SAP AG
All components of NetWeaver can use the same operating
system release, and the same database release.
All components can be run within a single physical server
if it is a small configuration, thereby reducing the number
of systems and databases to be managed.
4
Why Upgrade to NW 2004s?
One of the major reasons for upgrading your BW
environment is the availability of new content and features in
the next release, including:
 New modeling capabilities
 Web Application Designer
 BI Accellerator
 New BEx tools
 ReModeling Toolbox
 Security Changes
 New ETL Interface
 BPS Integrated Planning
 PDF print
 Real-time data warehousing
5
Why Upgrade – end of support…
BW
Ve rsio n
Re le ase
date
End o f mainstre am
mainte nanc e
2.0B
2.1C
3.0A
3.0B
3.1C
3.2
3.3
3.5
8/14/00
12/18/00
11/15/01
5/13/02
11/11/02
3/31/03
8/30/03
3/31/04
12/31/2005
12/31/2005
12/31/2005
12/31/2006
12/31/2006
12/31/2006
12/31/2006
3/31/2010
Many upgrades are driven by end of support for a certain release.
SAP has now created a 5-1-2 maintenance system that consists of:
- mainstream maintenance
- extended maintenance
- customer-specific maintenance
6
What We’ll Cover …
• Introduction to Netweaver 2004s
• What is New in Release 2004s
• Technical vs. Functional Application Upgrade
• Summary
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Benefits: Better interface for ETL Design
On a typical DW project, 40-60% of project effort will be spent
on data integration, transformation and loads (used to be
higher when tools were more immature).
SAP NetWeaver
2004s has a new
and better GUI and
formula editors to
write complex
transfer rules,
update rules and
data mapping.
28
29
30
31
Benefits: Real-time Data warehousing gets better
NW 2004s has more features for updates that does not follow the
typical asynchronomous (batch) updates. This include:
1. We can use XML to fill the PSA directly
2. Daemon-based update from delta queue (BW API)
3. Daemon-based update of the ODS and minimal logging
Note: XML documents creates
many tags that will slow down
large dataloads due to the size of
each XML record (relatively large)
However, it works great for
smaller streams of data.
32
33
BI Statistics in NW04s …
34
Business Explorer Suite
35
36
37
BEx Query Designer
38
Benefits: BEx Query Designer gets a needed ‘facelift’
The 3.5x BEx
Query Designer
This new property pane makes it
easier to format and control displays
than in the past.
The NW2004s BEx
Query Designer
Note:
39
BEx Analyzer
40
Benefits: BEx web Analyzer integrates Excel
The Excel integration in the BEx
analyzer is far better.
Source: SAP AG, 2006
Unlike the old days of dynamic
HTML, you can now use the BEx
analyzer more like a real
application without refreshing the
whole page every time you click
on something (this is due to the
Java component in NW2004s)
News: BEx browser
goes away in NW2004s
41
Benefits: Drag-and Drop in BeX web Analyzer
You can drag a
characteristics into a filter
area and automatically filter
on that value, and you can
also drag it into a column
header or a a row.
BEx web analyzer is a better user
tool than in the past. You now get
the best world of Java & the web
instead of the more ‘clunky’ user
experience related to Dynamic HTML
Building conditions and
activating them was often
confusing in earlier versions
and exception based
reporting was sometimes not
easy to create for beginning
users. NW2004s has now
simplified this with more
wizards that helps users to
build this step-by-step.
42
BEx Web Application Designer
43
Benefits: Web Application Designer gets better
The Web Application Designer is improved with new chart types (Heat Map, GANTT &
Milestone Trend Analysis), as well as new layout elements such as ‘tab strips’.
WAD also has new stepby-step wizards for maps,
command editing to
create Web API
Commands and charts, as
well as a simplified wizard
for layout elements such
as radio buttons, action
buttons etc.
This reduce the amount
of custom coding
required with the help of
Command wizards, Auto
complete and support for
HTML tags.
WAD is a key tool
for all SAP BI shops
and in NW2004s the
tool is simplified
and more powerful.
New: integration with
NW 2004s BEx Report
44
Designer.
45
Benefits: BEx Report Designer is here!!
This new tool was
created to simplify the
formatting of reports
and fix many of the
printing issues in
previous versions of
BW.
We now get color
control, header-footer
control and many new
features such as
location control of
cells and integration
of pictures, charts and
fixed text.
Source: SAP AG, 2006
Don't
Forget
For many, this tool may reduce the need for 3rd
party tools to address structured reports.
46
Benefits: New PDF Print
You can also use the PDF to create
reports based on BEx web
applications, queries and reports
using the Adobe DS (comes with
NW2004s).
The PDF options allows companies to
protect reports from changes by
employees by taking a ‘snapshot’ of the
data regardless of subsequent updates
to the data warehouse.
Risks: no link back to SAP BW is needed
and security is not validated.
The only Gotchas.. Your users now
need to install Acrobat Reader
(free at http://www.adobe.com/
products/acrobat/readstep2.html).
The PDF document can also be
Broadcasted through BEx
Broadcaster
47
Benefits: BI Accellerator for 2004s
SAP
BW
The SAP BI accelerator
makes query response
time 50-10,000 faster.
You use process
chains to maintain the
HPA engine after each
data load
Any
tool
Analytic
Engine
InfoCubes
HPA Engine/Adaptive Computing
Data
Acquisition
SAP NW 2004s BI
Both HP and IBM have standard solutions
ranging from $32K to $200K+ that can be
installed and tested in as little as 2-4 weeks
1. In-memory processing
2. Dictionary-based, smart
compression using integers
3. High parallel data access /
horizontal partitioning
4. Column-based data storage &
access/vertical table decomposition
48
Better security features
There are many new security features in NW
2004s, and a conversion is needed (all or
nothing).
Role menus are displayed in the portal and
passwords becomes case sensitive.
Authorizations are
fundamental building
blocks of the new
reporting concept and
security contains both
the data value and
hierarchy restrictions.
The new security can be
built using new
“RSECADMIN”
transaction
Source: SAP AG
ASUG Security Upgrade by Eric Dwyer, Nike: http://www.asug.com/client_files/Calendar/Upload/EA1_upgrade_bw_security_2.ppt
49
Upgrading to NW2004s Security
SAP has created an ABAP migration tool to help you upgrade security in
NW 2004s. To access it, goto transaction code SA38, and execute
migration program RSEC_MIGRATION.
About 80% of you security setup is expected to make it using this tool.
i.e. customer exit variables for the object 0TCTAUTHH does not migrate,
and you will have to manually reassign all hierarchy nodes.
While you upgrade, the old security is left intact and you can switch
back if absolutely needed (IMG setting). Plan to test…test..and test…
More Great Details about
the Security Upgrade at :
http://csc-studentweb.lrc.edu/
swp/Berg/Articles/
2004S_Authorizations.pdf
(Source: Amelia Lo, SAP)
50
BPS Integrated Planning
1
InfoProvider
2
3
4
Aggregation Level
Filter
Planning Function
5
Planning Sequence
6
Pattern
You can now create planning templates using the web based planning wizard to create
models using patterns in the data (tool: “Road map Pattern”). Queries based on
aggregation levels can now also write back to the InfoProvider
51
Source: SAP AG, 2006
What We’ll Cover …
• Introduction to Netweaver 2004s
• What is New in Release 2004s
• Technical vs. Functional Application Upgrade
• Summary
52
Technical vs. Functional Upgrade
• Technical Upgrade
 Copying 3.x functionality “as is” to the NW04s platform
• Functional Upgrade = Migration
 Step by step process
 Analyze what is needed from the new functionality for each
service
 Implement new functionality (NW04s)
53
Technical Upgrade
54
55
56
57
58
Some hints on the upgrade - Unicode conversion
G
o
o
d
Unicode has been available since BW version 3.5.1. and is now
highly recommended as part of the upgrade (hint web application
T
h
i
n
g
designer is now also unicode compliant).
Some things to remember and plan for:
Area
Memory
Processing power
Disk space
‫ﻲﻶﻺﻕﻒﻏﻎ‬
Recommended increased capacity
20%
20-25%
20-30%
‫תשרחפא‬
59
What We’ll Cover …
• Introduction to Netweaver 2004s
• What is New in Release 2004s
• Technical vs. Functional Application Upgrade
• Summary
60
61
62