SAP Business Warehouse Query Design and Analysis Classroom Live Dallas, TX April 22, 2019

Course Overview

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

Prerequisites

• Essential
  • Basic knowledge of data warehousing
• Recommended
  • Experience and sound knowledge of the subject matter in at least one SAP
  • ERP application course