Reporting and Analysis with SAP BusinessObjects

✍ Scribed by Ingo Hilgefort

• Publisher: SAP PRESS
• Year: 2011
• Tongue: English
• Leaves: 441
• Edition: 2
• Category: Library

✦ Synopsis

This book tells you everything you always wanted to know about getting started with the SAP BusinessObjects Business Intelligence (BI) platform tools. Learn everything you need to know about Crystal Reports, Web Intelligence, Dashboards (Xcelsius), Analysis, Live Office, and more. What are the different capabilities of each tool? How should you choose one over another? How do you build your first report in each tool? If you want to understand what the SAP BusinessObjects BI platform can do for you, look no further. This book is your first step.

1. Reporting and Analysis Business Requirements Explore the basic business requirements for financial, sales, HR, and management analysis, and learn how each SAP BusinessObjects tool meets, or doesn’t meet, these requirements.

2. Building Your First Report Dive into the details: Get step-by-step instructions and detailed screenshots for building your first report with each of the SAP BusinessObjects BI tools.

3. Best Practices Ensure that you get the most for your time and money by learning the best practices for working with SAP BusinessObjects BI tools.

4. Changes in SAP BusinessObjects 4.0 FP3 Stay up to date on the latest changes in SAP BusinessObjects 4.0, including feature pack 3, such as the introduction of the BI launch pad and BI workspaces.

5. Future Outlook Get a sneak peek at what SAP is working on for future releases of the SAP BusinessObjects BI platform.

Highlights:

• SAP Crystal Reports
• SAP BusinessObjects Web Intelligence
• SAP BusinessObjects Dashboards
• SAP BusinessObjects Analysis
• SAP BusinessObjects Explorer
• SAP BusinessObjects Live Office
• BI workspaces
• BI launch pad

✦ Table of Contents

Ā 匀䄀倀 䈀甀猀椀渀攀猀猀관伀戀樀攀挀琀猀 .x and SAP NetWeaver
1.1 User Interaction
1.2 BI Tools and Clients
1.3 Management Tools
1.3.1 Central Management Console
1.3.2 Central Configuration Manager
1.3.3 Lifecycle Management Tool
1.4 Platform Service
1.4.1 Central Management Server
1.4.2 File Repository Services
1.4.3 Processing Tier
1.4.4 Server Intelligence Agent
1.4.5 Publication and Publishing Services
1.5 SAP BusinessObjects BI Client Tools
1.5.1 SAP Crystal Reports
1.5.2 SAP BusinessObjects Web Intelligence
1.5.3 SAP BusinessObjects Dashboards (formerly Xcelsius)
1.5.4 SAP BusinessObjects Analysis
1.5.5 SAP BusinessObjects Explorer
1.5.6 Semantic Layer
1.6 Components for Integration with SAP Landscapes
1.6.1 Data Connectivity
1.6.2 SAP Authentication
1.6.3 BW Publisher
1.6.4 Content Administration Workbench
1.6.5 SAP NetWeaver Portal—Knowledge Management
1.6.6 SAP NetWeaver Portal—iView Templates and Sample iViews
1.6.7 Lifecycle Management with CTS+
1.7 Summary
2 Installation and Configuration
2.1 Verifying Your SAP Landscape
2.2 SAP BusinessObjects—Server-Side Installation
2.2.1 Technical Prerequisites
2.2.2 Installation Routine
2.3 SAP Business
Objects—Client-Side Installation
2.3.1 SAP Crystal Reports for Enterprise
2.3.2 SAP BusinessObjects Dashboards
2.3.3 SAP BusinessObjects Live Office
2.3.4 SAP BusinessObjects BI Platform Client Tools
2.3.5 SAP BusinessObjects Analysis, Edition for Microsoft Office
2.4 SAP NetWeaver—Server-Side Configuration
2.4.1 Server Patch Level
2.4.2 Supported Platforms
2.4.3 ABAP Transport
2.4.4 Single Sign-On
2.4.5 User Authorization
2.5 Integrating SAP BusinessObjects and SAP NetWeaver
2.5.1 Configuration of SAP Authentication
2.5.2 Setting up the Publishing Process for SAP Crystal Reports 2011
Configuring the Publishing Service
Creation of an RFC Destination
SAP Business
Configuring BW Source Parameters
Assignment of Necessary Rights
Content Administration Workbench
Central Management Console
2.5.3 Viewing Reports within the SAP System Frontend
2.5.4 Publishing Summary
2.5.5 Hosting SAP BEx Web Applications in SAP BusinessObjects
2.5.6 Configuring the SSO Token Service as Part of
SAP BusinessObjects
Generating Keystore File and Certificate
Importing the Certificate into the SAP System
Setting Up SSO in the CMC
Adding SSO Token Service to the SAP BusinessObjects System
2.6 Summary
3 Semantic Layer and Data Connectivity
3.1 Semantic Layer Technology
3.2 SAP BusinessObjects Semantic Layer Terms
3.3 Data Connectivity for SAP Landscapes
3.3.1 Direct Access to SAP NetWeaver BW using BICS
3.3.2 Relational Access to SAP NetWeaver BW
3.3.3 Recommendation for SAP NetWeaver BW Data Connectivity
3.4 Relational Access to SAP ECC
3.4.1 Recommendation for SAP ERP Access
3.5 Summary
4 SAP Crystal Reports and SAP Landscapes
4.1 SAP Crystal Reports 2011 or SAP Crystal Reports for Enterprise
4.2 Crystal Reports for Enterprise and SAP NetWeaver BW
4.2.1 Data Connectivity Overview for SAP Crystal Reports for Enterprise
4.2.2 Supported and Unsupported SAP NetWeaver BW Elements for SAP Crystal Reports for Enterprise
4.2.3 Creating Your First Report with SAP Crystal Report for Enterprise and SAP NetWeaver BW
Recommendation for Semantic Layer and SAP ERP
4.3 SAP Crystal Reports for Enterprise and SAP ERP
4.4 Crystal Reports 2011 and SAP ERP
4.4.1 Data Connectivity Overview
Classic InfoSet and SAP Queries
Table and ABAP Functions
Data Cluster
4.4.2 Data-Level Security Editor
4.4.3 Creating Your First Report with SAP Crystal Reports 2011 and SAP ERP
4.5 Migrating from SAP Crystal Reports 2008 to SAP Crystal Reports for Enterprise
4.6 Summary
5 SAP BusinessObjects Web Intelligence and SAP NetWeaver BW
5.1 SAP BusinessObjects Web Intelligence and SAP BW
5.1.1 Data Connectivity Overview
5.1.2 Supported and Unsupported SAP NetWeaver BW Elements
5.2 SAP BusinessObjects Web Intelligence and SAP ERP
5.3 Creating Your First Report for SAP NetWeaver BW (BICS)
5.4 Creating Your First Report for SAP NetWeaver BW (Relational Universe)
5.5 Migration from SAP BusinessObjects Web Intelligence XI 3.1 to 4.x
5.6 Summary
6 SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP NetWeaver BW
6.1 Data Connectivity Overview
6.2 Supported and Unsupported SAP NetWeaver BW Elements
6.3 Creating Your First Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office
6.4 Summary
7 SAP BusinessObjects Analysis, Edition for OLAP and SAP NetWeaver BW
7.1 Data Connectivity Overview
7.2 Supported and Unsupported SAP NetWeaver BW Elements
7.3 Creating Your First Workbook in SAP BusinessObjects Analysis, Edition for OLAP
7.4 Summary
8 SAP BusinessObjects Dashboards and SAP Landscapes
8.1 SAP BusinessObjects Dashboards and SAP NetWeaver BW
8.1.1 Data Connectivity Overview
8.1.2 Supported and Unsupported SAP NetWeaver BW Elements
8.2 SAP BusinessObjects Dashboards and SAP ERP
8.3 Creating Your First Dashboard with SAP BusinessObjects Dashboards
8.3.1 SAP Business
8.3.2 SAP Business
8.4 Summary
9 SAP BusinessObjects Explorer and SAP Landscapes
9.1 SAP BusinessObjects Explorer and SAP NetWeaver BW
9.1.1 Data Connectivity Overview
9.1.2 Supported and Unsupported SAP NetWeaver BW Elements
9.2 SAP BusinessObjects Explorer and SAP ERP
9.3 Creating Your First SAP BusinessObjects Explorer Information Space
9.3.1 SAP BusinessObjects Explorer and Relational Access to SAP NetWeaver BW
9.4 Summary
10 SAP BusinessObjects Live Office and BI Web Services
10.1 Using Live Office and BI Web Services
10.2 SAP BusinessObjects Dashboards and SAP BusinessObjects Live Office
10.3 SAP BusinessObjects Dashboards and BI Web Services
10.4 Summary
11 Publications with SAP Data-Level Security
11.1 What Is Server-Side Trust?
11.1.1 Server-Side Trust Components
SAP Cryptographic Library
Personal Security Environment
11.1.2 Steps to Configure Server-Side Trust
11.2 Configuring Your SAP Server for Server-Side Trust
11.2.1 Deploying and Configuring the SAP Cryptographic Library
11.2.2 Configuring Profile Parameters
11.2.3 Configuring the Trust Manager
11.2.4 Configuring Additional Profile Parameters
11.3 Configuring Your SAP BusinessObjects System for Server-Side Trust
11.3.1 Deploying and Configuring the SAP Cryptographic Library
11.3.2 Generating PSE Files
11.3.3 Importing the Certificate File with Trust Manager
11.3.4 SNC Access Control List
11.3.5 Importing SAP Server PSE Files
11.3.6 Granting Access to the PSE File
11.3.7 Configuring SAP BusinessObjects Services
11.3.8 SNC Options in the Central Management Console
ā.Ѐ 䌀爀攀愀琀椀渀最 倀甀戀氀椀挀愀琀椀漀渀猀 眀椀琀栀 匀䄀倀 䌀爀礀猀琀愀氀 刀攀瀀漀爀琀猀 愀渀搀 匀䄀倀ꀀ䈀甀猀椀渀攀猀猀관伀戀樀攀挀琀猀 圀攀戀 䤀渀琀攀氀氀椀最攀渀挀
11.5 Summary
12 Integration with SAP NetWeaver Portal
12.1 BI Content with SAP NetWeaver Portal iViews
12.1.1 Technical Prerequisites
12.1.2 SAP NetWeaver Portal—Configuration Steps
Configuring Trust
Importing the SAP BusinessObjects iView Template
Configuring the Portal System Landscape
12.1.3 SAP BusinessObjects—Configuration Steps
Configuring BI Launch Pad for Single Sign-On
12.1.4 Create Your First iView
12.1.5 Integration of the BI Launch Pad and SAP NetWeaver Portal
12.2 BI Content with Knowledge Management
12.2.1 Technical Prerequisites
12.2.2 SAP NetWeaver Portal—Configuration Steps
12.2.3 Setting Up Your Repository
12.2.4 Using the Repository Manager
12.3 Summary
13 Troubleshooting and Tips
13.1 Tracing for SAP BusinessObjects Services and Applications
13.2 Data Connectivity
13.2.1 Steps to Validate the Configuration
13.2.2 Tracing SAP Crystal Reports 2011 Data Connectivity
13.2.3 Tracing Data Connectivity based on BI Consumer Services
13.2.4 Validating Metadata
13.2.5 Validating the Results
13.3 Single Sign-On and Authentication
13.3.1 Steps to Validate the Configuration
13.3.2 Tracing
13.4 Publishing SAP Crystal Reports 2011
13.4.1 Steps to Validate the Configuration
13.4.2 Tracing
13.5 Publications
13.5.1 Steps to Validate the Configuration
13.5.2 Tracing
13.6 Performance
13.6.1 General Performance Considerations
13.6.2 BEx Query Design
SAP Crystal Reports for Enterprise
SAP BusinessObjects Dashboards
SAP BusinessObjects Web Intelligence
SAP BusinessObjects Analysis Suite
SAP BusinessObjects Explorer
Semantic Layer
13.7 Summary
14 Integration Outlook
14.1 Summary
The Author
Index