Applied SAP BI 7.0 Web Reports: Using BEx Web Analyzer and Web Application Designer

✍ Scribed by Peter Jones

• Publisher: McGraw-Hill Osborne Media
• Year: 2010
• Tongue: English
• Leaves: 513
• Edition: 1
• Category: Library

✦ Synopsis

Deliver SAP BI 7.0 Web Reports

Distribute integrated, accurate, and timely data across your enterprise using the Web-based reporting components in SAP BI. Written by an SAP insider, Applied SAP BI 7.0 Web Reports: Using BEx Web Analyzer and Web Application Designer shows you how to construct effective queries, create HTML-based reports, and combine key analytics into a dashboard-style interface. Learn how to import data from multiple providers, configure custom templates, track Key Performance Indicators (KPIs), and incorporate JavaScript and XHTML. Security, troubleshooting, and third-party tools are also discussed in this comprehensive guide.

Essential BI skills for business professionals:

• Define queries and export them as links with BEx Web Analyzer
• Create BI-specific HTML pages using Web Application Designer and Report Designer
• Construct reusable templates, shortcuts, and Web items
• Design high-impact BI dashboards, cockpits, and billboards
• Integrate toolbars,drilldown capabilities, and drag-and-drop features
• Publish reporting objects with the Broadcaster and Broadcast Wizard
• Migrate existing systems and reports to the SAP BI 7.0 platform
• Add BusinessObjects, Crystal Reports, and JavaScript components

Peter Jones , MBA, is a principal/platinum business applications consultant with SAP Professional Services Consulting. He has more than 11 years of consulting and educational experience in a variety of strategic and leadership roles. Jones is the author of SAP Business Information Warehouse Reporting .

✦ Table of Contents

Contents......Page 8
Acknowledgments......Page 12
Introduction......Page 14
1 BEx Web Analyzer Reporting Functionality......Page 16
Introduction to the BEx Web Analyzer......Page 17
Accessing the BEx Web Analyzer......Page 19
Navigation Options in the BEx Web Analyzer......Page 22
Summary......Page 69
2 Getting a Fast Start with BI Patterns in the BEx Web Template......Page 72
Using BI Patterns with the Pattern Wizard......Page 73
Configuration of the BI Patterns in the Web Application Designer......Page 75
Small Web Template with Analysis Web Item and 1 DP......Page 77
Small Web Template with Chart Web Item and 1 DP......Page 80
Small Web Template with Chart, Analysis Web Item and 1 DP......Page 85
Information Consumer Pattern......Page 89
Summary......Page 95
3 Basics of the Web Application Designer......Page 96
Introduction to the Web Application Designer (WAD)......Page 97
Example WAD Reports......Page 98
Overview of the WAD Interface......Page 103
The WAD Screen Areas......Page 104
The WAD Menu Bar and Toolbar Components......Page 114
0ANALYSIS_PATTERN: Standard Web Template......Page 123
0ANALYSIS_PATTERN Interface......Page 124
0ANALYSIS_PATTERN EXPORT Interface......Page 128
Summary......Page 131
4 Advanced Configuration Using the Web Application Designer......Page 132
Setting Up the Initial Web Template for Use in the WAD......Page 133
Web Template Properties......Page 134
Web Template Formatting Components......Page 138
Creating a Web Template......Page 144
Configuration of a Web Template with Two Web Items......Page 151
Groups of Web Items......Page 161
Formatting with Web Template Layouts Format......Page 229
Command Wizard......Page 237
XHTML Features......Page 246
JavaScript Features......Page 249
Summary......Page 250
5 Advanced Functionality of the Report Designer......Page 252
Functionality of the Report Designer......Page 253
Static and Dynamic Sections in a Report Designer Report......Page 255
Row Patterns......Page 256
Using Hierarchies in Your Reports......Page 260
Using Templates in the Report Designer......Page 269
Positioning Queries in the Report Designer......Page 280
Example Using the Functionality of the Report Designer......Page 281
Summary......Page 296
6 Developing Effective Web Reports......Page 298
Charts......Page 299
Editing Charts......Page 304
Chart Types......Page 310
Formatting Charts Using the Wizard......Page 345
Defining Chart Properties......Page 353
Examples of Improved Chart Layout......Page 369
Configuration of Commands......Page 383
Integration......Page 384
Commands for Web Items......Page 385
Commands for Data Providers......Page 390
Summary......Page 397
7 Developing High-Impact Dashboards......Page 400
Overview of the Development of Dashboards......Page 401
Process of Developing a Dynamic Dashboard......Page 402
Required Details of the KPIs......Page 404
Tips on Visualization of Dynamic Dashboards......Page 408
The Architecture of the Dashboard......Page 422
Examples of Effective Dashboards......Page 423
Summary......Page 440
Overview of the Migration Process......Page 442
Approach to Migration of Web-Based Reports......Page 448
Migration Activities......Page 450
Standard Business Content for Migration......Page 451
WAD Library......Page 452
Web Reports......Page 454
WAD Templates......Page 457
Variants......Page 465
Steps in the Migration Process......Page 473
Summary......Page 477
9 Integration of SAP BusinessObjects Components into the BI Environment......Page 478
Overview of the Integration and Positioning Process......Page 479
Components of SAP BusinessObjects (BOBJ) for Reporting......Page 481
Choosing the Right Tool for the Right Job......Page 484
Web Intelligence (WebI)......Page 486
Xcelsius......Page 494
Crystal Reports......Page 501
BusinessObjects Explorer......Page 505
Summary......Page 506
B......Page 508
C......Page 509
I......Page 510
R......Page 511
W......Page 512
X......Page 513