sap business intelligence adoption v7.41:software and delivery
TRANSCRIPT
SAP Business Intelligence Adoption
August 2015
English
SAP Business Intelligence Adoption V7.41:Software and Delivery Requirements
SAP SE Dietmar-Hopp-Allee 16 69190 Walldorf Germany
Document Revisions Date
0 6/26/2015
1
2
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 2 of 20
Copyright
© 2015 SAP SE or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE. The information contained herein may be changed without prior notice.
Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.
National product specifications may vary.
These materials are provided by SAP SE and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany and other countries. Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 3 of 20
Icons
Icon Meaning
Caution
Example
Note
Recommendation
Syntax
External Process
Business Process Alternative/Decision Choice
Typographic Conventions
Type Style Description
Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.
Cross-references to other documentation.
Example text
Emphasized words or phrases in body text, titles of graphics and tables.
EXAMPLE TEXT
Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.
Example
text
Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.
EXAMPLE TEXT Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.
Example
text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.
<Example
text> Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 4 of 20
Table of Contents Contents
1 Purpose of the Document .............................................................................................................. 5
2 General Project Prerequisites ....................................................................................................... 5
3 Technical Requirements ................................................................................................................ 5
3.1 Software Product Versions.................................................................................................. 6
3.1.1 Software Product Versions for ERP Core via SAP Business Warehouse, Track Analytics Data, ERP Operational Data Provisioning ..................................................................... 7
3.1.2 Software Product Versions for CRM Analytics ............................................................... 8
3.1.3 Software Product Versions for Trade Promotion Effectiveness ..................................... 9
3.1.4 Software Product Versions for Operational Analytics for Non-SAP ............................. 11
3.2 SAP Notes ......................................................................................................................... 11
3.3 SAP Solution Manager and SAP Solution Manager Content Add-On .............................. 12
3.4 Software Landscape Diagram ........................................................................................... 13
3.4.1 Solution for ERP Core via SAP Business Warehouse, Track Analytics Data, ERP Operational Data Provisioning..................................................................................................... 13
3.4.2 Solution for BW on HANA ............................................................................................. 17
3.4.3 Solution for BI within CRM Analytics ............................................................................ 18
3.4.4 Solution for BI within Trade Promotion Effectiveness Analytics ................................... 19
3.4.5 Solution for Operational Analytics non-SAP Scenario .................................................. 20
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 5 of 20
1 Purpose of the Document This document contains information to:
Validate that key prerequisites such as software products and versions match the customer situation
Check that all prerequisites for a customer implementation are in place
Check that correct content, tools and skills are in place before the project starts
The document lists different kinds of requirements on package level if they are valid for all scope items included in the package. For requirements valid for certain scope items only, these scope items are mentioned.
The document contains pre-requisites only, not the procedures to meet them. For how-to information (e.g. how to find the download area) please refer to the configuration guides.
2 General Project Prerequisites The following prerequisites need to be in place before an implementation project can start.
Prerequisite Responsibility
Kick off and workshop dates, location and attendees agreed Customer
Customer team allocated with correct skills and training in place Customer
Project sponsors and stakeholder identified Customer
Hardware fully commissioned Customer
Software licenses in place Customer
Infrastructure team can respond to requests quickly enough e.g. CSS notes, BW content, patches, user requests, authorization changes and transports
Customer
User interfaces agreed e.g. SAPGUI, Netweaver Business Client or Portal
Customer
Remote access is in place for SAP consultants and SAP Active Global Support
Customer
Decision made whether pre-assembled delivery will be used Customer
Decision made whether SAP Best Practices Solution Builder will be used to activate content.
Customer
Decision made whether Solution Manager will be used. Solution Manager set up with any relevant templates.
Customer
Tool for project repository and collaboration agreed Customer
Test management tool agreed Customer
3 Technical Requirements This section contains technical requirements in different areas. For each requirement, the relevance for scope items of the package is provided.
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 6 of 20
3.1 Software Product Versions The following software products and versions are required:
The table lists all software required to implement the whole scope of this solution. Customer should adopt the applicable software according to their actual landscape and business scope. This rapid deployment solution delivered the following scope items:
Business Intelligence Analytics for ERP Core via SAP Business Warehouse (Purchasing, Manufacturing, Sales, Finance, HCM, Executive Analytics)
B05 CEO Executive Analytics
B07 Sales Analytics
B49 Financial Analytics
B53 Purchasing Analytics
B55 Manufacturing Analytics
D02 Human Capital Management Analytics
Track Analytics Data in SAP Business Warehouse
BY4 Data Reconciliation for SAP BW
BY5 Data Availability for SAP BW
BY6 Data Lineage for SAP BW
Business Intelligence Analytics with ERP Operational Data Provisioning
BY7 Finance Operational Analytics with ODP
BY8 Sales Operational Analytics with ODP
BY9 Purchasing Operational Analytics with ODP
Business Intelligence Analytics for CRM
CR3 CRM Marketing Analysis
CR4 CRM ERP Integrated Sales Analysis
CR5 CRM Standalone Sales Analysis
CR6 CRM Service Analysis
VB6 CRM Sales Analysis for BI Platform
Business Intelligence Analytics for Trade Promotion Effectiveness (Industry specific) EA7 Account Pre/Post Evaluation
EA8 Promotion Pre/Post Evaluation
EA9 Funds Analysis
Operational Analytics non-SAP DJ9 Operational Analytics non-SAP
Very Important: Don’t use solution manager to implement this RDS. Solution manager is not required to implement this RDS
Although this RDS also released solution manager content as well, please don’t use solution manager template for implementation. In our solution manager template, we just define the reference link to each configuration guide word document. We didn't deliver any automatically deployment content in solution manager template.
To implement this RDS, Please refer to SAP note 2116268 and follow all the manual configuration steps
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 7 of 20
3.1.1 Software Product Versions for ERP Core via SAP Business Warehouse, Track Analytics Data, ERP Operational Data Provisioning
The following software products and versions are required:
Product Product Version
Components SAP Solution Manager Logical Component
Comments Relevance
SAP ERP EHP6 FOR SAP ERP 6.0 SP13
SAP ERP 6.06 Application Server ABAP
SAP_APPL 606 SP11
SAP_BW 731 SP13
BI CONT 747 SP10
If you use ERP Operational Reporting on ODP scenario, you have to use EHP6. If you don’t use BI reporting on ODP, it is not necessary to upgrade into EHP6, the following components are not necessary as well:
SAP_BW 731 SP11
BI CONT 747 SP10
Required by B05 B07 B49 B53 B55 D02 BY4 BY5 BY6 BY7 BY8 BY9
SAP NETWEAVER
EHP1 For SAP NETWEAVER 7.3, SP13
SAP_BASIS 731 SP13
SAP_ABA 731 SP13
PI_BASIS 731 SP13
SAP_BW 731 SP13
BI_CONT 747 SP10
BP-BW 731V7
SAP NETWEAVER 7.4, SP05 is also supported:
SAP_BASIS 740 SP08
SAP_ABA 740 SP08
PI_BASIS 740 SP08
SAP_BW 740 SP08
BI_CONT 747 SP08 or above
BP-BW 731V7
Required by B05 B07 B49 B53 B55 D02 BY4 BY5 BY6
Trigger-Based Replication Using SAP LT
SAP LT Replication Server
Not applicable Check note 1605140 to get exact DMIS component version according to ERP version and SAP HANA version
Refer to the SAP HANA Enterprise 1.0 Installation Guide: Installing Trigger-Based Replication on the SAP Service Marketplace at http://support.sap.com/hana
Only necessary for some reports built upon BW on HANA or HANA in B05,B07,B49,B53
SAP HANA PLATFORM EDITION
SAP HANA PLATFORM EDITION 1.0 SPS09 or above
SAP HANA DATABASE
Only necessary for some reports built upon BW on HANA or HANA in B05,B07,B49,B53, B55
Only necessary for some reports built upon BW on HANA or HANA in B05,B07,B49,B53, B55
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 8 of 20
SBOP BI PLATFORM
SBOP BI PLATFORM 4.1 SP05 or above
Required by B05 B07 B49 B53 B55 D02 BY4 BY5 BY6 BY7 BY8 BY9
Required by B05 B07 B49 B53 B55 D02 BY4 BY5 BY6 BY7 BY8 BY9
SBOP EXPLORER
SBOP EXPLORER 4.1 SP05
Required by B49 B07 Required by B49 B07
Client Reporting Tools:
Product Product Version Component Comments
SBOP DESIGN STUDIO
SBOP DESIGN STUDIO 1.4 or later
DESIGN STUDIO BIP ADD ON 1.4 or later
DESIGN STUDIO CLIENT 1.4 or later
DESIGN STUDIO BIP ADD ON is installed with SBOP BI PLATFORM
SBOP DASHBOARDS
SBOP DASHBOARDS 4.1 SP05
Not applicable
SAP Crystal Reports for Enterprise
SAP Crystal Reports for Enterprise 4.1SP05
Not applicable
SAP LUMIRA SAP LUMIRA 1.0 SP19 or higher
Not applicable
Please choose the client tools according to your selected report scope
Optional Software: (You need to install in case of mobile support for BI reports)
Product Product Version Component Comments
IOS (Optional) 5.0 or above Not applicable
SAP BusinessObjects Mobile for iPad (Optional)
4.1.0 or above Not applicable
SAP BusinessObjects Experience for iPhone/iPad (Optional)
4.0.3 or above Not applicable
3.1.2 Software Product Versions for CRM Analytics The following software products and versions are required:
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 9 of 20
Product Product Version
Components SAP Solution Manager Logical Component
Comments Relevance
SAP ERP EHP6 FOR SAP ERP 6.0 SP11
SAP ERP 6.06 Application Server ABAP
SAP_APPL 606 SP11
SAP_BW 731 SP11
BI CONT 747 SP08
Required by CR4 CR6
SAP NETWEAVER
EHP1 For SAP NETWEAVER 7.3, SP13
SAP_BASIS 731 SP13
SAP_ABA 731 SP13
PI_BASIS 731 SP13
SAP_BW 731 SP13
BI_CONT 747 SP10
BP-BW 731V7
SAP NETWEAVER 7.4, SP05 is also supported:
SAP_BASIS 740 SP08
SAP_ABA 740 SP08
PI_BASIS 740 SP08
SAP_BW 740 SP08
BI_CONT 747 SP08 or above
BP-BW 731V7
Required by CR3 CR4 CR5 CR6 VB6
SBOP BI PLATFORM
SBOP BI PLATFORM 4.1 SP05
VB6
SAP CRM EHP1 FOR SAP CRM 7.0 or above
CRM Application Server ABAP
CR3 CR4 CR5 CR6 VB6
SAP NETWEAVER
EHP1 For SAP NETWEAVER 7.3, SP13 BI Java
CR3 CR4 CR5 CR6
Client Reporting Tools:
Product Product Version Component Comments
SBOP DASHBOARDS
SBOP DASHBOARDS 4.1 SP05
Not applicable
3.1.3 Software Product Versions for Trade Promotion Effectiveness
The following software products and versions are required:
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 10 of 20
Product Product Version
Components SAP Solution Manager Logical Component
Comments Relevance
SAP CRM SAP EHP1 for SAP CRM 7.0 SP07 or above
CRM Application Server ABAP/CRM Application Server Java/WebClient UI
Trade Promotion Management functionality must be implemented
SAP TRADE PROMOTION PLNG
SAP TRADE PROMOTION PLNG 2.0 or above
CRM Add-on
This is an optional product for this solution.
SAP NETWEAVER
EHP1 For SAP NETWEAVER 7.3, SP13
SAP_BASIS 731 SP13
SAP_ABA 731 SP13
PI_BASIS 731 SP13
SAP_BW 731 SP13
BI_CONT 747 SP10
BP-BW 731V7
SAP HANA PLATFORM EDITION
SAP HANA PLATFORM EDITION 1.0 SPS09 or above
SAP HANA DATABASE
SAP ERP SAP EHP5 for SAP ERP 6.0 SP08 or above
ERP ABAP Server: Central Application/ABAP Technology for ERP EHP5/Financial Services (COPA) /Sales (SD)
SBOP BI PLATFORM
SBOP BI PLATFORM 4.1 SP05
Central Management Console
Lifecycle management console
SBOP DESIGN
SBOP DESIGN
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 11 of 20
STUDIO STUDIO 1.4 or later
3.1.4 Software Product Versions for Operational Analytics for Non-SAP
Product Product Version
Components SAP Solution Manager Logical Component
Comments Relevance
SAP Sybase IQ
SAP Sybase IQ 15.4
SAP PowerDesigner
SAP PowerDesigner 16.5
Optional
SAP Lumira, desktop edition
SAP Lumira 1.0 sp25 or higher, desktop editon
SAP Lumira, server version for teams
SAP Lumira 1.0 sp25 or higher, server version for teams
Optional
3.2 SAP Notes The following SAP Notes need to be considered:
SAP Note No
Content Comments Relevance
2116268 This SAP Note contains critical information for implementing SAP Business Intelligence Adoption Rapid Deployment Solution, which are the basis for the system pre-configuration related to SAP Business Intelligence Adoption Rapid Deployment Solution.
Before you start the activation of the related SAP Best Practices scope, check the latest versions of this SAP Note.
All Scope Items
1824688 The texts of variables are not displayed in Variable Screen during query execution. The technical names of the
If you are using BW 7.31 SP06 or SP07
All Scope Items
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 12 of 20
variables are presented. The texts of structure members (formulas) are not displayed in query results.
1788145 When you execute a query and call the varaible screen the currency results are displayed as '*'. This happens in 730 and 731
All Scope Items
1752626 When you execute a query on an InfoCube, an exception occurs due to the use of a key figure that cannot be aggregated (aggregation type = "no aggregation"). The query can be executed in a similar way using a BW query, the RSDRI read interface or using transaction LISTCUBE. In all three cases, the error may occur.
If you are using BW on HANA.
All Scope Items
2116268 This SAP Note contains critical information for implementing SAP Business Intelligence Adoption Rapid Deployment Solution, which are the basis for the system pre-configuration related to SAP Business Intelligence Adoption Rapid Deployment Solution.
Before you start the activation of the related SAP Best Practices scope, check the latest versions of this SAP Note.
All Scope Items
3.3 SAP Solution Manager and SAP Solution Manager Content Add-On
Please note this chapter is optional for your reference in SAP Business Intelligence Adoption rapid deployment solution. For the implementation of the solution package, SAP Solution Manager is recommended.
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 13 of 20
Product Product Version Comments
SAP Solution Manager SAP Solution Manager 7.0 Enhancement Package 1
SP18 or higher
- Or -
SAP Solution Manager 7.1
SP01 or higher
- Or -
SAP Solution Manager 7.1 on HANA (ST 712)
SP00 or higher
If using SAP Solution Manager 7.0 with SP below 24, see SAP Note 1579267.
For SAP rapid-deployment solutions, implementation content is available in SAP Solution Manager templates.
The SAP Solution Manager template for this solution package is in the ST-RDS 100 content add-on. You can download the latest available ST-RDS 100 content add-on from SAP Software Download Center on SAP Service Marketplace at service.sap.com/swdc.
For more information about downloading and installing ST-RDS 100 content add-ons, see SAP Note 1726649 and SAP Note 1686668 respectively.
In the ST-RDS 100 content add-on, access the template in the following way:
If you have SAP Solution Manager 7.1 SP04 or lower, select the template ID and template name in the table below.
If you have SAP Solution Manager 7.1 SP05 or higher, select the solution package name(s) in the table below.
Template ID and Template Name
RDS_BIA_BOA41V7 - SAP Business Intelligence Adoption rds_V7
Solution Package Name(s)
SAP Business Intelligence Adoption rds_V7
3.4 Software Landscape Diagram
3.4.1 Solution for ERP Core via SAP Business Warehouse, Track Analytics Data, ERP Operational Data Provisioning
To deploy BI on BW of this package, the applicable scope depends on customer’s landscape. As for those SAP Customers who installed BW already, here is the transition road map to BW on HANA:
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 14 of 20
Solutions: Conventional BW (on Any DB)
Solutions: Fully Migrated to BW on HANA
Road Map: Transition to BW on HANA
Any
DB
Client
SAP
Busines
s
Suite
BW
Virtual /
Transient
Provider
SLT HANA ViewBW
SchemaSAP HANA
Any DB
Client
SAP
Business
Suite
HANA
BW
Any DB
Virtual /
Transient
Provider
SLT
Solutions: Partial Migrated to BW on HANA
Any DBHANA
DB
BWSAP
Business
Suite
Extractor
Any DB
BWSAP
Business
Suite
Extractor
Any DB
BWHANA Optimized
Cube
HANA Managed
Schema (Generated)
BW Managed
Schema
SAP HANA
Calculation View
Analytic View
DB Table in Memory
BOBJ BI Reports
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 15 of 20
3.4.1.1 Solution for BW (without HANA)
BW Bex Queries
SAP Netweaver BW 7.31 SP11
Crystal Report
for Enterprise
Semantic Layer (universe UNX)
Web Intelligence
Dashboards (html5)
Information Space
SAP BusinessObjects BI Platform 4.1
Design Studio
Mobile Devices
BICS (Transient Universe)
Cubes
SAP BusinessObjects BI Launchpad
SAP ERP 6.06
Analytic Queries
Data Provision for Search and Analytics
Operational Data Provider
Data SourceSearch and Analytic Model
DS Extractor
Web Intelligence
Analysis Workspace
Any Data base
Multi Provider
BICS
SAP Lumira
(Applicable for B05 B07 B49 B53 B55 D02 BY4 BY5 BY6 BY7 BY8 BY9 VB6. VB6 requires CRM source system to replace above ERP )
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 16 of 20
3.4.1.2 Solution for BW (BW and HANA mixed)
BW Bex Queries
SAP Netweaver BW 7.31 SP11
Crystal Report
for Enterprise
Semantic Layer (universe UNX)
Web Intelligence
Dashboards (html5)
Information Space
SAP BusinessObjects BI Platform 4.1
Design Studio
Mobile Devices
BICS (Transient Universe)
Cubes
SAP BusinessObjects BI Launchpad
SAP ERP 6.06Analytic Queries
Data Provision for Search and Analytics
Operational Data ProviderData Source
Search and Analytic Model
DS Extractor
Web Intelligence
Analysis Workspace
SAP HANA 1.0 SP07
SLT 2.0
HANA View
Any Data base Virtual Provider
Multi Provider
BICS
SAP Lumira
(Applicable for B05 B07 B49 B53 B55 D02 BY4 BY5 BY6 BY7 BY8 BY9 VB6 with more reports. VB6 requires CRM source system to replace above ERP)
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 17 of 20
3.4.2 Solution for BW on HANA
BW Bex Queries
SAP Netweaver BW 7.31 SP11
Crystal Report
for Enterprise
Semantic Layer (universe UNX)
Web Intelligence
Dashboards (html5)
Information Space
SAP BusinessObjects BI Platform 4.1
Design Studio
Mobile Devices
BICS (Transient Universe)
Cubes
SAP BusinessObjects BI Launchpad
SAP ERP 6.06Analytic Queries
Data Provision for Search and Analytics
Operational Data ProviderData Source
Search and Analytic Model
DS Extractor
Web Intelligence
Analysis Workspace
SAP HANA 1.0 SP07
SLT 2.0
HANA View
HANA Virtual Provider
Multi Provider
BW Bex Queries
SAP Netweaver BW 7.31 SP11
Info Provider
BICS
SAP HANA DB Edition
BW Managed
Schema
DB Table in Memory
HANA Managed
Schema
Calculation View
Analytic View
SAP Lumira
Read
Generate HANA view based on BW
Managed Schema via HANA Studio
(Applicable for B05 B07 B49 B53 B55 D02 BY4 BY5 BY6 BY7 BY8 BY9 VB6 with more reports. VB6 requires CRM source system to replace above ERP)
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 18 of 20
3.4.3 Solution for BI within CRM Analytics
SAP Netweaver 7.31
ECC 6.0 SP5 CRM 7.0 EhP1 (RDS)
Interactive
Reporting
BI Client
SD Data Extractors CRM Data Extractors
Custom Transformations ( SD -> CRM Orders and Quotations)
BWCubes, Multiproviders (standard content)
SD
BI Queries
BI Consumer service(BICS) webservice (via BI Java)
BROWSER
Real-time
data
BO
dashboards
Xcelsius
Interactive
Reports and
Dashboards
CO-PA*
* Some of the marketing content is dependent upon standard integration of CRM 7.01 to CO-PA
Bex Reports
CRM WEB UI
(Applicable for CR3 CR4 CR5 CR6. ERP is not necessary for CR3 CR5)
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 19 of 20
3.4.4 Solution for BI within Trade Promotion Effectiveness Analytics
SAP HANA
BW on HANA
Demand Information Repository
Harmonized, aggregated demand information
enriched with company internal information
Retailer
ePOS Data
(e.g. Metro,
ASDA)
Market Research
Data
(e.g. Nielsen, TNS,
GfK, IRI)
Retailer 1
SAP SCM SAP TPM
Retailer 2
…
Retailer nHouseholds
other
3rd
Party
TPEDASHBOARDS REPORTS EXPLORER
BEX Queries
Transient Universe
TPO Prediction
TPO Modeling
TPO Add-On
SA
P E
RP SAP
HANA
Live
SAP CRM
TPM
LUMIRA
SAP Rapid Deployment Solutions Software and Delivery Requirements
© SAP SE Public Page 20 of 20
3.4.5 Solution for Operational Analytics non-SAP Scenario
SAP Sybase IQ
Data Mart Layer
3rd
party
ERP System
Retailer 1 Retailer 2
…
Retailer n
3rd
party
BI System
SAP Lumira
Team Server (Optional)SAP Lumira (Desktop)