Dallas Marks, Christian Ah-Soon, Jim Brogden
SAP Businessobjects Web Intelligence
The Comprehensive Guide
Mitarbeit:Orthous, Gabriel
Dallas Marks, Christian Ah-Soon, Jim Brogden
SAP Businessobjects Web Intelligence
The Comprehensive Guide
Mitarbeit:Orthous, Gabriel
- Gebundenes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Bring your data presentations into focus with this comprehensive guide to SAP BusinessObjects Web Intelligence. Updated for Webi 4.2, this book will teach you to create, design, and share your reports, while exploring the fundamentals of Webi and its extended capabilities. This fourth edition includes information on data source options for building new documents and queries, and a new HTML5-based viewing interface. Punch up your reporting and analysis!
a. SAP BI 4.2 SP4 Dive into Web Intelligence 4.2 enhancements and platform improvements, including a new HTML5 user interface, support for…mehr
Andere Kunden interessierten sich auch für
- Uwe BrückPraxishandbuch SAP-Controlling59,90 €
- Mohammad NasrollahniyaBusiness Intelligence for Competitive Advantage in Insurance Industry42,99 €
- Alan SimonEnterprise Business Intelligence and Data Warehousing39,99 €
- Hannes ReiterFinancial Governance32,95 €
- Alexander GaryBusiness Intelligence49,00 €
- Federico NardiBusiness Intelligence23,90 €
- Business Intelligence Techniques74,99 €
-
-
-
Bring your data presentations into focus with this comprehensive guide to SAP BusinessObjects Web Intelligence. Updated for Webi 4.2, this book will teach you to create, design, and share your reports, while exploring the fundamentals of Webi and its extended capabilities. This fourth edition includes information on data source options for building new documents and queries, and a new HTML5-based viewing interface. Punch up your reporting and analysis!
a. SAP BI 4.2 SP4
Dive into Web Intelligence 4.2 enhancements and platform improvements, including a new HTML5 user interface, support for geomaps, and access to additional data sources.
b.Webi from A to Z
Get the complete picture of working with Web Intelligence, from creation to publication. From the first step to the last, learn how to design reports that make an impact with this comprehensive guide.
c.Web Intelligence Interactive Viewer
Discover the HTML5-based Web Intelligence Interactive Viewer and BI launchpad, a fully integrated interface for organizing, viewing, analyzing, and sharing business intelligence content.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
a. SAP BI 4.2 SP4
Dive into Web Intelligence 4.2 enhancements and platform improvements, including a new HTML5 user interface, support for geomaps, and access to additional data sources.
b.Webi from A to Z
Get the complete picture of working with Web Intelligence, from creation to publication. From the first step to the last, learn how to design reports that make an impact with this comprehensive guide.
c.Web Intelligence Interactive Viewer
Discover the HTML5-based Web Intelligence Interactive Viewer and BI launchpad, a fully integrated interface for organizing, viewing, analyzing, and sharing business intelligence content.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Produktdetails
- Produktdetails
- SAP PRESS Englisch
- Verlag: Rheinwerk Verlag / SAP PRESS
- Artikelnr. des Verlages: 459/21547
- 4th Ed.
- Seitenzahl: 814
- Erscheinungstermin: 23. Oktober 2017
- Englisch
- Abmessung: 233mm x 179mm x 55mm
- Gewicht: 1627g
- ISBN-13: 9781493215478
- ISBN-10: 1493215477
- Artikelnr.: 48179608
- SAP PRESS Englisch
- Verlag: Rheinwerk Verlag / SAP PRESS
- Artikelnr. des Verlages: 459/21547
- 4th Ed.
- Seitenzahl: 814
- Erscheinungstermin: 23. Oktober 2017
- Englisch
- Abmessung: 233mm x 179mm x 55mm
- Gewicht: 1627g
- ISBN-13: 9781493215478
- ISBN-10: 1493215477
- Artikelnr.: 48179608
Christian Ah-Soon has worked for SAP BusinessObjects for 15 years as a program manager on transversal areas like administration, security, internationalization, installation, semantic layers, and SDKs. He is co-author of SAP BusinessObjects BI Security (SAP PRESS, 2013) and Universe Design with SAP BusinessObjects BI: The Comprehensive Guide (SAP PRESS, 2014). Christian holds a Ph.D. in computer science and graduated from TELECOM Nancy.
1 ... Introduction to SAP BusinessObjects Web Intelligence ... 25
1.1 ... Features of Web Intelligence 4.2 ... 26
1.2 ... Web Intelligence Clients ... 32
1.3 ... Web Intelligence Preferences ... 36
1.4 ... What's New in Web Intelligence 4.2 SP 3 and SP 4 ... 41
1.5 ... Summary ... 43
2 ... Creating New Documents and Queries ... 45
2.1 ... Creating a Web Intelligence Document from a Universe ... 45
2.2 ... The Query Panel in Web Intelligence ... 51
2.3 ... Query Filters ... 61
2.4 ... Prompted Queries ... 67
2.5 ... Saving Your Document in the BI Platform Repository ... 71
2.6 ... Other Data Sources ... 76
2.7 ... Document Options ... 89
2.8 ... Summary ... 92
3 ... Creating a Report in Web Intelligence ... 95
3.1 ... Adding Data to Report Elements ... 96
3.2 ... Sections and Breaks ... 99
3.3 ... Outline Navigation ... 105
3.4 ... Enhanced Sorting and Ranking ... 109
3.5 ... Conditional Formatting ... 118
3.6 ... Headers, Footers, and Background Images ... 122
3.7 ... Summary ... 126
4 ... The Web Intelligence Report Panel ... 129
4.1 ... The Web Intelligence Reporting Interface ... 129
4.2 ... Reporting Toolbars ... 132
4.3 ... The Side Panel ... 143
4.4 ... Report Panel ... 147
4.5 ... Report Property Categories ... 151
4.6 ... Summary ... 159
5 ... Displaying Data with Tables ... 161
5.1 ... Using Tables ... 164
5.2 ... Table Types ... 180
5.3 ... Converting Table Formats and Types ... 183
5.4 ... Blank Cells, Predefined Cells, and Comment Cells ... 185
5.5 ... Summary ... 188
6 ... Displaying Data with Charts ... 191
6.1 ... Adding Charts to a Report ... 192
6.2 ... Chart Types ... 198
6.3 ... Chart Properties ... 225
6.4 ... Zone Formatting ... 229
6.5 ... Custom Elements ... 230
6.6 ... Summary ... 234
7 ... Making an Impact with Charts ... 237
7.1 ... Properties That Enhance the Display of Data ... 238
7.2 ... Hierarchical Charting with Relational Data ... 244
7.3 ... Reports Functioning as Dashboards ... 246
7.4 ... Formatting Tips ... 248
7.5 ... Custom Color Enhancements ... 252
7.6 ... Summary ... 258
8 ... Report Properties, Tools, and Formatting ... 259
8.1 ... Formatting Report Properties ... 259
8.2 ... Document Summary ... 261
8.3 ... Navigation (Report) Map ... 265
8.4 ... Input Controls ... 266
8.5 ... Web Services Publisher ... 274
8.6 ... Available Objects (Design Mode Only) ... 277
8.7 ... Document Structures and Filters ... 279
8.8 ... Data ... 280
8.9 ... Style Sheet Modification ... 282
8.10 ... High Precision Numbers ... 287
8.11 ... Geolocalizing a Dimension ... 288
8.12 ... Summary ... 295
9 ... Filtering Data in the Query Panel and Report Panel ... 297
9.1 ... Filtering in the Query Panel ... 298
9.2 ... Complex Filtering Options ... 310
9.3 ... Filtering in the Report Panel ... 323
9.4 ... Conditionally Hiding Report Elements ... 342
9.5 ... Element Linking ... 344
9.6 ... Summary ... 350
10 ... Scope of Analysis and Drill Functionality ... 351
10.1 ... Setting the Scope of Analysis in the Query Panel ... 352
10.2 ... Drill-Down Setup in the Report Panel ... 359
10.3 ... Drilling on Tables ... 360
10.4 ... Drilling on Charts ... 366
10.5 ... Taking a Snapshot ... 370
10.6 ... Drill Options ... 371
10.7 ... Summary ... 374
11 ... Using Formulas and Variables ... 375
11.1 ... Formulas and Variables ... 376
11.2 ... Custom Grouping ... 383
11.3 ... Reporting Functions and Operators ... 386
11.4 ... Formula Syntax ... 404
11.5 ... Input, Output, and Calculation Contexts ... 407
11.6 ... References ... 414
11.7 ... Summary ... 417
12 ... Advanced Query Panel Functionalities ... 419
12.1 ... Cascading and Optional Prompts ... 420
12.2 ... Saving Prompts Answers in BI Variants ... 424
12.3 ... Querying Multidimensional Data Sources ... 427
12.4 ... Editing Auto-Generated SQL Scripts ... 440
12.5 ... Support of Query Stripping ... 442
12.6 ... Partial Results, Purged Data, and Cancelled Queries ... 444
12.7 ... Summary ... 447
13 ... Access to SAP BW and SAP HANA ... 449
13.1 ... SAP BW and SAP HANA Access Overview ... 449
13.2 ... SAP BEx Query through Direct Access ... 452
13.3 ... SAP BEx Query through Multidimensional Universe ... 459
13.4 ... SAP BW through Relational Universe ... 462
13.5 ... SAP HANA Direct Access ... 464
13.6 ... SAP HANA Online Mode ... 471
13.7 ... SAP HANA View through Relational Universe ... 477
13.8 ... SAP HANA through Free-Hand SQL ... 479
13.9 ... Summary ... 479
14 ... Using Multiple Queries and Data Sources ... 481
14.1 ... Setting Up a Combined Query ... 481
14.2 ... Adding a New Query ... 484
14.3 ... Managing Queries ... 491
14.4 ... Running Multiple Queries ... 492
14.5 ... Merging Dimensions ... 494
14.6 ... Merging Variables ... 506
14.7 ... Changing Source ... 507
14.8 ... Summary ... 515
15 ... Adding Hyperlinks in Web Intelligence Documents ... 517
15.1 ... Linking to Document with the HTML Client ... 518
15.2 ... Linking to the Web Page URL ... 527
15.3 ... OpenDocument Syntax ... 536
15.4 ... Summary ... 540
16 ... Working in the BI Launch Pad ... 541
16.1 ... Navigating in BI Launch Pad ... 541
16.2 ... Setting BI Launch Pad Preferences ... 550
16.3 ... Organizing in Folders and Categories ... 553
16.4 ... Deleting Documents and the Recycle Bin ... 557
16.5 ... Viewing, Printing, and Saving Objects in BI Launch Pad ... 558
16.6 ... Summary ... 561
17 ... Using Web Intelligence with SAP BusinessObjects BI Workspaces ... 563
17.1 ... Introducing BI Workspaces ... 563
17.2 ... Working with Modules ... 572
17.3 ... Working with Web Intelligence Report Parts ... 574
17.4 ... Using a BI Workspace as the Default Home Tab ... 581
17.5 ... Printing BI Workspaces ... 583
17.6 ... Content Linking ... 584
17.7 ... Summary ... 589
18 ... Interaction from a User's Perspective ... 591
18.1 ... Creating Shortcuts and Hyperlinks ... 591
18.2 ... Searching within the BI Launch Pad ... 593
18.3 ... Sorting and Filtering Content ... 598
18.4 ... Creating Discussions ... 600
18.5 ... Commenting Documents ... 601
18.6 ... Tracking Data Changes ... 607
18.7 ... Summary ... 615
19 ... Sharing Web Intelligence Content ... 617
19.1 ... Sharing Document Content through Shared Elements ... 617
19.2 ... Using the Send Feature in BI Launch Pad ... 626
19.3 ... Exporting a Web Intelligence Report ... 632
19.4 ... Scheduling a Web Intelligence Report ... 636
19.5 ... Summary ... 643
20 ... Report Scheduling and Distribution with Publications ... 645
20.1 ... Publication Roles ... 646
20.2 ... Creating a Publication ... 648
20.3 ... Mobile Publications ... 661
20.4 ... Summary ... 662
21 ... Web Intelligence Rich Client ... 665
21.1 ... How Web Intelligence Rich Client Is Different ... 665
21.2 ... Data Provider Options ... 670
21.3 ... Working with Web Intelligence Reports ... 672
21.4 ... Setting Preferences in Web Intelligence Rich Client ... 679
21.5 ... Summary ... 680
22 ... Web Intelligence Interactive Viewer ... 681
22.1 ... New BI Launch Pad and Web Intelligence Interactive Viewer Overview ... 681
22.2 ... Navigating in the New BI Launch Pad ... 682
22.3 ... Viewing a Document ... 685
22.4 ... Refreshing a Document ... 690
22.5 ... Filtering a Report ... 693
22.6 ... Sorting or Ranking Data in a Report ... 697
22.7 ... Scheduling a Document ... 700
22.8 ... Saving and Exporting to XLS and to PDF ... 703
22.9 ... Setting Web Intelligence Preferences ... 703
22.10 ... Logging Out ... 704
22.11 ... Summary ... 704
23 ... Connecting SAP BusinessObjects Live Office to Web Intelligence and Universes ... 705
23.1 ... Introduction to SAP BusinessObjects Live Office ... 705
23.2 ... Creating Queries from Universes ... 709
23.3 ... Retrieving Web Intelligence Content ... 713
23.4 ... Editing Added Content ... 718
23.5 ... Setting Preferences ... 719
23.6 ... Summary ... 725
24 ... Mobile Business Intelligence ... 727
24.1 ... Introducing SAP BusinessObjects Mobile ... 727
24.2 ... Designing Reports for Mobile Viewing ... 728
24.3 ... Mobile-Only Analytic Types ... 742
24.4 ... Report Linking ... 754
24.5 ... Input Controls ... 756
24.6 ... Mobile Thumbnails ... 758
24.7 ... Summary ... 759
... Appendices ... 761
A ... Converting Desktop Intelligence Reports to Web Intelligence Documents ... 763
B ... Web Intelligence Security Rights ... 777
1.1 ... Features of Web Intelligence 4.2 ... 26
1.2 ... Web Intelligence Clients ... 32
1.3 ... Web Intelligence Preferences ... 36
1.4 ... What's New in Web Intelligence 4.2 SP 3 and SP 4 ... 41
1.5 ... Summary ... 43
2 ... Creating New Documents and Queries ... 45
2.1 ... Creating a Web Intelligence Document from a Universe ... 45
2.2 ... The Query Panel in Web Intelligence ... 51
2.3 ... Query Filters ... 61
2.4 ... Prompted Queries ... 67
2.5 ... Saving Your Document in the BI Platform Repository ... 71
2.6 ... Other Data Sources ... 76
2.7 ... Document Options ... 89
2.8 ... Summary ... 92
3 ... Creating a Report in Web Intelligence ... 95
3.1 ... Adding Data to Report Elements ... 96
3.2 ... Sections and Breaks ... 99
3.3 ... Outline Navigation ... 105
3.4 ... Enhanced Sorting and Ranking ... 109
3.5 ... Conditional Formatting ... 118
3.6 ... Headers, Footers, and Background Images ... 122
3.7 ... Summary ... 126
4 ... The Web Intelligence Report Panel ... 129
4.1 ... The Web Intelligence Reporting Interface ... 129
4.2 ... Reporting Toolbars ... 132
4.3 ... The Side Panel ... 143
4.4 ... Report Panel ... 147
4.5 ... Report Property Categories ... 151
4.6 ... Summary ... 159
5 ... Displaying Data with Tables ... 161
5.1 ... Using Tables ... 164
5.2 ... Table Types ... 180
5.3 ... Converting Table Formats and Types ... 183
5.4 ... Blank Cells, Predefined Cells, and Comment Cells ... 185
5.5 ... Summary ... 188
6 ... Displaying Data with Charts ... 191
6.1 ... Adding Charts to a Report ... 192
6.2 ... Chart Types ... 198
6.3 ... Chart Properties ... 225
6.4 ... Zone Formatting ... 229
6.5 ... Custom Elements ... 230
6.6 ... Summary ... 234
7 ... Making an Impact with Charts ... 237
7.1 ... Properties That Enhance the Display of Data ... 238
7.2 ... Hierarchical Charting with Relational Data ... 244
7.3 ... Reports Functioning as Dashboards ... 246
7.4 ... Formatting Tips ... 248
7.5 ... Custom Color Enhancements ... 252
7.6 ... Summary ... 258
8 ... Report Properties, Tools, and Formatting ... 259
8.1 ... Formatting Report Properties ... 259
8.2 ... Document Summary ... 261
8.3 ... Navigation (Report) Map ... 265
8.4 ... Input Controls ... 266
8.5 ... Web Services Publisher ... 274
8.6 ... Available Objects (Design Mode Only) ... 277
8.7 ... Document Structures and Filters ... 279
8.8 ... Data ... 280
8.9 ... Style Sheet Modification ... 282
8.10 ... High Precision Numbers ... 287
8.11 ... Geolocalizing a Dimension ... 288
8.12 ... Summary ... 295
9 ... Filtering Data in the Query Panel and Report Panel ... 297
9.1 ... Filtering in the Query Panel ... 298
9.2 ... Complex Filtering Options ... 310
9.3 ... Filtering in the Report Panel ... 323
9.4 ... Conditionally Hiding Report Elements ... 342
9.5 ... Element Linking ... 344
9.6 ... Summary ... 350
10 ... Scope of Analysis and Drill Functionality ... 351
10.1 ... Setting the Scope of Analysis in the Query Panel ... 352
10.2 ... Drill-Down Setup in the Report Panel ... 359
10.3 ... Drilling on Tables ... 360
10.4 ... Drilling on Charts ... 366
10.5 ... Taking a Snapshot ... 370
10.6 ... Drill Options ... 371
10.7 ... Summary ... 374
11 ... Using Formulas and Variables ... 375
11.1 ... Formulas and Variables ... 376
11.2 ... Custom Grouping ... 383
11.3 ... Reporting Functions and Operators ... 386
11.4 ... Formula Syntax ... 404
11.5 ... Input, Output, and Calculation Contexts ... 407
11.6 ... References ... 414
11.7 ... Summary ... 417
12 ... Advanced Query Panel Functionalities ... 419
12.1 ... Cascading and Optional Prompts ... 420
12.2 ... Saving Prompts Answers in BI Variants ... 424
12.3 ... Querying Multidimensional Data Sources ... 427
12.4 ... Editing Auto-Generated SQL Scripts ... 440
12.5 ... Support of Query Stripping ... 442
12.6 ... Partial Results, Purged Data, and Cancelled Queries ... 444
12.7 ... Summary ... 447
13 ... Access to SAP BW and SAP HANA ... 449
13.1 ... SAP BW and SAP HANA Access Overview ... 449
13.2 ... SAP BEx Query through Direct Access ... 452
13.3 ... SAP BEx Query through Multidimensional Universe ... 459
13.4 ... SAP BW through Relational Universe ... 462
13.5 ... SAP HANA Direct Access ... 464
13.6 ... SAP HANA Online Mode ... 471
13.7 ... SAP HANA View through Relational Universe ... 477
13.8 ... SAP HANA through Free-Hand SQL ... 479
13.9 ... Summary ... 479
14 ... Using Multiple Queries and Data Sources ... 481
14.1 ... Setting Up a Combined Query ... 481
14.2 ... Adding a New Query ... 484
14.3 ... Managing Queries ... 491
14.4 ... Running Multiple Queries ... 492
14.5 ... Merging Dimensions ... 494
14.6 ... Merging Variables ... 506
14.7 ... Changing Source ... 507
14.8 ... Summary ... 515
15 ... Adding Hyperlinks in Web Intelligence Documents ... 517
15.1 ... Linking to Document with the HTML Client ... 518
15.2 ... Linking to the Web Page URL ... 527
15.3 ... OpenDocument Syntax ... 536
15.4 ... Summary ... 540
16 ... Working in the BI Launch Pad ... 541
16.1 ... Navigating in BI Launch Pad ... 541
16.2 ... Setting BI Launch Pad Preferences ... 550
16.3 ... Organizing in Folders and Categories ... 553
16.4 ... Deleting Documents and the Recycle Bin ... 557
16.5 ... Viewing, Printing, and Saving Objects in BI Launch Pad ... 558
16.6 ... Summary ... 561
17 ... Using Web Intelligence with SAP BusinessObjects BI Workspaces ... 563
17.1 ... Introducing BI Workspaces ... 563
17.2 ... Working with Modules ... 572
17.3 ... Working with Web Intelligence Report Parts ... 574
17.4 ... Using a BI Workspace as the Default Home Tab ... 581
17.5 ... Printing BI Workspaces ... 583
17.6 ... Content Linking ... 584
17.7 ... Summary ... 589
18 ... Interaction from a User's Perspective ... 591
18.1 ... Creating Shortcuts and Hyperlinks ... 591
18.2 ... Searching within the BI Launch Pad ... 593
18.3 ... Sorting and Filtering Content ... 598
18.4 ... Creating Discussions ... 600
18.5 ... Commenting Documents ... 601
18.6 ... Tracking Data Changes ... 607
18.7 ... Summary ... 615
19 ... Sharing Web Intelligence Content ... 617
19.1 ... Sharing Document Content through Shared Elements ... 617
19.2 ... Using the Send Feature in BI Launch Pad ... 626
19.3 ... Exporting a Web Intelligence Report ... 632
19.4 ... Scheduling a Web Intelligence Report ... 636
19.5 ... Summary ... 643
20 ... Report Scheduling and Distribution with Publications ... 645
20.1 ... Publication Roles ... 646
20.2 ... Creating a Publication ... 648
20.3 ... Mobile Publications ... 661
20.4 ... Summary ... 662
21 ... Web Intelligence Rich Client ... 665
21.1 ... How Web Intelligence Rich Client Is Different ... 665
21.2 ... Data Provider Options ... 670
21.3 ... Working with Web Intelligence Reports ... 672
21.4 ... Setting Preferences in Web Intelligence Rich Client ... 679
21.5 ... Summary ... 680
22 ... Web Intelligence Interactive Viewer ... 681
22.1 ... New BI Launch Pad and Web Intelligence Interactive Viewer Overview ... 681
22.2 ... Navigating in the New BI Launch Pad ... 682
22.3 ... Viewing a Document ... 685
22.4 ... Refreshing a Document ... 690
22.5 ... Filtering a Report ... 693
22.6 ... Sorting or Ranking Data in a Report ... 697
22.7 ... Scheduling a Document ... 700
22.8 ... Saving and Exporting to XLS and to PDF ... 703
22.9 ... Setting Web Intelligence Preferences ... 703
22.10 ... Logging Out ... 704
22.11 ... Summary ... 704
23 ... Connecting SAP BusinessObjects Live Office to Web Intelligence and Universes ... 705
23.1 ... Introduction to SAP BusinessObjects Live Office ... 705
23.2 ... Creating Queries from Universes ... 709
23.3 ... Retrieving Web Intelligence Content ... 713
23.4 ... Editing Added Content ... 718
23.5 ... Setting Preferences ... 719
23.6 ... Summary ... 725
24 ... Mobile Business Intelligence ... 727
24.1 ... Introducing SAP BusinessObjects Mobile ... 727
24.2 ... Designing Reports for Mobile Viewing ... 728
24.3 ... Mobile-Only Analytic Types ... 742
24.4 ... Report Linking ... 754
24.5 ... Input Controls ... 756
24.6 ... Mobile Thumbnails ... 758
24.7 ... Summary ... 759
... Appendices ... 761
A ... Converting Desktop Intelligence Reports to Web Intelligence Documents ... 763
B ... Web Intelligence Security Rights ... 777
1 ... Introduction to SAP BusinessObjects Web Intelligence ... 25
1.1 ... Features of Web Intelligence 4.2 ... 26
1.2 ... Web Intelligence Clients ... 32
1.3 ... Web Intelligence Preferences ... 36
1.4 ... What's New in Web Intelligence 4.2 SP 3 and SP 4 ... 41
1.5 ... Summary ... 43
2 ... Creating New Documents and Queries ... 45
2.1 ... Creating a Web Intelligence Document from a Universe ... 45
2.2 ... The Query Panel in Web Intelligence ... 51
2.3 ... Query Filters ... 61
2.4 ... Prompted Queries ... 67
2.5 ... Saving Your Document in the BI Platform Repository ... 71
2.6 ... Other Data Sources ... 76
2.7 ... Document Options ... 89
2.8 ... Summary ... 92
3 ... Creating a Report in Web Intelligence ... 95
3.1 ... Adding Data to Report Elements ... 96
3.2 ... Sections and Breaks ... 99
3.3 ... Outline Navigation ... 105
3.4 ... Enhanced Sorting and Ranking ... 109
3.5 ... Conditional Formatting ... 118
3.6 ... Headers, Footers, and Background Images ... 122
3.7 ... Summary ... 126
4 ... The Web Intelligence Report Panel ... 129
4.1 ... The Web Intelligence Reporting Interface ... 129
4.2 ... Reporting Toolbars ... 132
4.3 ... The Side Panel ... 143
4.4 ... Report Panel ... 147
4.5 ... Report Property Categories ... 151
4.6 ... Summary ... 159
5 ... Displaying Data with Tables ... 161
5.1 ... Using Tables ... 164
5.2 ... Table Types ... 180
5.3 ... Converting Table Formats and Types ... 183
5.4 ... Blank Cells, Predefined Cells, and Comment Cells ... 185
5.5 ... Summary ... 188
6 ... Displaying Data with Charts ... 191
6.1 ... Adding Charts to a Report ... 192
6.2 ... Chart Types ... 198
6.3 ... Chart Properties ... 225
6.4 ... Zone Formatting ... 229
6.5 ... Custom Elements ... 230
6.6 ... Summary ... 234
7 ... Making an Impact with Charts ... 237
7.1 ... Properties That Enhance the Display of Data ... 238
7.2 ... Hierarchical Charting with Relational Data ... 244
7.3 ... Reports Functioning as Dashboards ... 246
7.4 ... Formatting Tips ... 248
7.5 ... Custom Color Enhancements ... 252
7.6 ... Summary ... 258
8 ... Report Properties, Tools, and Formatting ... 259
8.1 ... Formatting Report Properties ... 259
8.2 ... Document Summary ... 261
8.3 ... Navigation (Report) Map ... 265
8.4 ... Input Controls ... 266
8.5 ... Web Services Publisher ... 274
8.6 ... Available Objects (Design Mode Only) ... 277
8.7 ... Document Structures and Filters ... 279
8.8 ... Data ... 280
8.9 ... Style Sheet Modification ... 282
8.10 ... High Precision Numbers ... 287
8.11 ... Geolocalizing a Dimension ... 288
8.12 ... Summary ... 295
9 ... Filtering Data in the Query Panel and Report Panel ... 297
9.1 ... Filtering in the Query Panel ... 298
9.2 ... Complex Filtering Options ... 310
9.3 ... Filtering in the Report Panel ... 323
9.4 ... Conditionally Hiding Report Elements ... 342
9.5 ... Element Linking ... 344
9.6 ... Summary ... 350
10 ... Scope of Analysis and Drill Functionality ... 351
10.1 ... Setting the Scope of Analysis in the Query Panel ... 352
10.2 ... Drill-Down Setup in the Report Panel ... 359
10.3 ... Drilling on Tables ... 360
10.4 ... Drilling on Charts ... 366
10.5 ... Taking a Snapshot ... 370
10.6 ... Drill Options ... 371
10.7 ... Summary ... 374
11 ... Using Formulas and Variables ... 375
11.1 ... Formulas and Variables ... 376
11.2 ... Custom Grouping ... 383
11.3 ... Reporting Functions and Operators ... 386
11.4 ... Formula Syntax ... 404
11.5 ... Input, Output, and Calculation Contexts ... 407
11.6 ... References ... 414
11.7 ... Summary ... 417
12 ... Advanced Query Panel Functionalities ... 419
12.1 ... Cascading and Optional Prompts ... 420
12.2 ... Saving Prompts Answers in BI Variants ... 424
12.3 ... Querying Multidimensional Data Sources ... 427
12.4 ... Editing Auto-Generated SQL Scripts ... 440
12.5 ... Support of Query Stripping ... 442
12.6 ... Partial Results, Purged Data, and Cancelled Queries ... 444
12.7 ... Summary ... 447
13 ... Access to SAP BW and SAP HANA ... 449
13.1 ... SAP BW and SAP HANA Access Overview ... 449
13.2 ... SAP BEx Query through Direct Access ... 452
13.3 ... SAP BEx Query through Multidimensional Universe ... 459
13.4 ... SAP BW through Relational Universe ... 462
13.5 ... SAP HANA Direct Access ... 464
13.6 ... SAP HANA Online Mode ... 471
13.7 ... SAP HANA View through Relational Universe ... 477
13.8 ... SAP HANA through Free-Hand SQL ... 479
13.9 ... Summary ... 479
14 ... Using Multiple Queries and Data Sources ... 481
14.1 ... Setting Up a Combined Query ... 481
14.2 ... Adding a New Query ... 484
14.3 ... Managing Queries ... 491
14.4 ... Running Multiple Queries ... 492
14.5 ... Merging Dimensions ... 494
14.6 ... Merging Variables ... 506
14.7 ... Changing Source ... 507
14.8 ... Summary ... 515
15 ... Adding Hyperlinks in Web Intelligence Documents ... 517
15.1 ... Linking to Document with the HTML Client ... 518
15.2 ... Linking to the Web Page URL ... 527
15.3 ... OpenDocument Syntax ... 536
15.4 ... Summary ... 540
16 ... Working in the BI Launch Pad ... 541
16.1 ... Navigating in BI Launch Pad ... 541
16.2 ... Setting BI Launch Pad Preferences ... 550
16.3 ... Organizing in Folders and Categories ... 553
16.4 ... Deleting Documents and the Recycle Bin ... 557
16.5 ... Viewing, Printing, and Saving Objects in BI Launch Pad ... 558
16.6 ... Summary ... 561
17 ... Using Web Intelligence with SAP BusinessObjects BI Workspaces ... 563
17.1 ... Introducing BI Workspaces ... 563
17.2 ... Working with Modules ... 572
17.3 ... Working with Web Intelligence Report Parts ... 574
17.4 ... Using a BI Workspace as the Default Home Tab ... 581
17.5 ... Printing BI Workspaces ... 583
17.6 ... Content Linking ... 584
17.7 ... Summary ... 589
18 ... Interaction from a User's Perspective ... 591
18.1 ... Creating Shortcuts and Hyperlinks ... 591
18.2 ... Searching within the BI Launch Pad ... 593
18.3 ... Sorting and Filtering Content ... 598
18.4 ... Creating Discussions ... 600
18.5 ... Commenting Documents ... 601
18.6 ... Tracking Data Changes ... 607
18.7 ... Summary ... 615
19 ... Sharing Web Intelligence Content ... 617
19.1 ... Sharing Document Content through Shared Elements ... 617
19.2 ... Using the Send Feature in BI Launch Pad ... 626
19.3 ... Exporting a Web Intelligence Report ... 632
19.4 ... Scheduling a Web Intelligence Report ... 636
19.5 ... Summary ... 643
20 ... Report Scheduling and Distribution with Publications ... 645
20.1 ... Publication Roles ... 646
20.2 ... Creating a Publication ... 648
20.3 ... Mobile Publications ... 661
20.4 ... Summary ... 662
21 ... Web Intelligence Rich Client ... 665
21.1 ... How Web Intelligence Rich Client Is Different ... 665
21.2 ... Data Provider Options ... 670
21.3 ... Working with Web Intelligence Reports ... 672
21.4 ... Setting Preferences in Web Intelligence Rich Client ... 679
21.5 ... Summary ... 680
22 ... Web Intelligence Interactive Viewer ... 681
22.1 ... New BI Launch Pad and Web Intelligence Interactive Viewer Overview ... 681
22.2 ... Navigating in the New BI Launch Pad ... 682
22.3 ... Viewing a Document ... 685
22.4 ... Refreshing a Document ... 690
22.5 ... Filtering a Report ... 693
22.6 ... Sorting or Ranking Data in a Report ... 697
22.7 ... Scheduling a Document ... 700
22.8 ... Saving and Exporting to XLS and to PDF ... 703
22.9 ... Setting Web Intelligence Preferences ... 703
22.10 ... Logging Out ... 704
22.11 ... Summary ... 704
23 ... Connecting SAP BusinessObjects Live Office to Web Intelligence and Universes ... 705
23.1 ... Introduction to SAP BusinessObjects Live Office ... 705
23.2 ... Creating Queries from Universes ... 709
23.3 ... Retrieving Web Intelligence Content ... 713
23.4 ... Editing Added Content ... 718
23.5 ... Setting Preferences ... 719
23.6 ... Summary ... 725
24 ... Mobile Business Intelligence ... 727
24.1 ... Introducing SAP BusinessObjects Mobile ... 727
24.2 ... Designing Reports for Mobile Viewing ... 728
24.3 ... Mobile-Only Analytic Types ... 742
24.4 ... Report Linking ... 754
24.5 ... Input Controls ... 756
24.6 ... Mobile Thumbnails ... 758
24.7 ... Summary ... 759
... Appendices ... 761
A ... Converting Desktop Intelligence Reports to Web Intelligence Documents ... 763
B ... Web Intelligence Security Rights ... 777
1.1 ... Features of Web Intelligence 4.2 ... 26
1.2 ... Web Intelligence Clients ... 32
1.3 ... Web Intelligence Preferences ... 36
1.4 ... What's New in Web Intelligence 4.2 SP 3 and SP 4 ... 41
1.5 ... Summary ... 43
2 ... Creating New Documents and Queries ... 45
2.1 ... Creating a Web Intelligence Document from a Universe ... 45
2.2 ... The Query Panel in Web Intelligence ... 51
2.3 ... Query Filters ... 61
2.4 ... Prompted Queries ... 67
2.5 ... Saving Your Document in the BI Platform Repository ... 71
2.6 ... Other Data Sources ... 76
2.7 ... Document Options ... 89
2.8 ... Summary ... 92
3 ... Creating a Report in Web Intelligence ... 95
3.1 ... Adding Data to Report Elements ... 96
3.2 ... Sections and Breaks ... 99
3.3 ... Outline Navigation ... 105
3.4 ... Enhanced Sorting and Ranking ... 109
3.5 ... Conditional Formatting ... 118
3.6 ... Headers, Footers, and Background Images ... 122
3.7 ... Summary ... 126
4 ... The Web Intelligence Report Panel ... 129
4.1 ... The Web Intelligence Reporting Interface ... 129
4.2 ... Reporting Toolbars ... 132
4.3 ... The Side Panel ... 143
4.4 ... Report Panel ... 147
4.5 ... Report Property Categories ... 151
4.6 ... Summary ... 159
5 ... Displaying Data with Tables ... 161
5.1 ... Using Tables ... 164
5.2 ... Table Types ... 180
5.3 ... Converting Table Formats and Types ... 183
5.4 ... Blank Cells, Predefined Cells, and Comment Cells ... 185
5.5 ... Summary ... 188
6 ... Displaying Data with Charts ... 191
6.1 ... Adding Charts to a Report ... 192
6.2 ... Chart Types ... 198
6.3 ... Chart Properties ... 225
6.4 ... Zone Formatting ... 229
6.5 ... Custom Elements ... 230
6.6 ... Summary ... 234
7 ... Making an Impact with Charts ... 237
7.1 ... Properties That Enhance the Display of Data ... 238
7.2 ... Hierarchical Charting with Relational Data ... 244
7.3 ... Reports Functioning as Dashboards ... 246
7.4 ... Formatting Tips ... 248
7.5 ... Custom Color Enhancements ... 252
7.6 ... Summary ... 258
8 ... Report Properties, Tools, and Formatting ... 259
8.1 ... Formatting Report Properties ... 259
8.2 ... Document Summary ... 261
8.3 ... Navigation (Report) Map ... 265
8.4 ... Input Controls ... 266
8.5 ... Web Services Publisher ... 274
8.6 ... Available Objects (Design Mode Only) ... 277
8.7 ... Document Structures and Filters ... 279
8.8 ... Data ... 280
8.9 ... Style Sheet Modification ... 282
8.10 ... High Precision Numbers ... 287
8.11 ... Geolocalizing a Dimension ... 288
8.12 ... Summary ... 295
9 ... Filtering Data in the Query Panel and Report Panel ... 297
9.1 ... Filtering in the Query Panel ... 298
9.2 ... Complex Filtering Options ... 310
9.3 ... Filtering in the Report Panel ... 323
9.4 ... Conditionally Hiding Report Elements ... 342
9.5 ... Element Linking ... 344
9.6 ... Summary ... 350
10 ... Scope of Analysis and Drill Functionality ... 351
10.1 ... Setting the Scope of Analysis in the Query Panel ... 352
10.2 ... Drill-Down Setup in the Report Panel ... 359
10.3 ... Drilling on Tables ... 360
10.4 ... Drilling on Charts ... 366
10.5 ... Taking a Snapshot ... 370
10.6 ... Drill Options ... 371
10.7 ... Summary ... 374
11 ... Using Formulas and Variables ... 375
11.1 ... Formulas and Variables ... 376
11.2 ... Custom Grouping ... 383
11.3 ... Reporting Functions and Operators ... 386
11.4 ... Formula Syntax ... 404
11.5 ... Input, Output, and Calculation Contexts ... 407
11.6 ... References ... 414
11.7 ... Summary ... 417
12 ... Advanced Query Panel Functionalities ... 419
12.1 ... Cascading and Optional Prompts ... 420
12.2 ... Saving Prompts Answers in BI Variants ... 424
12.3 ... Querying Multidimensional Data Sources ... 427
12.4 ... Editing Auto-Generated SQL Scripts ... 440
12.5 ... Support of Query Stripping ... 442
12.6 ... Partial Results, Purged Data, and Cancelled Queries ... 444
12.7 ... Summary ... 447
13 ... Access to SAP BW and SAP HANA ... 449
13.1 ... SAP BW and SAP HANA Access Overview ... 449
13.2 ... SAP BEx Query through Direct Access ... 452
13.3 ... SAP BEx Query through Multidimensional Universe ... 459
13.4 ... SAP BW through Relational Universe ... 462
13.5 ... SAP HANA Direct Access ... 464
13.6 ... SAP HANA Online Mode ... 471
13.7 ... SAP HANA View through Relational Universe ... 477
13.8 ... SAP HANA through Free-Hand SQL ... 479
13.9 ... Summary ... 479
14 ... Using Multiple Queries and Data Sources ... 481
14.1 ... Setting Up a Combined Query ... 481
14.2 ... Adding a New Query ... 484
14.3 ... Managing Queries ... 491
14.4 ... Running Multiple Queries ... 492
14.5 ... Merging Dimensions ... 494
14.6 ... Merging Variables ... 506
14.7 ... Changing Source ... 507
14.8 ... Summary ... 515
15 ... Adding Hyperlinks in Web Intelligence Documents ... 517
15.1 ... Linking to Document with the HTML Client ... 518
15.2 ... Linking to the Web Page URL ... 527
15.3 ... OpenDocument Syntax ... 536
15.4 ... Summary ... 540
16 ... Working in the BI Launch Pad ... 541
16.1 ... Navigating in BI Launch Pad ... 541
16.2 ... Setting BI Launch Pad Preferences ... 550
16.3 ... Organizing in Folders and Categories ... 553
16.4 ... Deleting Documents and the Recycle Bin ... 557
16.5 ... Viewing, Printing, and Saving Objects in BI Launch Pad ... 558
16.6 ... Summary ... 561
17 ... Using Web Intelligence with SAP BusinessObjects BI Workspaces ... 563
17.1 ... Introducing BI Workspaces ... 563
17.2 ... Working with Modules ... 572
17.3 ... Working with Web Intelligence Report Parts ... 574
17.4 ... Using a BI Workspace as the Default Home Tab ... 581
17.5 ... Printing BI Workspaces ... 583
17.6 ... Content Linking ... 584
17.7 ... Summary ... 589
18 ... Interaction from a User's Perspective ... 591
18.1 ... Creating Shortcuts and Hyperlinks ... 591
18.2 ... Searching within the BI Launch Pad ... 593
18.3 ... Sorting and Filtering Content ... 598
18.4 ... Creating Discussions ... 600
18.5 ... Commenting Documents ... 601
18.6 ... Tracking Data Changes ... 607
18.7 ... Summary ... 615
19 ... Sharing Web Intelligence Content ... 617
19.1 ... Sharing Document Content through Shared Elements ... 617
19.2 ... Using the Send Feature in BI Launch Pad ... 626
19.3 ... Exporting a Web Intelligence Report ... 632
19.4 ... Scheduling a Web Intelligence Report ... 636
19.5 ... Summary ... 643
20 ... Report Scheduling and Distribution with Publications ... 645
20.1 ... Publication Roles ... 646
20.2 ... Creating a Publication ... 648
20.3 ... Mobile Publications ... 661
20.4 ... Summary ... 662
21 ... Web Intelligence Rich Client ... 665
21.1 ... How Web Intelligence Rich Client Is Different ... 665
21.2 ... Data Provider Options ... 670
21.3 ... Working with Web Intelligence Reports ... 672
21.4 ... Setting Preferences in Web Intelligence Rich Client ... 679
21.5 ... Summary ... 680
22 ... Web Intelligence Interactive Viewer ... 681
22.1 ... New BI Launch Pad and Web Intelligence Interactive Viewer Overview ... 681
22.2 ... Navigating in the New BI Launch Pad ... 682
22.3 ... Viewing a Document ... 685
22.4 ... Refreshing a Document ... 690
22.5 ... Filtering a Report ... 693
22.6 ... Sorting or Ranking Data in a Report ... 697
22.7 ... Scheduling a Document ... 700
22.8 ... Saving and Exporting to XLS and to PDF ... 703
22.9 ... Setting Web Intelligence Preferences ... 703
22.10 ... Logging Out ... 704
22.11 ... Summary ... 704
23 ... Connecting SAP BusinessObjects Live Office to Web Intelligence and Universes ... 705
23.1 ... Introduction to SAP BusinessObjects Live Office ... 705
23.2 ... Creating Queries from Universes ... 709
23.3 ... Retrieving Web Intelligence Content ... 713
23.4 ... Editing Added Content ... 718
23.5 ... Setting Preferences ... 719
23.6 ... Summary ... 725
24 ... Mobile Business Intelligence ... 727
24.1 ... Introducing SAP BusinessObjects Mobile ... 727
24.2 ... Designing Reports for Mobile Viewing ... 728
24.3 ... Mobile-Only Analytic Types ... 742
24.4 ... Report Linking ... 754
24.5 ... Input Controls ... 756
24.6 ... Mobile Thumbnails ... 758
24.7 ... Summary ... 759
... Appendices ... 761
A ... Converting Desktop Intelligence Reports to Web Intelligence Documents ... 763
B ... Web Intelligence Security Rights ... 777