Wat is SAP Business Warehouse Query Design and Analysis
This course gives you the knolwedge to create query definitions using the Bex Query and to make them available for OLAP Analysis.
Course based on software release: SAP Business Warehouse 7.4
This course will prepare you to:
- Learn how to create queries in BEx Query Designer
- Learn how to use advanced query functions
- Learn how to perform OLAP Analysis
-
Content:
Data Warehousing
Describing Data Warehousing
Describing Data Warehouse Architecture
Using Reporting Tools
Navigation Options in Reports
Using the Navigation Options in Reports
Saving Analysis Views and Workbooks
Simple Queries
Creating Simple Queries
Finding a Query
Filtering Query Definition Data
Configuring Query Properties
Key Figures and Structures in Queries
Creating Restricted Key Figures
Creating Calculated Key Figures
Creating a New Formula with Boolean Operators
Configuring Properties of Key Figures
Using Exception and Nested Exception Aggregation
Queries with Multiple Structures
Creating Structures
Resolving Formula Collision
Designing Detailed Queries with the Cell Editor
Characteristics and Hierarchies in Queries
Configuring the Properties of Characteristics
Running Display and Navigation Attribute Queries
Adding Hierarchies to Reports
Using Hierarchies and Structures
Adding External Hierarchies to a Report
Creating External Hierarchies
Variables in Queries
Using Variables
Creating Characteristic Value and Text Variables in Queries
Creating Hierarchy and Hierarchy Node Variables in Queries
Creating Formula Variables in Queries
Activating Business Content Variables
Exceptions and Conditions in Queries
Creating Exceptions in Query Design
Creating Conditions in Query Design
Report-Report Interface
Using the Report-Report Interface
Query Performance Optimization
Optimizing Query Performance
Configuring Query Read Mode
Using Performance Monitoring Tools
Queries Management and Authorizations Overview
Managing Query Objects
Describing Authorizations
Reporting Options
Outlining Reporting Options for SAP BW
