• Understand the specifics of running SAP BusinessObjects BI products on top of SAP NetWeaver BW and SAP ERP data
• Learn how to set up your SAP NetWeaver system for SAP Crystal Reports, SAP BusinessObjects Dashboards, SAP BusinessObjects Web Intelligence, and more
• Updated and expanded for SAP BusinessObjects 4.x
Get the crucial knowledge you need to make essential business intelligence products work on top of SAP NetWeaver. Continuing in the tradition of the first bestselling edition, this updated edition carefully guides you, click-by-click, through the process of connecting SAP BusinessObjects tools to SAP data. The expert advice and clear instruction that this book provides is just what you need to become an authority on integrating your SAP BusinessObjects BI platform with SAP NetWeaver.
Step-by-Step Instructions
Follow along as the author walks you through each click and screen needed to integrate SAP BusinessObjects with SAP NetWeaver.
Installation and Configuration
Learn how to install and configure the necessary server and client components to start working with SAP BusinessObjects tools.
Semantic Layer
Review the different options for connecting corporate data in a brand new chapter about the semantic layer.
SAP NetWeaver Portal
Discover how you can make SAP NetWeaver Portal work with the SAP BusinessObjects BI platform.
Updated and Expanded
Explore over 200 new pages, and find updated information on how the 4.x release of the SAP BusinessObjects BI platform changes the landscape of the integration with SAP NetWeaver.
Highlights
• Installation and configuration
• Semantic layer
• SAP Crystal Reports for Enterprise
• SAP BusinessObjects Web Intelligence
• SAP BusinessObjects Dashboards
• SAP BusinessObjects Analysis, edition for Microsoft Office
• SAP BusinessObjects Analysis, edition for OLAP
• SAP NetWeaver Portal
• Security and troubleshooting
The Author
Ingo Hilgefort started with Crystal Decisions in Frankfurt, Germany, in 1999 as a trainer and consultant for Crystal Reports and Crystal Enterprise. After the acquisition of Crystal Decisions by BusinessObjects, he moved into product management for the integration between BusinessObjects and SAP.
Table of Contents
- ... Introduction ... 15
- 1 ... SAP BusinessObjects 4.x and SAP NetWeaver ... 21
- 1.1 ... User Interaction ... 22
- 1.2 ... BI Tools and Clients ... 22
- 1.3 ... Management Tools ... 22
- 1.3.1 ... Central Management Console ... 23
- 1.3.2 ... Central Configuration Manager ... 23
- 1.3.3 ... Lifecycle Management Tool ... 23
- 1.4 ... Platform Service ... 24
- 1.4.1 ... Central Management Server ... 24
- 1.4.2 ... File Repository Services ... 24
- 1.4.3 ... Processing Tier ... 25
- 1.4.4 ... Server Intelligence Agent ... 25
- 1.4.5 ... Publication and Publishing Services ... 25
- 1.5 ... SAP BusinessObjects BI Client Tools ... 26
- 1.5.1 ... SAP Crystal Reports ... 26
- 1.5.2 ... SAP BusinessObjects Web Intelligence ... 27
- 1.5.3 ... SAP BusinessObjects Dashboards (formerly Xcelsius) ... 29
- 1.5.4 ... SAP BusinessObjects Analysis ... 30
- 1.5.5 ... SAP BusinessObjects Explorer ... 32
- 1.5.6 ... Semantic Layer ... 33
- 1.6 ... Components for Integration with SAP Landscapes ... 33
- 1.6.1 ... Data Connectivity ... 33
- 1.6.2 ... SAP Authentication ... 34
- 1.6.3 ... BW Publisher ... 35
- 1.6.4 ... Content Administration Workbench ... 35
- 1.6.5 ... SAP NetWeaver Portal—Knowledge Management ... 35
- 1.6.6 ... SAP NetWeaver Portal—iView Templates and Sample iViews ... 35
- 1.6.7 ... Lifecycle Management with CTS ... 36
- 1.7 ... Summary ... 36
- 2 ... Installation and Configuration ... 37
- 2.1 ... Verifying Your SAP Landscape ... 38
- 2.2 ... SAP BusinessObjects—Server-Side Installation ... 39
- 2.2.1 ... Technical Prerequisites ... 40
- 2.2.2 ... Installation Routine ... 41
- 2.3 ... SAP BusinessObjects—Client-Side Installation ... 52
- 2.3.1 ... SAP Crystal Reports for Enterprise ... 54
- 2.3.2 ... SAP BusinessObjects Dashboards ... 57
- 2.3.3 ... SAP BusinessObjects Live Office ... 60
- 2.3.4 ... SAP BusinessObjects BI Platform Client Tools ... 62
- 2.3.5 ... SAP BusinessObjects Analysis, Edition for Microsoft Office ... 64
- 2.4 ... SAP NetWeaver—Server-Side Configuration ... 66
- 2.4.1 ... Server Patch Level ... 67
- 2.4.2 ... Supported Platforms ... 68
- 2.4.3 ... ABAP Transport ... 68
- 2.4.4 ... Single Sign-On ... 69
- 2.4.5 ... User Authorization ... 70
- 2.5 ... Integrating SAP BusinessObjects and SAP NetWeaver ... 70
- 2.5.1 ... Configuration of SAP Authentication ... 70
- 2.5.2 ... Setting up the Publishing Process for SAP Crystal Reports 2011 ... 79
- 2.5.3 ... Viewing Reports within the SAP System Frontend ... 102
- 2.5.4 ... Publishing Summary ... 103
- 2.5.5 ... Hosting SAP BEx Web Applications in SAP BusinessObjects ... 104
- 2.5.6 ... Configuring the SSO Token Service as Part of SAP BusinessObjects ... 120
- 2.6 ... Summary ... 129
- 3 ... Semantic Layer and Data Connectivity ... 131
- 3.1 ... Semantic Layer Technology ... 131
- 3.2 ... SAP BusinessObjects Semantic Layer Terms ... 132
- 3.3 ... Data Connectivity for SAP Landscapes ... 133
- 3.3.1 ... Direct Access to SAP NetWeaver BW using BICS ... 135
- 3.3.2 ... Relational Access to SAP NetWeaver BW ... 137
- 3.3.3 ... Recommendation for SAP NetWeaver BW Data Connectivity ... 139
- 3.4 ... Relational Access to SAP ECC ... 143
- 3.4.1 ... Recommendation for SAP ERP Access ... 147
- 3.5 ... Summary ... 147
- 4 ... SAP Crystal Reports and SAP Landscapes ... 149
- 4.1 ... SAP Crystal Reports 2011 or SAP Crystal Reports for Enterprise ... 149
- 4.2 ... Crystal Reports for Enterprise and SAP NetWeaver BW ... 151
- 4.2.1 ... Data Connectivity Overview for SAP Crystal Reports for Enterprise ... 151
- 4.2.2 ... Supported and Unsupported SAP NetWeaver BW Elements for SAP Crystal Reports for Enterprise ... 151
- 4.2.3 ... Creating Your First Report with SAP Crystal Report for Enterprise and SAP NetWeaver BW ... 156
- 4.3 ... SAP Crystal Reports for Enterprise and SAP ERP ... 170
- 4.4 ... Crystal Reports 2011 and SAP ERP ... 185
- 4.4.1 ... Data Connectivity Overview ... 185
- 4.4.2 ... Data-Level Security Editor ... 188
- 4.4.3 ... Creating Your First Report with SAP Crystal Reports 2011 and SAP ERP ... 191
- 4.5 ... Migrating from SAP Crystal Reports 2008 to SAP Crystal Reports for Enterprise ... 195
- 4.6 ... Summary ... 200
- 5 ... SAP BusinessObjects Web Intelligence and SAP NetWeaver BW ... 201
- 5.1 ... SAP BusinessObjects Web Intelligence and SAP BW ... 201
- 5.1.1 ... Data Connectivity Overview ... 202
- 5.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 203
- 5.2 ... SAP BusinessObjects Web Intelligence and SAP ERP ... 207
- 5.3 ... Creating Your First Report for SAP NetWeaver BW (BICS) ... 208
- 5.4 ... Creating Your First Report for SAP NetWeaver BW (Relational Universe) ... 215
- 5.5 ... Migration from SAP BusinessObjects Web Intelligence XI 3.1 to 4.x ... 224
- 5.6 ... Summary ... 227
- 6 ... SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP NetWeaver BW ... 229
- 6.1 ... Data Connectivity Overview ... 229
- 6.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 231
- 6.3 ... Creating Your First Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office ... 236
- 6.4 ... Summary ... 246
- 7 ... SAP BusinessObjects Analysis, Edition for OLAP and SAP NetWeaver BW ... 247
- 7.1 ... Data Connectivity Overview ... 247
- 7.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 248
- 7.3 ... Creating Your First Workbook in SAP BusinessObjects Analysis, Edition for OLAP ... 252
- 7.4 ... Summary ... 262
- 8 ... SAP BusinessObjects Dashboards and SAP Landscapes ... 263
- 8.1 ... SAP BusinessObjects Dashboards and SAP NetWeaver BW ... 263
- 8.1.1 ... Data Connectivity Overview ... 263
- 8.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 265
- 8.2 ... SAP BusinessObjects Dashboards and SAP ERP ... 271
- 8.3 ... Creating Your First Dashboard with SAP BusinessObjects Dashboards ... 272
- 8.3.1 ... SAP BusinessObjects Dashboards and Direct Access via SAP NetWeaver BW ... 272
- 8.3.2 ... SAP BusinessObjects Dashboards and Direct Access to SAP NetWeaver BW via SAP BusinessObjects ... 282
- 8.4 ... Summary ... 290
- 9 ... SAP BusinessObjects Explorer and SAP Landscapes ... 291
- 9.1 ... SAP BusinessObjects Explorer and SAP NetWeaver BW ... 291
- 9.1.1 ... Data Connectivity Overview ... 291
- 9.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 293
- 9.2 ... SAP BusinessObjects Explorer and SAP ERP ... 296
- 9.3 ... Creating Your First SAP BusinessObjects Explorer Information Space ... 297
- 9.3.1 ... SAP BusinessObjects Explorer and Relational Access to SAP NetWeaver BW ... 298
- 9.4 ... Summary ... 309
- 10 ... SAP BusinessObjects Live Office and BI Web Services ... 311
- 10.1 ... Using Live Office and BI Web Services ... 311
- 10.2 ... SAP BusinessObjects Dashboards and SAP BusinessObjects Live Office ... 312
- 10.3 ... SAP BusinessObjects Dashboards and BI Web Services ... 322
- 10.4 ... Summary ... 328
- 11 ... Publications with SAP Data-Level Security ... 329
- 11.1 ... What Is Server-Side Trust? ... 329
- 11.1.1 ... Server-Side Trust Components ... 330
- 11.1.2 ... Steps to Configure Server-Side Trust ... 331
- 11.2 ... Configuring Your SAP Server for Server-Side Trust ... 332
- 11.2.1 ... Deploying and Configuring the SAP Cryptographic Library ... 333
- 11.2.2 ... Configuring Profile Parameters ... 333
- 11.2.3 ... Configuring the Trust Manager ... 335
- 11.2.4 ... Configuring Additional Profile Parameters ... 337
- 11.3 ... Configuring Your SAP BusinessObjects System for Server-Side Trust ... 337
- 11.3.1 ... Deploying and Configuring the SAP Cryptographic Library ... 338
- 11.3.2 ... Generating PSE Files ... 339
- 11.3.3 ... Importing the Certificate File with Trust Manager ... 341
- 11.3.4 ... SNC Access Control List ... 344
- 11.3.5 ... Importing SAP Server PSE Files ... 345
- 11.3.6 ... Granting Access to the PSE File ... 346
- 11.3.7 ... Configuring SAP BusinessObjects Services ... 347
- 11.3.8 ... SNC Options in the Central Management Console ... 353
- 11.4 ... Creating Publications with SAP Crystal Reports and SAP BusinessObjects Web Intelligence ... 355
- 11.5 ... Summary ... 362
- 12 ... Integration with SAP NetWeaver Portal ... 363
- 12.1 ... BI Content with SAP NetWeaver Portal iViews ... 363
- 12.1.1 ... Technical Prerequisites ... 363
- 12.1.2 ... SAP NetWeaver Portal—Configuration Steps ... 364
- 12.1.3 ... SAP BusinessObjects—Configuration Steps ... 374
- 12.1.4 ... Create Your First iView ... 376
- 12.1.5 ... Integration of the BI Launch Pad and SAP NetWeaver Portal ... 379
- 12.2 ... BI Content with Knowledge Management ... 381
- 12.2.1 ... Technical Prerequisites ... 382
- 12.2.2 ... SAP NetWeaver Portal—Configuration Steps ... 382
- 12.2.3 ... Setting Up Your Repository ... 384
- 12.2.4 ... Using the Repository Manager ... 390
- 12.3 ... Summary ... 393
- 13 ... Troubleshooting and Tips ... 395
- 13.1 ... Tracing for SAP BusinessObjects Services and Applications ... 395
- 13.2 ... Data Connectivity ... 396
- 13.2.1 ... Steps to Validate the Configuration ... 397
- 13.2.2 ... Tracing SAP Crystal Reports 2011 Data Connectivity ... 397
- 13.2.3 ... Tracing Data Connectivity based on BI Consumer Services ... 398
- 13.2.4 ... Validating Metadata ... 414
- 13.2.5 ... Validating the Results ... 415
- 13.3 ... Single Sign-On and Authentication ... 415
- 13.3.1 ... Steps to Validate the Configuration ... 415
- 13.3.2 ... Tracing ... 416
- 13.4 ... Publishing SAP Crystal Reports 2011 ... 416
- 13.4.1 ... Steps to Validate the Configuration ... 416
- 13.4.2 ... Tracing ... 417
- 13.5 ... Publications ... 417
- 13.5.1 ... Steps to Validate the Configuration ... 417
- 13.5.2 ... Tracing ... 418
- 13.6 ... Performance ... 419
- 13.6.1 ... General Performance Considerations ... 419
- 13.6.2 ... BEx Query Design ... 420
- 13.7 ... Summary ... 421
- 14 ... Integration Outlook ... 423
- 14.1 ... Summary ... 425
- ... The Author ... 427
- ... Index ... 429