SAP BusinessObjects Web Intelligence

... Foreword ... 19

... Acknowledgments ... 21

1 ... SAP BusinessObjects Web Intelligence XI 3.1 ... 23
... 1.1 ... Features of Web Intelligence ... 23
... 1.2 ... Web Intelligence InfoView Preferences ... 29
... 1.3 ... Setting Web Intelligence Preferences in InfoView ... 30
... 1.4 ... Reporting Analysis Environments ... 36
... 1.5 ... Viewing and Saving Reports ... 37
... 1.6 ... Summary ... 39

2 ... The SAP BusinessObjects Universe ... 41
... 2.1 ... What Is a Universe ... 41
... 2.2 ... Publish a Universe to SAP BusinessObjects Enterprise ... 57
... 2.3 ... Using a Universe to Create a Web Intelligence Report ... 60
... 2.4 ... Getting to Know the Designer Toolbars ... 61
... 2.5 ... OLAP Universes ... 63
... 2.6 ... Summary ... 64

3 ... Creating a Web Intelligence XI 3.x Query ... 67
... 3.1 ... Tour of the Query Panel ... 68
... 3.2 ... Query Basics ... 74
... 3.3 ... Result Objects ... 84
... 3.4 ... Query Filters ... 86
... 3.5 ... Prompted Queries ... 94
... 3.6 ... Summary ... 96

4 ... Creating a Web Intelligence XI 3.x Report ... 99
... 4.1 ... The Web Intelligence Report Panel ... 100
... 4.2 ... Report Elements and Properties ... 109
... 4.3 ... Adding Data to Report Elements ... 114
... 4.4 ... Sections and Breaks ... 116
... 4.5 ... Sorting and Ranking ... 119
... 4.6 ... Alerters ... 126
... 4.7 ... Headers, Footers, and Background Images ... 130
... 4.8 ... Adjusting Page Layouts ... 132
... 4.9 ... Align and Relative Position ... 133
... 4.10 ... Summary ... 136

5 ... Filtering Data ... 139
... 5.1 ... Query Filtering ... 139
... 5.2 ... Report Filtering ... 149
... 5.3 ... Filtering Reports with Input Controls ... 159
... 5.4 ... Summary ... 162

6 ... Displaying Data with Tables ... 163
... 6.1 ... Using Tables ... 165
... 6.2 ... Table Types ... 172
... 6.3 ... Grouping Data ... 175
... 6.4 ... Converting Table Formats and Types ... 179
... 6.5 ... Free-Standing Cells ... 180
... 6.6 ... Summary ... 183

7 ... Formatting Web Intelligence Reports ... 185
... 7.1 ... Report Formatting ... 186
... 7.2 ... Formatting Sections and Breaks ... 190
... 7.3 ... Formatting Data Tables ... 197
... 7.4 ... Formatting Numbers and Dates ... 204
... 7.5 ... Formatting Table Values While Viewing Reports ... 211
... 7.6 ... Summary ... 214

8 ... Using Formulas and Variables ... 215
... 8.1 ... Formulas and Variables ... 216
... 8.2 ... Reporting Functions and Operators ... 222
... 8.3 ... Formula Syntax ... 235
... 8.4 ... Summary ... 239

9 ... Scope of Analysis and Drilling Down ... 241
... 9.1 ... Setting the Scope of Analysis in the Query Panel ... 242
... 9.2 ... Drill-Down Setup in the Report Panel ... 249
... 9.3 ... Query Drill Option ... 263
... 9.4 ... Taking a Snapshot ... 265
... 9.5 ... User Settings for Drill Down ... 265
... 9.6 ... Summary ... 267

10 ... Displaying Data with Charts ... 269
... 10.1 ... Chart Types ... 270
... 10.2 ... Chart Properties ... 287
... 10.3 ... Convert a Chart with Turn To ... 291
... 10.4 ... Adding Charts to a Report -- Viewing a Report ... 294
... 10.5 ... Summary ... 295

11 ... Working Within InfoView ... 297
... 11.1 ... Accessing InfoView ... 297
... 11.2 ... Navigating in InfoView ... 299
... 11.3 ... Setting InfoView Preferences ... 305
... 11.4 ... Organizing in Folders Versus Categories ... 309
... 11.5 ... Viewing, Printing, and Saving Objects in InfoView ... 312
... 11.6 ... Creating Shortcuts and Hyperlinks in InfoView ... 315
... 11.7 ... Tracking Data Changes ... 317
... 11.8 ... Searching within InfoView ... 322
... 11.9 ... Summary ... 324

12 ... Using Multiple Data Sources ... 325
... 12.1 ... Accessing Multiple Data Sources ... 325
... 12.2 ... Merging Dimensions ... 333
... 12.3 ... Data Synchronization ... 337
... 12.4 ... Working with Unsynchronized Data ... 340
... 12.5 ... Summary ... 343

13 ... Extending Query Panel Functionality ... 345
... 13.1 ... Complex Filtering Options ... 345
... 13.2 ... Cascading and Optional Prompts ... 351
... 13.3 ... Using Custom Freehand SQL ... 356
... 13.4 ... Visually Tracking Data Changes in the Report Panel ... 358
... 13.5 ... Summary ... 363

14 ... Advanced Universe Design Topics ... 365
... 14.1 ... @Functions ... 365
... 14.2 ... Linked Universes ... 377
... 14.3 ... Derived Tables ... 381
... 14.4 ... Lists of Values ... 384
... 14.5 ... Summary ... 385

15 ... Linking in Web Intelligence Reports ... 387
... 15.1 ... Adding Hyperlinks While Viewing Reports ... 387
... 15.2 ... Adding Hyperlinks While Creating or Editing Reports ... 396
... 15.3 ... OpenDocument Syntax ... 402
... 15.4 ... Summary ... 404

16 ... Sharing a Web Intelligence Report ... 407
... 16.1 ... Copying and Pasting to Another Application ... 407
... 16.2 ... Using the Send Feature in InfoView ... 409
... 16.3 ... Exporting a Web Intelligence Report ... 413
... 16.4 ... Scheduling a Web Intelligence Report ... 416
... 16.5 ... Creating Publications ... 423
... 16.6 ... Summary ... 430

17 ... Web Intelligence Rich Client ... 431
... 17.1 ... How Rich Client Is Different ... 431
... 17.2 ... Data Provider Options ... 435
... 17.3 ... Working with Web Intelligence Reports ... 437
... 17.4 ... Setting Preferences in Rich Client ... 446
... 17.5 ... Summary ... 447

18 ... Connecting SAP BusinessObjects Live Office to Web Intelligence XI 3.x ... 449
... 18.1 ... About Live Office ... 449
... 18.2 ... Creating Live Office Documents with Web Intelligence Content ... 452
... 18.3 ... Setting Preferences ... 456
... 18.4 ... Summary ... 462

19 ... Introducing the Web Intelligence SDK ... 463
... 19.1 ... What Can I Achieve with the SDK ... 464
... 19.2 ... Getting Started with the SDK ... 465
... 19.3 ... The Java Program Object ... 473
... 19.4 ... Selecting the Right SDKs ... 474
... 19.5 ... Setting Up the Development Environment ... 476
... 19.6 ... Building Applications ... 480
... 19.7 ... Summary ... 485

20 ... Customizing Web Intelligence Using Web Intelligence Extensions Points ... 487
... 20.1 ... What Are Web Intelligence Extensions Points ... 488
... 20.2 ... What Can I Achieve with Extension Points ... 490
... 20.3 ... Building Applications with Extension Points ... 491
... 20.4 ... Summary ... 511

21 ... Web Intelligence SDK Sample Applications ... 513
... 21.1 ... Connecting to the Central Management Server ... 514
... 21.2 ... Displaying a Document List ... 517
... 21.3 ... Amending the Viewer with Extension Points ... 525
... 21.4 ... Summary ... 527

22 ... Creating BI Widgets ... 529
... 22.1 ... About BI Widgets ... 530
... 22.2 ... Installation of BI Widgets Software ... 530
... 22.3 ... Creating BI Widgets Using Web Intelligence ... 532
... 22.4 ... Setting BI Widget Properties ... 535
... 22.5 ... Summary ... 538

... Appendices ... 539
... A ... Third-Party Vendors ... 541
... B ... Web Intelligence XI 3.1 Service Pack 2 ... 555
... C ... The Authors ... 561

... Index ... 563