Jim Brogden, Heather Sinkwitz, Dallas MarksThe Comprehensive Guide. Your one-stop reference for all things WebI. From report creation to publication, and everything in between. Updated for release 4.1, SAP HANA, and more
SAP BusinessObjects Web Intelligence
The Comprehensive Guide. Your one-stop reference for all things WebI. From report creation to publication, and everything in between. Updated for release 4.1, SAP HANA, and more
Mitarbeit: Orthous, Gabriel
Jim Brogden, Heather Sinkwitz, Dallas MarksThe Comprehensive Guide. Your one-stop reference for all things WebI. From report creation to publication, and everything in between. Updated for release 4.1, SAP HANA, and more
SAP BusinessObjects Web Intelligence
The Comprehensive Guide. Your one-stop reference for all things WebI. From report creation to publication, and everything in between. Updated for release 4.1, SAP HANA, and more
Mitarbeit: Orthous, Gabriel
- Gebundenes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Sharpen your data presentations with this comprehensive guide to SAP BusinessObjects Web Intelligence. From creating a report, to displaying data via charts, to sharing reports with others, get everything from the basics to the actionable details that inform your work. This third edition of our best-selling book on WebI includes UI and functionality changes for SAP BusinessObjects 4.1 and expanded coverage of new topics like SAP HANA and mobility. Make your reporting and analysis intelligent!
Web Intelligence 4.1 Flex your sales analysis and reporting muscles with usability improvements,…mehr
Sharpen your data presentations with this comprehensive guide to SAP BusinessObjects Web Intelligence. From creating a report, to displaying data via charts, to sharing reports with others, get everything from the basics to the actionable details that inform your work. This third edition of our best-selling book on WebI includes UI and functionality changes for SAP BusinessObjects 4.1 and expanded coverage of new topics like SAP HANA and mobility. Make your reporting and analysis intelligent!
Web Intelligence 4.1
Flex your sales analysis and reporting muscles with usability improvements, new language support, and enhanced workflows for SAP HANA and BW data sources with the newest version of WebI.
From Creation to Publication
Get the complete picture of working with WebI. From the first steps to the last, learn how to design reports that make an impact.
Mobile Integration
Explore the new features of SAP BusinessObjects Mobile 5.x and learn how you can provide advanced analyticson mobile devices.
Highlights:
Release 4.1
HTML and Java viewers
SAP HANA variable support
Report creation
Report Panel
Data filters
Drill-down
Query Panel functionality
BI Launch Pad
Enhanced BI Mobile features
Web Intelligence Rich Client
Galileo Press heißt jetzt Rheinwerk Verlag.
Web Intelligence 4.1
Flex your sales analysis and reporting muscles with usability improvements, new language support, and enhanced workflows for SAP HANA and BW data sources with the newest version of WebI.
From Creation to Publication
Get the complete picture of working with WebI. From the first steps to the last, learn how to design reports that make an impact.
Mobile Integration
Explore the new features of SAP BusinessObjects Mobile 5.x and learn how you can provide advanced analyticson mobile devices.
Highlights:
Release 4.1
HTML and Java viewers
SAP HANA variable support
Report creation
Report Panel
Data filters
Drill-down
Query Panel functionality
BI Launch Pad
Enhanced BI Mobile features
Web Intelligence Rich Client
Galileo Press heißt jetzt Rheinwerk Verlag.
Produktdetails
- Produktdetails
- SAP Press
- Verlag: Rheinwerk Verlag
- Artikelnr. des Verlages: 459/21057.
- 3rd Ed.
- Seitenzahl: 691
- Erscheinungstermin: 16. Oktober 2014
- Englisch
- Abmessung: 235mm x 180mm x 45mm
- Gewicht: 1439g
- ISBN-13: 9781493210572
- ISBN-10: 1493210572
- Artikelnr.: 40942376
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
- SAP Press
- Verlag: Rheinwerk Verlag
- Artikelnr. des Verlages: 459/21057.
- 3rd Ed.
- Seitenzahl: 691
- Erscheinungstermin: 16. Oktober 2014
- Englisch
- Abmessung: 235mm x 180mm x 45mm
- Gewicht: 1439g
- ISBN-13: 9781493210572
- ISBN-10: 1493210572
- Artikelnr.: 40942376
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
Jim Brogden is an award-winning technical author and dashboard designer, and a Senior Data Warehouse Developer for Intercontinental Exchange (ICE) in Atlanta, Georgia. He combines a master's degree in Information Technology with nearly ten years of business intelligence consulting experience and a proven track record for delivering BI solutions in a variety of industries. He's the lead author of all three official textbooks dedicated to Web Intelligence, and is an active contributor to SAP's Idea Place . A happily married father of sons Jamie and Hunter, in his off time Jim proclaims himself an avid (beginner) cricket player on the ICE Storm cricket team, a passionate hacker of the golf ball, and a runner (jogger/walker) of frequent (annual) 10Ks in Atlanta.
Heather Callebaut Sinkwitz gained her expertise while working as a business intelligence consultant, specializing as a certified SAP BusinessObjects instructor and solution provider. She currently dedicates herself to building innovative Business Intelligence solutions using a variety of technologies. A data junkie, she enjoys presenting meaningful information in new and unique ways to aid customers in making informed decisions. She remains actively involved in the BI community through participation in user groups and speaking engagements, both locally in her home state of Arizona or nationally. Currently, Heather is the Analytics and Reporting Product Manager for Trax Technologies (www.traxtech.com).
Dallas Marks is a principal technical architect and trainer for EV Technologies and an SAP Certified Application Associate for SAP BusinessObjects Web Intelligence and the Business Intelligence platform. Dallas has worked with SAP BusinessObjects BI tools since 2003 and has implemented solutions for a number of industries, including retail, energy, health care, and manufacturing. He is a frequent speaker at local ASUG chapters, national ASUG, and SAPinsider conferences, and independent SAP BusinessObjec
ts user groups. Dallas holds a master's degree in computer engineering from the University of Cincinnati. Dallas blogs about various business intelligence topics at You can follow him on Twitter at @dallasmarks.
Gabriel Orthous is a population health management and healthcare analytics expert, and a senior consultant to Wellcentive. Gabe has more than 15 years of business analytics managerial and software engineering experience with extensive expertise around business intelligence, financial reporting, and decision analytics. Gabe graduated from Mercer University with a master's degree in Business Administration and was inducted to the International Honor Society Beta Gamma Sigma in 2008. In addition, Gabe is chair for the Dashboarding and Visualization Special Interest Group for ASUG, co-chair for ASUG's Business Objects' Strategic SIG, and an active member of the Customer Advisory Council, as well as a renowned international speaker.
Heather Callebaut Sinkwitz gained her expertise while working as a business intelligence consultant, specializing as a certified SAP BusinessObjects instructor and solution provider. She currently dedicates herself to building innovative Business Intelligence solutions using a variety of technologies. A data junkie, she enjoys presenting meaningful information in new and unique ways to aid customers in making informed decisions. She remains actively involved in the BI community through participation in user groups and speaking engagements, both locally in her home state of Arizona or nationally. Currently, Heather is the Analytics and Reporting Product Manager for Trax Technologies (www.traxtech.com).
Dallas Marks is a principal technical architect and trainer for EV Technologies and an SAP Certified Application Associate for SAP BusinessObjects Web Intelligence and the Business Intelligence platform. Dallas has worked with SAP BusinessObjects BI tools since 2003 and has implemented solutions for a number of industries, including retail, energy, health care, and manufacturing. He is a frequent speaker at local ASUG chapters, national ASUG, and SAPinsider conferences, and independent SAP BusinessObjec
ts user groups. Dallas holds a master's degree in computer engineering from the University of Cincinnati. Dallas blogs about various business intelligence topics at You can follow him on Twitter at @dallasmarks.
Gabriel Orthous is a population health management and healthcare analytics expert, and a senior consultant to Wellcentive. Gabe has more than 15 years of business analytics managerial and software engineering experience with extensive expertise around business intelligence, financial reporting, and decision analytics. Gabe graduated from Mercer University with a master's degree in Business Administration and was inducted to the International Honor Society Beta Gamma Sigma in 2008. In addition, Gabe is chair for the Dashboarding and Visualization Special Interest Group for ASUG, co-chair for ASUG's Business Objects' Strategic SIG, and an active member of the Customer Advisory Council, as well as a renowned international speaker.
Acknowledgments ... 21
Foreword ... 23
1 Introduction to SAP BusinessObjects Web Intelligence 4.1 ... 25
1.1 Features of Web Intelligence ... 26
1.2 Reading Web Intelligence Reports ... 32
1.3 Adjusting Web Intelligence Preferences ... 33
1.4 The HTML Viewer versus the Applet (Java) Viewer ... 39
1.5 Web Intelligence Reporting and Analysis Environments ... 39
1.6 Report Display Modes ... 40
1.7 Summary ... 42
2 What's New in Web Intelligence 4.1? ... 45
2.1 SAP HANA Variable Support in SAP BusinessObjects BI 4.1 SP3 ... 46
2.2 Freeze Header Rows and Left Columns ... 49
2.3 Custom Grouping ... 52
2.4 Merged Dimension Improvements ... 57
2.5 Usability Improvements ... 59
2.6 Customizing Color Properties ... 67
2.7 Using Excel as a Data Source in the BI Launch Pad ... 74
2.8 Charting Enhancements ... 80
2.9 Report Formatting Improvements ... 84
2.10 Summary ... 85
3 Creating New Documents and Queries ... 87
3.1 Creating a Web Intelligence 4.1 Document ... 88
3.2 The Query Panel in Web Intelligence 4.1 ... 100
3.3 Adding and Editing Queries ... 104
3.4 Creating SAP BEx Queries ... 113
3.5 Query Filters ... 117
3.6 Prompted Queries ... 124
3.7 Summary ... 127
4 Creating a Report in Web Intelligence 4.1 ... 131
4.1 Adding Data to Report Elements ... 133
4.2 Sections and Breaks ... 136
4.3 Outline Navigation ... 140
4.4 Enhanced Sorting and Ranking .... 141
4.5 Conditional Formatting ... 150
4.6 Headers, Footers, and Background Images ... 154
4.7 Summary ... 157
5 The Web Intelligence 4.1 Report Panel ... 159
5.1 The Web Intelligence 4.1 Reporting Interface ... 159
5.2 Reporting Toolbars ... 162
5.3 The Side Panel ... 172
5.4 Report Panel ... 175
5.5 Report Property Categories ... 178
5.6 Summary ... 186
6 Displaying Data with Tables ... 187
6.1 Using Tables ... 189
6.1.4 Freezing Header Rows and Columns ... 201
6.2 Table Types ... 204
6.3 Converting Table Formats and Types ... 207
6.4 Blank and Predefined Cells ... 209
6.5 Summary ... 211
7 Displaying Data with Charts ... 213
7.1 Adding Charts to a Report ... 214
7.2 Chart Types ... 217
7.3 Chart Properties ... 240
7.4 Zone Formatting ... 245
7.5 Summary ... 246
8 Making an Impact with Charts ... 247
8.1 Properties That Enhance the Display of Data ... 248
8.2 Drilling in Reports with Multiple Charts ... 254
8.3 Hierarchical Charting with Relational Data ... 256
8.4 Reports Functioning as Dashboards ... 257
8.5 Formatting Tips ... 259
8.6 Custom Color Enhancements ... 264
8.7 Summary ... 271
9 Report Properties, Tools, and Formatting ... 273
9.1 Formatting Report Properties ... 273
9.2 Document Summary ... 275
9.3 Report Map ... 278
9.4 Input Controls ... 278
9.5 Web Services Publisher ... 282
9.6 Available Objects (Design Mode Only) ... 285
9.7 Document Structures and Filters ... 286
9.8 Data ... 287
9.9 Style Sheet Modification ... 289
9.10 Summary ... 294
10 Filtering Data in the Query Panel and Report Panel ... 295
10.1 Filtering in the Query Panel ... 295
10.2 Filtering in the Report Panel ... 304
10.3 Conditionally Hiding Report Elements ... 316
10.4 Hierarchical Navigation with SAP BW Data Sources ... 318
10.5 Summary ... 321
11 Scope of Analysis and Drill Functionality ... 323
11.1 Setting the Scope of Analysis in the Query Panel ... 324
11.2 Drill-Down Setup in the Report Panel ... 330
11.3 Query Drill Option ... 340
11.4 Taking a Snapshot ... 342
11.5 User Settings for Drill Down ... 342
11.6 Summary ... 344
12 Using Formulas and Variables ... 345
12.1 Formulas and Variables ... 346
12.2 Reporting Functions and Operators ... 352
12.3 Formula Syntax ... 368
12.4 Input, Output, and Calculation Contexts ... 371
12.5 Summary ... 378
13 Extending Query Panel Functionality ... 379
13.1 Complex Fil
Foreword ... 23
1 Introduction to SAP BusinessObjects Web Intelligence 4.1 ... 25
1.1 Features of Web Intelligence ... 26
1.2 Reading Web Intelligence Reports ... 32
1.3 Adjusting Web Intelligence Preferences ... 33
1.4 The HTML Viewer versus the Applet (Java) Viewer ... 39
1.5 Web Intelligence Reporting and Analysis Environments ... 39
1.6 Report Display Modes ... 40
1.7 Summary ... 42
2 What's New in Web Intelligence 4.1? ... 45
2.1 SAP HANA Variable Support in SAP BusinessObjects BI 4.1 SP3 ... 46
2.2 Freeze Header Rows and Left Columns ... 49
2.3 Custom Grouping ... 52
2.4 Merged Dimension Improvements ... 57
2.5 Usability Improvements ... 59
2.6 Customizing Color Properties ... 67
2.7 Using Excel as a Data Source in the BI Launch Pad ... 74
2.8 Charting Enhancements ... 80
2.9 Report Formatting Improvements ... 84
2.10 Summary ... 85
3 Creating New Documents and Queries ... 87
3.1 Creating a Web Intelligence 4.1 Document ... 88
3.2 The Query Panel in Web Intelligence 4.1 ... 100
3.3 Adding and Editing Queries ... 104
3.4 Creating SAP BEx Queries ... 113
3.5 Query Filters ... 117
3.6 Prompted Queries ... 124
3.7 Summary ... 127
4 Creating a Report in Web Intelligence 4.1 ... 131
4.1 Adding Data to Report Elements ... 133
4.2 Sections and Breaks ... 136
4.3 Outline Navigation ... 140
4.4 Enhanced Sorting and Ranking .... 141
4.5 Conditional Formatting ... 150
4.6 Headers, Footers, and Background Images ... 154
4.7 Summary ... 157
5 The Web Intelligence 4.1 Report Panel ... 159
5.1 The Web Intelligence 4.1 Reporting Interface ... 159
5.2 Reporting Toolbars ... 162
5.3 The Side Panel ... 172
5.4 Report Panel ... 175
5.5 Report Property Categories ... 178
5.6 Summary ... 186
6 Displaying Data with Tables ... 187
6.1 Using Tables ... 189
6.1.4 Freezing Header Rows and Columns ... 201
6.2 Table Types ... 204
6.3 Converting Table Formats and Types ... 207
6.4 Blank and Predefined Cells ... 209
6.5 Summary ... 211
7 Displaying Data with Charts ... 213
7.1 Adding Charts to a Report ... 214
7.2 Chart Types ... 217
7.3 Chart Properties ... 240
7.4 Zone Formatting ... 245
7.5 Summary ... 246
8 Making an Impact with Charts ... 247
8.1 Properties That Enhance the Display of Data ... 248
8.2 Drilling in Reports with Multiple Charts ... 254
8.3 Hierarchical Charting with Relational Data ... 256
8.4 Reports Functioning as Dashboards ... 257
8.5 Formatting Tips ... 259
8.6 Custom Color Enhancements ... 264
8.7 Summary ... 271
9 Report Properties, Tools, and Formatting ... 273
9.1 Formatting Report Properties ... 273
9.2 Document Summary ... 275
9.3 Report Map ... 278
9.4 Input Controls ... 278
9.5 Web Services Publisher ... 282
9.6 Available Objects (Design Mode Only) ... 285
9.7 Document Structures and Filters ... 286
9.8 Data ... 287
9.9 Style Sheet Modification ... 289
9.10 Summary ... 294
10 Filtering Data in the Query Panel and Report Panel ... 295
10.1 Filtering in the Query Panel ... 295
10.2 Filtering in the Report Panel ... 304
10.3 Conditionally Hiding Report Elements ... 316
10.4 Hierarchical Navigation with SAP BW Data Sources ... 318
10.5 Summary ... 321
11 Scope of Analysis and Drill Functionality ... 323
11.1 Setting the Scope of Analysis in the Query Panel ... 324
11.2 Drill-Down Setup in the Report Panel ... 330
11.3 Query Drill Option ... 340
11.4 Taking a Snapshot ... 342
11.5 User Settings for Drill Down ... 342
11.6 Summary ... 344
12 Using Formulas and Variables ... 345
12.1 Formulas and Variables ... 346
12.2 Reporting Functions and Operators ... 352
12.3 Formula Syntax ... 368
12.4 Input, Output, and Calculation Contexts ... 371
12.5 Summary ... 378
13 Extending Query Panel Functionality ... 379
13.1 Complex Fil
Acknowledgments ... 21
Foreword ... 23
1 Introduction to SAP BusinessObjects Web Intelligence 4.1 ... 25
1.1 Features of Web Intelligence ... 26
1.2 Reading Web Intelligence Reports ... 32
1.3 Adjusting Web Intelligence Preferences ... 33
1.4 The HTML Viewer versus the Applet (Java) Viewer ... 39
1.5 Web Intelligence Reporting and Analysis Environments ... 39
1.6 Report Display Modes ... 40
1.7 Summary ... 42
2 What's New in Web Intelligence 4.1? ... 45
2.1 SAP HANA Variable Support in SAP BusinessObjects BI 4.1 SP3 ... 46
2.2 Freeze Header Rows and Left Columns ... 49
2.3 Custom Grouping ... 52
2.4 Merged Dimension Improvements ... 57
2.5 Usability Improvements ... 59
2.6 Customizing Color Properties ... 67
2.7 Using Excel as a Data Source in the BI Launch Pad ... 74
2.8 Charting Enhancements ... 80
2.9 Report Formatting Improvements ... 84
2.10 Summary ... 85
3 Creating New Documents and Queries ... 87
3.1 Creating a Web Intelligence 4.1 Document ... 88
3.2 The Query Panel in Web Intelligence 4.1 ... 100
3.3 Adding and Editing Queries ... 104
3.4 Creating SAP BEx Queries ... 113
3.5 Query Filters ... 117
3.6 Prompted Queries ... 124
3.7 Summary ... 127
4 Creating a Report in Web Intelligence 4.1 ... 131
4.1 Adding Data to Report Elements ... 133
4.2 Sections and Breaks ... 136
4.3 Outline Navigation ... 140
4.4 Enhanced Sorting and Ranking .... 141
4.5 Conditional Formatting ... 150
4.6 Headers, Footers, and Background Images ... 154
4.7 Summary ... 157
5 The Web Intelligence 4.1 Report Panel ... 159
5.1 The Web Intelligence 4.1 Reporting Interface ... 159
5.2 Reporting Toolbars ... 162
5.3 The Side Panel ... 172
5.4 Report Panel ... 175
5.5 Report Property Categories ... 178
5.6 Summary ... 186
6 Displaying Data with Tables ... 187
6.1 Using Tables ... 189
6.1.4 Freezing Header Rows and Columns ... 201
6.2 Table Types ... 204
6.3 Converting Table Formats and Types ... 207
6.4 Blank and Predefined Cells ... 209
6.5 Summary ... 211
7 Displaying Data with Charts ... 213
7.1 Adding Charts to a Report ... 214
7.2 Chart Types ... 217
7.3 Chart Properties ... 240
7.4 Zone Formatting ... 245
7.5 Summary ... 246
8 Making an Impact with Charts ... 247
8.1 Properties That Enhance the Display of Data ... 248
8.2 Drilling in Reports with Multiple Charts ... 254
8.3 Hierarchical Charting with Relational Data ... 256
8.4 Reports Functioning as Dashboards ... 257
8.5 Formatting Tips ... 259
8.6 Custom Color Enhancements ... 264
8.7 Summary ... 271
9 Report Properties, Tools, and Formatting ... 273
9.1 Formatting Report Properties ... 273
9.2 Document Summary ... 275
9.3 Report Map ... 278
9.4 Input Controls ... 278
9.5 Web Services Publisher ... 282
9.6 Available Objects (Design Mode Only) ... 285
9.7 Document Structures and Filters ... 286
9.8 Data ... 287
9.9 Style Sheet Modification ... 289
9.10 Summary ... 294
10 Filtering Data in the Query Panel and Report Panel ... 295
10.1 Filtering in the Query Panel ... 295
10.2 Filtering in the Report Panel ... 304
10.3 Conditionally Hiding Report Elements ... 316
10.4 Hierarchical Navigation with SAP BW Data Sources ... 318
10.5 Summary ... 321
11 Scope of Analysis and Drill Functionality ... 323
11.1 Setting the Scope of Analysis in the Query Panel ... 324
11.2 Drill-Down Setup in the Report Panel ... 330
11.3 Query Drill Option ... 340
11.4 Taking a Snapshot ... 342
11.5 User Settings for Drill Down ... 342
11.6 Summary ... 344
12 Using Formulas and Variables ... 345
12.1 Formulas and Variables ... 346
12.2 Reporting Functions and Operators ... 352
12.3 Formula Syntax ... 368
12.4 Input, Output, and Calculation Contexts ... 371
12.5 Summary ... 378
13 Extending Query Panel Functionality ... 379
13.1 Complex Fil
Foreword ... 23
1 Introduction to SAP BusinessObjects Web Intelligence 4.1 ... 25
1.1 Features of Web Intelligence ... 26
1.2 Reading Web Intelligence Reports ... 32
1.3 Adjusting Web Intelligence Preferences ... 33
1.4 The HTML Viewer versus the Applet (Java) Viewer ... 39
1.5 Web Intelligence Reporting and Analysis Environments ... 39
1.6 Report Display Modes ... 40
1.7 Summary ... 42
2 What's New in Web Intelligence 4.1? ... 45
2.1 SAP HANA Variable Support in SAP BusinessObjects BI 4.1 SP3 ... 46
2.2 Freeze Header Rows and Left Columns ... 49
2.3 Custom Grouping ... 52
2.4 Merged Dimension Improvements ... 57
2.5 Usability Improvements ... 59
2.6 Customizing Color Properties ... 67
2.7 Using Excel as a Data Source in the BI Launch Pad ... 74
2.8 Charting Enhancements ... 80
2.9 Report Formatting Improvements ... 84
2.10 Summary ... 85
3 Creating New Documents and Queries ... 87
3.1 Creating a Web Intelligence 4.1 Document ... 88
3.2 The Query Panel in Web Intelligence 4.1 ... 100
3.3 Adding and Editing Queries ... 104
3.4 Creating SAP BEx Queries ... 113
3.5 Query Filters ... 117
3.6 Prompted Queries ... 124
3.7 Summary ... 127
4 Creating a Report in Web Intelligence 4.1 ... 131
4.1 Adding Data to Report Elements ... 133
4.2 Sections and Breaks ... 136
4.3 Outline Navigation ... 140
4.4 Enhanced Sorting and Ranking .... 141
4.5 Conditional Formatting ... 150
4.6 Headers, Footers, and Background Images ... 154
4.7 Summary ... 157
5 The Web Intelligence 4.1 Report Panel ... 159
5.1 The Web Intelligence 4.1 Reporting Interface ... 159
5.2 Reporting Toolbars ... 162
5.3 The Side Panel ... 172
5.4 Report Panel ... 175
5.5 Report Property Categories ... 178
5.6 Summary ... 186
6 Displaying Data with Tables ... 187
6.1 Using Tables ... 189
6.1.4 Freezing Header Rows and Columns ... 201
6.2 Table Types ... 204
6.3 Converting Table Formats and Types ... 207
6.4 Blank and Predefined Cells ... 209
6.5 Summary ... 211
7 Displaying Data with Charts ... 213
7.1 Adding Charts to a Report ... 214
7.2 Chart Types ... 217
7.3 Chart Properties ... 240
7.4 Zone Formatting ... 245
7.5 Summary ... 246
8 Making an Impact with Charts ... 247
8.1 Properties That Enhance the Display of Data ... 248
8.2 Drilling in Reports with Multiple Charts ... 254
8.3 Hierarchical Charting with Relational Data ... 256
8.4 Reports Functioning as Dashboards ... 257
8.5 Formatting Tips ... 259
8.6 Custom Color Enhancements ... 264
8.7 Summary ... 271
9 Report Properties, Tools, and Formatting ... 273
9.1 Formatting Report Properties ... 273
9.2 Document Summary ... 275
9.3 Report Map ... 278
9.4 Input Controls ... 278
9.5 Web Services Publisher ... 282
9.6 Available Objects (Design Mode Only) ... 285
9.7 Document Structures and Filters ... 286
9.8 Data ... 287
9.9 Style Sheet Modification ... 289
9.10 Summary ... 294
10 Filtering Data in the Query Panel and Report Panel ... 295
10.1 Filtering in the Query Panel ... 295
10.2 Filtering in the Report Panel ... 304
10.3 Conditionally Hiding Report Elements ... 316
10.4 Hierarchical Navigation with SAP BW Data Sources ... 318
10.5 Summary ... 321
11 Scope of Analysis and Drill Functionality ... 323
11.1 Setting the Scope of Analysis in the Query Panel ... 324
11.2 Drill-Down Setup in the Report Panel ... 330
11.3 Query Drill Option ... 340
11.4 Taking a Snapshot ... 342
11.5 User Settings for Drill Down ... 342
11.6 Summary ... 344
12 Using Formulas and Variables ... 345
12.1 Formulas and Variables ... 346
12.2 Reporting Functions and Operators ... 352
12.3 Formula Syntax ... 368
12.4 Input, Output, and Calculation Contexts ... 371
12.5 Summary ... 378
13 Extending Query Panel Functionality ... 379
13.1 Complex Fil