Integrating SAP BusinessObjects BI with SAP NetWeaver (3rd Edition)

Integrating SAP BusinessObjects BI with SAP NetWeaver (3rd Edition)

2013
978-1-59229-923-2
542

Product Details

• Learn how to run SAP BusinessObjects BI tools on top of SAP data
• Understand your data connectivity options for integration
• Get up to speed on SAP BusinessObjects Design Studio and SAP Lumira
• 3rd edition updated and expanded

You know what SAP BusinessObjects BI can do for a business—now make it happen. With this detailed, click-by-click guide, learn how to connect SAP to the SAP BusinessObjects BI 4.1 platform. From data connectivity to server-side and client-side configuration to creating reports, you’ll find the information you need to get your systems talking.

Installation and Configuration
Begin at the beginning—get SAP BusinessObjects BI set up quickly and in the right way. With detailed instructions and screenshots, you’ll get started on the right foot.

Data Connectivity
Universes, BI Consumer Services, and more: Find out what you need to know about data connectivity for SAP BusinessObjects BI and SAP NetWeaver.

Report Building
Consider this your crash course in report development. From SAP Crystal Reports to SAP Lumira, get hands-on experience with every tool.

Troubleshooting and Tips
Learn from an expert who knows all the tricks of the trade. Find what you need to know to get everything working together.

Updated and Expanded 3rd Edition
Discover new features of SAP BusinessObjects BI 4.1, as well as new SAP business intelligence solutions like SAP BusinessObjects Design Studio and SAP Lumira.

Highlights

• Installation and configuration
• Data connectivity
• Semantic layer
• Universes (UNX and UNV)
• SAP NetWeaver BW
• SAP Crystal Reports
• SAP BusinessObjects Web Intelligence
• SAP BusinessObjects Analysis
• SAP BusinessObjects Dashboards
• SAP BusinessObjects Design Studio
• SAP Lumira
• SAP NetWeaver Portal
• CTS+

The Author

Ingo Hilgefort has worked in the BI industry for over 12 years and has been involved in building and delivering SAP business intelligence solutions for a number of worldwide customers. His current focus is the integration of SAP BusinessObjects BI with SAP NetWeaver BW and SAP NetWeaver BW on SAP HANA.

Table of Contents

  • ... Introduction ... 15
  • 1 ... SAP Business­Objects BI and SAP NetWeaver Overview ... 21
  • 1.1 ... User Interaction ... 22
  • 1.2 ... BI Tools and Clients ... 22
  • 1.3 ... Management Tools ... 23
  • 1.3.1 ... Central Management Console (CMC) ... 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 (CMS) ... 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 Business­Objects BI Client Tools ... 26
  • 1.5.1 ... SAP Crystal Reports ... 26
  • 1.5.2 ... SAP Business­Objects Web Intelligence ... 27
  • 1.5.3 ... SAP Business­Objects Dashboards ... 29
  • 1.5.4 ... SAP Business­Objects Analysis ... 30
  • 1.5.5 ... SAP Business­Objects Explorer ... 32
  • 1.5.6 ... SAP Business­Objects Design Studio ... 33
  • 1.5.7 ... SAP Lumira ... 34
  • 1.5.8 ... Information Design Tool ... 35
  • 1.6 ... Components for Integration with SAP Landscapes ... 35
  • 1.6.1 ... Data Connectivity ... 35
  • 1.6.2 ... SAP Authentication ... 36
  • 1.6.3 ... BW Publisher ... 36
  • 1.6.4 ... Content Administration Workbench ... 37
  • 1.6.5 ... SAP NetWeaver Portal: Knowledge Management ... 37
  • 1.6.6 ... SAP NetWeaver Portal: iView Templates and Sample iViews ... 37
  • 1.6.7 ... Lifecycle Management with CTS+ ... 38
  • 1.7 ... Summary ... 38
  • 2 ... Installation and Configuration ... 39
  • 2.1 ... Verifying Your SAP Landscape ... 40
  • 2.2 ... SAP Business­Objects BI: Server-Side Installation ... 40
  • 2.2.1 ... Technical Prerequisites ... 41
  • 2.2.2 ... Installation Routine ... 41
  • 2.3 ... SAP Business­Objects: Client-Side Installation ... 53
  • 2.3.1 ... SAP Crystal Reports for Enterprise ... 55
  • 2.3.2 ... SAP Business­Objects Dashboards ... 58
  • 2.3.3 ... SAP Business­Objects Live Office ... 62
  • 2.3.4 ... SAP Business­Objects BI Platform Tools ... 64
  • 2.3.5 ... SAP Business­Objects Analysis, Edition for Microsoft Office ... 66
  • 2.3.6 ... SAP Business­Objects Design Studio ... 68
  • 2.3.7 ... SAP Business­Objects Explorer ... 72
  • 2.3.8 ... SAP Lumira ... 75
  • 2.4 ... SAP NetWeaver: Server-Side Configuration ... 78
  • 2.4.1 ... Server Patch Level ... 79
  • 2.4.2 ... Supported Platforms ... 80
  • 2.4.3 ... ABAP Transport ... 80
  • 2.4.4 ... Single Sign-On ... 81
  • 2.4.5 ... User Authorization ... 82
  • 2.5 ... Integrating SAP Business­Objects BI and SAP NetWeaver ... 82
  • 2.5.1 ... Configuring SAP Authentication ... 82
  • 2.5.2 ... Setting up the Publishing Process for SAP Crystal Reports 2013 ... 91
  • 2.5.3 ... Hosting BEx Web Applications in the SAP Business­Objects BI Platform ... 115
  • 2.5.4 ... Configuring the SSO Token Service as Part of SAP Business­Objects BI ... 131
  • 2.6 ... Configuring SAP Business­Objects Mobile ... 140
  • 2.7 ... Summary ... 142
  • 3 ... Semantic Layer and Data Connectivity ... 143
  • 3.1 ... Semantic Layer Terminology ... 143
  • 3.2 ... Data Connectivity Overview for SAP Landscapes ... 145
  • 3.3 ... Data Connectivity for SAP NetWeaver BW ... 149
  • 3.3.1 ... Direct Access to SAP NetWeaver BW via BICS ... 149
  • 3.3.2 ... Relational Access to SAP NetWeaver BW ... 150
  • 3.3.3 ... SAP NetWeaver BW on SAP HANA ... 151
  • 3.3.4 ... Support for Metadata ... 153
  • 3.4 ... Data Connectivity for SAP ERP ... 170
  • 3.5 ... Summary ... 173
  • 4 ... SAP Crystal Reports and SAP Landscapes ... 175
  • 4.1 ... SAP Crystal Reports for Enterprise and SAP NetWeaver BW ... 176
  • 4.1.1 ... Data Connectivity Overview ... 176
  • 4.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 177
  • 4.1.3 ... Creating Your First Report ... 182
  • 4.2 ... SAP Crystal Reports for Enterprise and SAP ERP ... 196
  • 4.3 ... SAP Crystal Reports 2013 and SAP ERP ... 211
  • 4.3.1 ... Data Connectivity Overview ... 211
  • 4.3.2 ... Data Level Security Editor ... 215
  • 4.4 ... What’s New in SAP Crystal Reports for Enterprise 4.1? ... 218
  • 4.5 ... Summary ... 219
  • 5 ... SAP Business­Objects Web Intelligence and SAP NetWeaver BW ... 221
  • 5.1 ... SAP Business­Objects Web Intelligence and SAP NetWeaver BW ... 221
  • 5.1.1 ... Data Connectivity Overview ... 221
  • 5.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 222
  • 5.2 ... SAP Business­Objects Web Intelligence and SAP ERP ... 227
  • 5.3 ... Creating Your First Report for SAP NetWeaver BW (BICS) ... 227
  • 5.4 ... Creating Your First Report for SAP NetWeaver BW (Relational Universe) ... 236
  • 5.5 ... Migrating from SAP Business­Objects Web Intelligence XI 3.1 to 4.x ... 244
  • 5.6 ... What’s New in SAP Business­Objects Web Intelligence 4.1? ... 247
  • 5.7 ... Summary ... 248
  • 6 ... SAP Business­Objects Analysis, Edition for Microsoft Office and SAP NetWeaver BW ... 249
  • 6.1 ... Data Connectivity Overview ... 249
  • 6.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 252
  • 6.3 ... Creating Your First Workbook ... 257
  • 6.4 ... What’s New in SAP Business­Objects Analysis, Edition for Microsoft Office 1.4? ... 267
  • 6.5 ... Summary ... 268
  • 7 ... SAP Business­Objects Analysis, Edition for OLAP and SAP NetWeaver BW ... 269
  • 7.1 ... Data Connectivity Overview ... 269
  • 7.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 270
  • 7.3 ... Creating Your First Workbook ... 274
  • 7.4 ... What’s New in SAP Business­Objects Analysis, Edition for OLAP 4.1? ... 284
  • 7.5 ... Summary ... 284
  • 8 ... SAP Business­Objects Design Studio and SAP NetWeaver BW ... 285
  • 8.1 ... Data Connectivity Overview ... 285
  • 8.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 286
  • 8.3 ... Creating Your First Dashboard ... 290
  • 8.4 ... What’s New in SAP Business­Objects Design Studio 1.1? ... 310
  • 8.5 ... Summary ... 311
  • 9 ... SAP Lumira and SAP NetWeaver BW ... 313
  • 9.1 ... Data Connectivity Overview ... 313
  • 9.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 314
  • 9.3 ... Generating an SAP HANA Model ... 324
  • 9.4 ... Using SAP Lumira ... 331
  • 9.5 ... Summary ... 338
  • 10 ... SAP Business­Objects Dashboards and SAP Landscapes ... 339
  • 10.1 ... SAP Business­Objects Dashboards and SAP NetWeaver BW ... 339
  • 10.1.1 ... Data Connectivity Overview ... 339
  • 10.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 341
  • 10.2 ... SAP Business­Objects Dashboards and SAP ERP ... 346
  • 10.3 ... Creating Your First Dashboard ... 347
  • 10.3.1 ... Direct Access via SAP NetWeaver BW ... 347
  • 10.3.2 ... Direct Access to SAP NetWeaver BW via SAP Business­Objects BI ... 357
  • 10.4 ... What’s New in SAP Business­Objects Dashboards 4.1? ... 365
  • 10.5 ... Summary ... 366
  • 11 ... SAP Business­Objects Explorer and SAP Landscapes ... 367
  • 11.1 ... SAP Business­Objects Explorer and SAP NetWeaver BW ... 367
  • 11.1.1 ... Data Connectivity Overview ... 367
  • 11.1.2 ... Supported and Unsupported SAP NetWeaver BW Elements ... 369
  • 11.2 ... SAP Business­Objects Explorer and SAP ERP ... 373
  • 11.3 ... Creating an Information Space ... 374
  • 11.4 ... Creating an Information Space with SAP NetWeaver BW on SAP HANA ... 385
  • 11.4.1 ... Setting Up Direct Connectivity via the CMC ... 388
  • 11.4.2 ... Setting Up Direct Connectivity via the Information Design Tool ... 391
  • 11.5 ... What’s New in SAP Business­Objects Explorer 4.1? ... 393
  • 11.6 ... Summary ... 394
  • 12 ... SAP Business­Objects Live Office and BI Web Services ... 395
  • 12.1 ... Using SAP Business­Objects Live Office and BI Web Services ... 395
  • 12.2 ... SAP Business­Objects Dashboards and SAP Business­Objects Live Office ... 396
  • 12.3 ... SAP Business­Objects Dashboards and BI Web Services ... 406
  • 12.4 ... Summary ... 412
  • 13 ... Publications with SAP Data-Level Security ... 413
  • 13.1 ... What Is Server-Side Trust? ... 413
  • 13.1.1 ... Server-Side Trust Components ... 414
  • 13.1.2 ... Steps to Configure Server-Side Trust ... 415
  • 13.2 ... Configuring Your SAP Server for Server-Side Trust ... 416
  • 13.2.1 ... Deploying and Configuring the SAP Cryptographic Library ... 416
  • 13.2.2 ... Configuring Profile Parameters ... 417
  • 13.2.3 ... Configuring the Trust Manager ... 419
  • 13.2.4 ... Configuring Additional Profile Parameters ... 420
  • 13.3 ... Configuring Your SAP Business­Objects BI System for Server-Side Trust ... 421
  • 13.3.1 ... Deploying and Configuring the SAP Cryptographic Library ... 422
  • 13.3.2 ... Generating PSE Files ... 422
  • 13.3.3 ... Importing the Certificate File with the Trust Manager ... 424
  • 13.3.4 ... Adding an Entry to the SNC Access Control List ... 427
  • 13.3.5 ... Importing SAP Server PSE Files ... 429
  • 13.3.6 ... Granting Access to the PSE File ... 430
  • 13.3.7 ... Configuring SAP Business­Objects BI Services ... 431
  • 13.3.8 ... Configuring SNC Options in the Central Management Console ... 435
  • 13.4 ... Creating Publications with SAP Crystal Reports and SAP Business­Objects Web Intelligence ... 438
  • 13.5 ... Summary ... 444
  • 14 ... Integration with SAP NetWeaver Portal ... 445
  • 14.1 ... BI Content with SAP NetWeaver Portal iViews ... 445
  • 14.1.1 ... Technical Prerequisites ... 445
  • 14.1.2 ... SAP NetWeaver Portal: Configuration Steps ... 446
  • 14.1.3 ... SAP Business­Objects BI: Configuration Steps ... 456
  • 14.1.4 ... Creating Your First iView ... 457
  • 14.1.5 ... Integrating the BI Launch Pad and SAP NetWeaver Portal ... 461
  • 14.2 ... BI Content with Knowledge Management ... 463
  • 14.2.1 ... Technical Prerequisites ... 463
  • 14.2.2 ... SAP NetWeaver Portal: Configuration Steps ... 463
  • 14.2.3 ... Setting Up Your Repository ... 466
  • 14.2.4 ... Using the Repository Manager ... 471
  • 14.3 ... Summary ... 474
  • 15 ... Integrating SAP Business­Objects Lifecycle Manager with CTS+ ... 475
  • 15.1 ... Technical Prerequisites ... 475
  • 15.2 ... Configuring SAP Business­Objects Lifecycle Manager with CTS+ ... 477
  • 15.2.1 ... Configuring CTS+ ... 477
  • 15.2.2 ... Configuring Application Type BOLM ... 482
  • 15.2.3 ... Configuring the SAP Business­Objects BI System Landscape ... 483
  • 15.3 ... Using Integrated SAP Business­Objects Lifecycle Manager with CTS+ ... 496
  • 15.3.1 ... Creating a New Promotion Job ... 496
  • 15.3.2 ... Importing a Transport Request ... 502
  • 15.4 ... Summary ... 503
  • 16 ... Troubleshooting and Tips ... 505
  • 16.1 ... Tracing for SAP Business­Objects BI Services and Applications ... 505
  • 16.2 ... Data Connectivity ... 506
  • 16.2.1 ... Validating the Configuration ... 507
  • 16.2.2 ... Tracing SAP Crystal Reports 2013 Data Connectivity ... 507
  • 16.2.3 ... Tracing Data Connectivity Based on BI Consumer Services ... 508
  • 16.2.4 ... Validating Metadata ... 524
  • 16.2.5 ... Validating the Results ... 524
  • 16.3 ... Single Sign-On and Authentication ... 525
  • 16.3.1 ... Validating the Configuration ... 525
  • 16.3.2 ... Tracing ... 526
  • 16.4 ... Publishing SAP Crystal Reports 2013 ... 526
  • 16.4.1 ... Validating the Configuration ... 526
  • 16.4.2 ... Tracing ... 526
  • 16.5 ... Publications ... 527
  • 16.5.1 ... Validating the Configuration ... 527
  • 16.5.2 ... Tracing ... 528
  • 16.6 ... Performance ... 528
  • 16.6.1 ... General Performance Considerations ... 529
  • 16.6.2 ... BEx Query Design ... 530
  • 16.7 ... Summary ... 531
  • 17 ... Integration Outlook ... 533
  • ... The Author ... 535
  • ... Index ... 537