Integrating SAP BusinessObjects BI with SAP NetWeaver

Introduction ... 15
1. SAP BusinessObjects BI and SAP NetWeaver Overview ... 21


1.1 ... User Interaction ... 22
1.2 ... BI Tools and Clients ... 22
1.3 ... Management Tools ... 23
1.4 ... Platform Service ... 24
1.5 ... SAP BusinessObjects BI Client Tools ... 26
1.6 ... Components for Integration with SAP Landscapes ... 35
1.7 ... Summary ... 38

2. Installation and Configuration ... 39


2.1 ... Verifying Your SAP Landscape ... 40
2.2 ... SAP BusinessObjects BI: Server-Side Installation ... 40
2.3 ... SAP BusinessObjects: Client-Side Installation ... 53
2.4 ... SAP NetWeaver: Server-Side Configuration ... 78
2.5 ... Integrating SAP BusinessObjects BI and SAP NetWeaver ... 82
2.6 ... Configuring SAP BusinessObjects 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.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.2 ... SAP Crystal Reports for Enterprise and SAP ERP ... 196
4.3 ... SAP Crystal Reports 2013 and SAP ERP ... 211
4.4 ... What's New in SAP Crystal Reports for Enterprise 4.1? ... 218
4.5 ... Summary ... 219

5. SAP BusinessObjects Web Intelligence and SAP NetWeaver BW ... 221


5.1 ... SAP BusinessObjects Web Intelligence and SAP NetWeaver BW ... 221
5.2 ... SAP BusinessObjects 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 BusinessObjects Web Intelligence XI 3.1 to 4.x ... 244
5.6 ... What's New in SAP BusinessObjects Web Intelligence 4.1? ... 247
5.7 ... Summary ... 248

6. SAP BusinessObjects 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 BusinessObjects Analysis, Edition for Microsoft Office 1.4? ... 267
6.5 ... Summary ... 268

7. SAP BusinessObjects 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 BusinessObjects Analysis, Edition for OLAP 4.1? ... 284
7.5 ... Summary ... 284

8. SAP BusinessObjects 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 BusinessObjects 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 BusinessObjects Dashboards and SAP Landscapes ... 339


10.1 ... SAP BusinessObjects Dashboards and SAP NetWeaver BW ... 339
10.2 ... SAP BusinessObjects Dashboards and SAP ERP ... 346
10.3 ... Creating Your First Dashboard ... 347
10.4 ... What's New in SAP BusinessObjects Dashboards 4.1? ... 365
10.5 ... Summary ... 366

11. SAP BusinessObjects Explorer and SAP Landscapes ... 367

11.1 ... SAP BusinessObjects Explorer and SAP NetWeaver BW ... 367
11.2 ... SAP BusinessObjects 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.5 ... What's New in SAP BusinessObjects Explorer 4.1? ... 393
11.6 ... Summary ... 394

12. SAP BusinessObjects Live Office and BI Web Services ... 395


12.1 ... Using SAP BusinessObjects Live Office and BI Web Services ... 395
12.2 ... SAP BusinessObjects Dashboards and SAP BusinessObjects Live Office ... 396
12.3 ... SAP BusinessObjects 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.2 ... Configuring Your SAP Server for Server-Side Trust ... 416
13.3 ... Configuring Your SAP BusinessObjects BI System for Server-Side Trust ... 421
13.4 ... Creating Publications with SAP Crystal Reports and SAP BusinessObjects 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.2 ... BI Content with Knowledge Management ... 463
14.3 ... Summary ... 474

15. Integrating SAP BusinessObjects Lifecycle Manager with CTS+ ... 475

15.1 ... Technical Prerequisites ... 475
15.2 ... Configuring SAP BusinessObjects Lifecycle Manager with CTS+ ... 477
15.3 ... Using Integrated SAP BusinessObjects Lifecycle Manager with CTS+ ... 496
15.4 ... Summary ... 503

16. Troubleshooting and Tips ... 505


16.1 ... Tracing for SAP BusinessObjects BI Services and Applications ... 505
16.2 ... Data Connectivity ... 506
16.3 ... Single Sign-On and Authentication ... 525
16.4 ... Publishing SAP Crystal Reports 2013 ... 526
16.5 ... Publications ... 527
16.6 ... Performance ... 528
16.7 ... Summary ... 531

17. Integration Outlook ... 533
The Author ... 535
Index ... 537