SAP BEx Tools
SAP NetWeaver BI 7.0
2nd Edition
Published on 28. May 2009
Book
Hardback
172 pages
978-1-59229-279-0 (ISBN)
Description
SAP Business Explorer (BEx) Tools teaches users exactly what they need to know to perform effective BEx reporting, with no frills or extra information, with sample scenarios and practical examples included throughout the book.
This new edition features completely updated terminology and technology, with new, enhanced screenshots, and new vocabulary. The book documents how to redo everything from the first version, using the new interfaces. Newly added Chapter 6 covers advanced topics on the new tools, and includes an FAQ section that answers common questions received by the author since the release of Netweaver 2004s BI and best practices information.
More details
Other editions
Previous edition
Book
01/1970
1st Edition
SAP PRESS
€68.00
Article exhausted; check for reprint
Person
Author
With 10 years of BW consulting and project management experience, Peter Scott focuses on the reporting capabilities of BW. As an international consultant he has worked on many project deliverables and has logged over 2000 classroom hours teaching BW reporting functionality. He sits on BW "Ask the Expert" panels and is certified in SAP BW.
Content
1. Fundamentals of BI Reporting
1.1 Basics of Data Warehousing
1.2 Basics of SAP BI Reporting (Tools, InfoProviders, Query Definitions, Reports)
2. Designing Queries with the Query Designer
2.1 Overview of the Query Designer
2.2 The concept of a Query Definition
2.3 Query Designer Layout
2.4 Accessing InfoProviders
2.5 Using the Query Designer Toolbar
2.6 Creating Restricted and Calculated Key Figures
2.7 Advanced Calculations with Data functions
2.8 Using Structures
2.9 Creating fixed Query Outputs
2.10 Using Characteristic Variables
2.11 Creating Exceptions
2.12 Creating Conditions
2.13 Performance Considerations
2.14 Quick fill features
2.15 Sample Scenario
3. Creating High-Impact Workbooks
3.1 Overview of the BEx Analyzer
3.2 The concept of a Workbook
3.3 Using the BEx Analyzer
3.4 Executing a query into the BEx Analyzer
3.5 Using the BEx Analyzer Toolbar
3.6 OLAP Functionality
3.7 Filtering Results
3.8 Integration with Microsoft Excel
3.9 Inserting Additional Queries
3.10 Saving and Distributing Workbooks
3.11 Creating Customized Templates
3.12 Creating Summary Reports with Cell Referencing
3.13 Designing workbooks with the Design Toolbar
3.14 Sample Scenarios
4. Creating Web Applications
4.1 Overview of Web Reporting
4.2 Using the Web Reporting Interface
4.3 OLAP Options
4.4 Adhoc Web-based Query Designer
4.5 Bookmarking Web Reports
4.6 Overview of the Web Application Designer
4.7 Using the Web Application Designer
4.8 Standard Web Items
4.9 Creating Web Templates
4.10 Using Graphs & Charts
4.11 Inserting Multiple Queries
4.12 Publishing Web Templates
4.13 Web reporting URL strings
4.13 Sample Scenarios
5. Report-Report-Interfacing
5.1 Linking Reports
5.2 Prerequisites
5.3 Creating a Jump Target Definition
5.4 Using the Goto function
5.5 Driving Business Analysis
5.6 Practical Examples
6. Advanced Reporting Topics
6.1 Visual Composer (VC) for front-end reporting
6.2 Analysis Process Designer (APD) for calculations
6.3 Using the BI Accelerator (BIA)
6.4 SAP Reporting roadmap and Business Objects
6.5 Frequently Asked Questions (FAQ)
6.6 Best Practices
APPENDIX - Additional Reporting Considerations
A.1 Data Integrity
A.2 Version Control
A.3 Sharing Data with Non-BI Users
A.4 Printing Considerations
A.5 Web URL Commands
Index
1.1 Basics of Data Warehousing
1.2 Basics of SAP BI Reporting (Tools, InfoProviders, Query Definitions, Reports)
2. Designing Queries with the Query Designer
2.1 Overview of the Query Designer
2.2 The concept of a Query Definition
2.3 Query Designer Layout
2.4 Accessing InfoProviders
2.5 Using the Query Designer Toolbar
2.6 Creating Restricted and Calculated Key Figures
2.7 Advanced Calculations with Data functions
2.8 Using Structures
2.9 Creating fixed Query Outputs
2.10 Using Characteristic Variables
2.11 Creating Exceptions
2.12 Creating Conditions
2.13 Performance Considerations
2.14 Quick fill features
2.15 Sample Scenario
3. Creating High-Impact Workbooks
3.1 Overview of the BEx Analyzer
3.2 The concept of a Workbook
3.3 Using the BEx Analyzer
3.4 Executing a query into the BEx Analyzer
3.5 Using the BEx Analyzer Toolbar
3.6 OLAP Functionality
3.7 Filtering Results
3.8 Integration with Microsoft Excel
3.9 Inserting Additional Queries
3.10 Saving and Distributing Workbooks
3.11 Creating Customized Templates
3.12 Creating Summary Reports with Cell Referencing
3.13 Designing workbooks with the Design Toolbar
3.14 Sample Scenarios
4. Creating Web Applications
4.1 Overview of Web Reporting
4.2 Using the Web Reporting Interface
4.3 OLAP Options
4.4 Adhoc Web-based Query Designer
4.5 Bookmarking Web Reports
4.6 Overview of the Web Application Designer
4.7 Using the Web Application Designer
4.8 Standard Web Items
4.9 Creating Web Templates
4.10 Using Graphs & Charts
4.11 Inserting Multiple Queries
4.12 Publishing Web Templates
4.13 Web reporting URL strings
4.13 Sample Scenarios
5. Report-Report-Interfacing
5.1 Linking Reports
5.2 Prerequisites
5.3 Creating a Jump Target Definition
5.4 Using the Goto function
5.5 Driving Business Analysis
5.6 Practical Examples
6. Advanced Reporting Topics
6.1 Visual Composer (VC) for front-end reporting
6.2 Analysis Process Designer (APD) for calculations
6.3 Using the BI Accelerator (BIA)
6.4 SAP Reporting roadmap and Business Objects
6.5 Frequently Asked Questions (FAQ)
6.6 Best Practices
APPENDIX - Additional Reporting Considerations
A.1 Data Integrity
A.2 Version Control
A.3 Sharing Data with Non-BI Users
A.4 Printing Considerations
A.5 Web URL Commands
Index