Inside SAP Businessobjects advanced analysis

✍ Scribed by Hilgefort, Ingo

• Publisher: SAP Press; Galileo Press
• Year: 2010;2011
• Tongue: English
• Leaves: 441
• Edition: 1st ed
• Category: Library

✦ Synopsis

Become an expert on SAP BusinessObjects Advanced Analysis for Microsoft Office (formerly known as Pioneer) and be the go-to person when it comes to installing, deploying, and using this software. Explore how Advanced Analysis greatly reduces the need for specialized design work, but allows users to make simple design and UI changes with ease, elegant visualization control, and personalization features. Additionally, this book provides targeted guidance on installation, deployment, and data connectivity. The author helps you familiarize yourself with both basic and advanced usage scenarios as you learn to customize the software to benefit your business the most.

This unique book also delivers a side-by-side comparison of Advanced Analysis Office with SAP BEx Analyzer, which will prove to be invaluable as Advanced Analysis is positioned to replace the BEx tools. An additional section outlines the main topics in the SAP BI roadmap for the Advanced Analysis Office version and the Web version, and also touches upon migration.

Whether you are a consultant, IT manager, business analyst, or a key user, you will find this book to be an indispensable companion in your daily work with the software.

✦ Table of Contents

Ā 匀䄀倀 䈀甀猀椀渀攀猀猀관伀戀樀攀挀琀猀 .x and SAP NetWeaver......Page 21
1.3 Management Tools......Page 22
1.3.3 Lifecycle Management Tool......Page 23
1.4.2 File Repository Services......Page 24
1.4.5 Publication and Publishing Services......Page 25
1.5.1 SAP Crystal Reports......Page 26
1.5.2 SAP BusinessObjects Web Intelligence......Page 27
1.5.3 SAP BusinessObjects Dashboards (formerly Xcelsius)......Page 29
1.5.4 SAP BusinessObjects Analysis......Page 30
1.5.5 SAP BusinessObjects Explorer......Page 32
1.6.1 Data Connectivity......Page 33
1.6.2 SAP Authentication......Page 34
1.6.6 SAP NetWeaver Portal—iView Templates and Sample iViews......Page 35
1.7 Summary......Page 36
2 Installation and Configuration......Page 37
2.1 Verifying Your SAP Landscape......Page 38
2.2 SAP BusinessObjects—Server-Side Installation......Page 39
2.2.1 Technical Prerequisites......Page 40
2.2.2 Installation Routine......Page 41
2.3 SAP BusinessObjects—Client-Side Installation......Page 52
2.3.1 SAP Crystal Reports for Enterprise......Page 54
2.3.2 SAP BusinessObjects Dashboards......Page 57
2.3.3 SAP BusinessObjects Live Office......Page 60
2.3.4 SAP BusinessObjects BI Platform Client Tools......Page 62
2.3.5 SAP BusinessObjects Analysis, Edition for Microsoft Office......Page 64
2.4 SAP NetWeaver—Server-Side Configuration......Page 66
2.4.1 Server Patch Level......Page 67
2.4.3 ABAP Transport......Page 68
2.4.4 Single Sign-On......Page 69
2.5.1 Configuration of SAP Authentication......Page 70
2.5.2 Setting up the Publishing Process for SAP Crystal Reports 2011......Page 79
Configuring the Publishing Service......Page 81
Creation of an RFC Destination......Page 83
SAP Business­Objects Server Definition......Page 86
Configuring BW Source Parameters......Page 93
Assignment of Necessary Rights......Page 95
Central Management Console......Page 96
2.5.3 Viewing Reports within the SAP System Frontend......Page 102
2.5.4 Publishing Summary......Page 103
2.5.5 Hosting SAP BEx Web Applications in SAP BusinessObjects......Page 104
8.1 SAP BusinessObjects Dashboards and SAP NetWeaver BW......Page 0
Generating Keystore File and Certificate......Page 121
Importing the Certificate into the SAP System......Page 123
Setting Up SSO in the CMC......Page 126
Adding SSO Token Service to the SAP BusinessObjects System......Page 127
2.6 Summary......Page 129
3.1 Semantic Layer Technology......Page 131
3.2 SAP BusinessObjects Semantic Layer Terms......Page 132
3.3 Data Connectivity for SAP Landscapes......Page 133
3.3.1 Direct Access to SAP NetWeaver BW using BICS......Page 135
3.3.2 Relational Access to SAP NetWeaver BW......Page 137
3.3.3 Recommendation for SAP NetWeaver BW Data Connectivity......Page 139
3.4 Relational Access to SAP ECC......Page 143
3.5 Summary......Page 147
4.1 SAP Crystal Reports 2011 or SAP Crystal Reports for Enterprise......Page 149
4.2.2 Supported and Unsupported SAP NetWeaver BW Elements for SAP Crystal Reports for Enterprise......Page 151
4.2.3 Creating Your First Report with SAP Crystal Report for Enterprise and SAP NetWeaver BW......Page 156
Recommendation for Semantic Layer and SAP ERP......Page 184
4.3 SAP Crystal Reports for Enterprise and SAP ERP......Page 170
Classic InfoSet and SAP Queries......Page 185
Table and ABAP Functions......Page 186
4.4.2 Data-Level Security Editor......Page 188
4.4.3 Creating Your First Report with SAP Crystal Reports 2011 and SAP ERP......Page 191
4.5 Migrating from SAP Crystal Reports 2008 to SAP Crystal Reports for Enterprise......Page 195
4.6 Summary......Page 200
5.1 SAP BusinessObjects Web Intelligence and SAP BW......Page 201
5.1.1 Data Connectivity Overview......Page 202
5.1.2 Supported and Unsupported SAP NetWeaver BW Elements......Page 203
5.2 SAP BusinessObjects Web Intelligence and SAP ERP......Page 207
5.3 Creating Your First Report for SAP NetWeaver BW (BICS)......Page 208
5.4 Creating Your First Report for SAP NetWeaver BW (Relational Universe)......Page 215
5.5 Migration from SAP BusinessObjects Web Intelligence XI 3.1 to 4.x......Page 224
5.6 Summary......Page 227
6.1 Data Connectivity Overview......Page 229
6.2 Supported and Unsupported SAP NetWeaver BW Elements......Page 231
6.3 Creating Your First Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office ......Page 236
6.4 Summary......Page 246
7.1 Data Connectivity Overview......Page 247
7.2 Supported and Unsupported SAP NetWeaver BW Elements......Page 248
7.3 Creating Your First Workbook in SAP BusinessObjects Analysis, Edition for OLAP......Page 252
7.4 Summary......Page 262
8.1.1 Data Connectivity Overview......Page 263
8.1.2 Supported and Unsupported SAP NetWeaver BW Elements......Page 265
8.2 SAP BusinessObjects Dashboards and SAP ERP......Page 271
8.3.1 SAP Business­Objects Dashboards and Direct Access via SAP NetWeaver BW......Page 272
8.3.2 SAP Business­Objects Dashboards and Direct Access to SAP NetWeaver BW via SAP Business­Objects......Page 282
8.4 Summary......Page 290
9.1.1 Data Connectivity Overview......Page 291
9.1.2 Supported and Unsupported SAP NetWeaver BW Elements......Page 293
9.2 SAP BusinessObjects Explorer and SAP ERP......Page 296
9.3 Creating Your First SAP BusinessObjects Explorer Information Space......Page 297
9.3.1 SAP BusinessObjects Explorer and Relational Access to SAP NetWeaver BW......Page 298
9.4 Summary......Page 309
10.1 Using Live Office and BI Web Services......Page 311
10.2 SAP BusinessObjects Dashboards and SAP BusinessObjects Live Office......Page 312
10.3 SAP BusinessObjects Dashboards and BI Web Services......Page 322
10.4 Summary......Page 328
11.1 What Is Server-Side Trust?......Page 329
SAP Cryptographic Library......Page 330
11.1.2 Steps to Configure Server-Side Trust......Page 331
11.2 Configuring Your SAP Server for Server-Side Trust......Page 332
11.2.2 Configuring Profile Parameters......Page 333
11.2.3 Configuring the Trust Manager......Page 335
11.3 Configuring Your SAP BusinessObjects System for Server-Side Trust......Page 337
11.3.1 Deploying and Configuring the SAP Cryptographic Library......Page 338
11.3.2 Generating PSE Files......Page 339
11.3.3 Importing the Certificate File with Trust Manager......Page 341
11.3.4 SNC Access Control List......Page 344
11.3.5 Importing SAP Server PSE Files......Page 345
11.3.6 Granting Access to the PSE File......Page 346
11.3.7 Configuring SAP BusinessObjects Services......Page 347
11.3.8 SNC Options in the Central Management Console......Page 353
ā.Ѐ 䌀爀攀愀琀椀渀最 倀甀戀氀椀挀愀琀椀漀渀猀 眀椀琀栀 匀䄀倀 䌀爀礀猀琀愀氀 刀攀瀀漀爀琀猀 愀渀搀 匀䄀倀ꀀ䈀甀猀椀渀攀猀猀관伀戀樀攀挀琀猀 圀攀戀 䤀渀琀攀氀氀椀最攀渀挀......Page 355
11.5 Summary......Page 362
12.1.1 Technical Prerequisites......Page 363
Configuring Trust......Page 364
Importing the SAP BusinessObjects iView Template......Page 367
Configuring the Portal System Landscape......Page 369
Configuring BI Launch Pad for Single Sign-On......Page 374
12.1.4 Create Your First iView......Page 376
12.1.5 Integration of the BI Launch Pad and SAP NetWeaver Portal......Page 379
12.2 BI Content with Knowledge Management......Page 381
12.2.2 SAP NetWeaver Portal—Configuration Steps......Page 382
12.2.3 Setting Up Your Repository......Page 384
12.2.4 Using the Repository Manager......Page 390
12.3 Summary......Page 393
13.1 Tracing for SAP BusinessObjects Services and Applications......Page 395
13.2 Data Connectivity......Page 396
13.2.2 Tracing SAP Crystal Reports 2011 Data Connectivity......Page 397
13.2.3 Tracing Data Connectivity based on BI Consumer Services......Page 398
13.2.4 Validating Metadata......Page 414
13.3.1 Steps to Validate the Configuration......Page 415
13.4.1 Steps to Validate the Configuration......Page 416
13.5.1 Steps to Validate the Configuration......Page 417
13.5.2 Tracing......Page 418
13.6.1 General Performance Considerations......Page 419
13.6.2 BEx Query Design......Page 420
14 Integration Outlook......Page 423
SAP BusinessObjects Explorer......Page 424
14.1 Summary......Page 425
13.7 Summary......Page 421
The Author......Page 427
Index......Page 429