SAP Business Objects Web Intelligence

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. 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 (http://ideas.sap.com). 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. 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 BusinessObjects user groups. Dallas holds a master's degree in computer engineering from the University of Cincinnati. Dallas blogs about various business intelligence topics at http://www.dallasmarks.org/. 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).

Introduction to SAP BusinessObjects Web Intelligence
Features of Web Intelligence 4.2
Web Intelligence Clients
Web Intelligence Preferences
What’s New in Web Intelligence 4.2 SP 3 and SP 4
Summary
Creating New Documents and Queries
Creating a Web Intelligence Document from a Universe
The Query Panel in Web Intelligence
Query Filters
Prompted Queries
Saving Your Document in the BI Platform Repository
Other Data Sources
Document Options
Summary
Creating a Report in Web Intelligence
Adding Data to Report Elements
Sections and Breaks
Outline Navigation
Enhanced Sorting and Ranking
Conditional Formatting
Headers, Footers, and Background Images
Summary
The Web Intelligence Report Panel
The Web Intelligence Reporting Interface
Reporting Toolbars
The Side Panel
Report Panel
Report Property Categories
Summary
Displaying Data with Tables
Using Tables
Table Types
Converting Table Formats and Types
Blank Cells, Predefined Cells, and Comment Cells
Summary
Displaying Data with Charts
Adding Charts to a Report
Chart Types
Chart Properties
Zone Formatting
Custom Elements
Summary
Making an Impact with Charts
Properties That Enhance the Display of Data
Hierarchical Charting with Relational Data
Reports Functioning as Dashboards
Formatting Tips
Custom Color Enhancements
Summary
Report Properties, Tools, and Formatting
Formatting Report Properties
Document Summary
Navigation (Report) Map
Input Controls
Web Services Publisher
Available Objects (Design Mode Only)
Document Structures and Filters
Data
Style Sheet Modification
High Precision Numbers
Geolocalizing a Dimension
Summary
Filtering Data in the Query Panel and Report Panel
Filtering in the Query Panel
Complex Filtering Options
Filtering in the Report Panel
Conditionally Hiding Report Elements
Element Linking
Summary
Scope of Analysis and Drill Functionality
Setting the Scope of Analysis in the Query Panel
Drill-Down Setup in the Report Panel
Drilling on Tables
Drilling on Charts
Taking a Snapshot
Drill Options
Summary
Using Formulas and Variables
Formulas and Variables
Custom Grouping
Reporting Functions and Operators
Formula Syntax
Input, Output, and Calculation Contexts
References
Summary
Advanced Query Panel Functionalities
Cascading and Optional Prompts
Saving Prompts Answers in BI Variants
Querying Multidimensional Data Sources
Editing Auto-Generated SQL Scripts
Support of Query Stripping
Partial Results, Purged Data, and Cancelled Queries
Summary
Access to SAP BW and SAP HANA
SAP BW and SAP HANA Access Overview
SAP BEx Query through Direct Access
SAP BEx Query through Multidimensional Universe
SAP BW through Relational Universe
SAP HANA Direct Access
SAP HANA Online Mode
SAP HANA View through Relational Universe
SAP HANA through Free-Hand SQL
Summary
Using Multiple Queries and Data Sources
Setting Up a Combined Query
Adding a New Query
Managing Queries
Running Multiple Queries
Merging Dimensions
Merging Variables
Changing Source
Summary
Adding Hyperlinks in Web Intelligence Documents
Linking to Document with the HTML Client
Linking to the Web Page URL
OpenDocument Syntax
Summary
Working in the BI Launch Pad
Navigating in BI Launch Pad
Setting BI Launch Pad Preferences
Organizing in Folders and Categories
Deleting Documents and the Recycle Bin
Viewing, Printing, and Saving Objects in BI Launch Pad
Summary
Using Web Intelligence with SAP BusinessObjects BI Workspaces
Introducing BI Workspaces
Working with Modules
Working with Web Intelligence Report Parts
Using a BI Workspace as the Default Home Tab
Printing BI Workspaces
Content Linking
Summary
Interaction from a User’s Perspective
Creating Shortcuts and Hyperlinks
Searching within the BI Launch Pad
Sorting and Filtering Content
Creating Discussions
Commenting Documents
Tracking Data Changes
Summary
Sharing Web Intelligence Content
Sharing Document Content through Shared Elements
Using the Send Feature in BI Launch Pad
Exporting a Web Intelligence Report
Scheduling a Web Intelligence Report
Summary
Report Scheduling and Distribution with Publications
Publication Roles
Creating a Publication
Mobile Publications
Summary
Web Intelligence Rich Client
How Web Intelligence Rich Client Is Different
Data Provider Options
Working with Web Intelligence Reports
Setting Preferences in Web Intelligence Rich Client
Summary
Web Intelligence Interactive Viewer
New BI Launch Pad and Web Intelligence Interactive Viewer Overview
Navigating in the New BI Launch Pad
Viewing a Document
Refreshing a Document
Filtering a Report
Sorting or Ranking Data in a Report
Scheduling a Document
Saving and Exporting to XLS and to PDF
Setting Web Intelligence Preferences
Logging Out
Summary
Connecting SAP BusinessObjects Live Office to Web Intelligence and Universes
Introduction to SAP BusinessObjects Live Office
Creating Queries from Universes
Retrieving Web Intelligence Content
Editing Added Content
Setting Preferences
Summary
Mobile Business Intelligence
Introducing SAP BusinessObjects Mobile
Designing Reports for Mobile Viewing
Mobile-Only Analytic Types
Report Linking
Input Controls
Mobile Thumbnails
Summary
Appendices
Converting Desktop Intelligence Reports to Web Intelligence Documents
Web Intelligence Security Rights