SAP Business Warehouse Query Design and Analysis

SAP Business Warehouse Query Design and Analysis

Overview

Duration: 5 days
Course Overview

Course

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

Objectives

Course Objectives
Course 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
Course Certifications

This course is part of the following Certifications:

Prerequisites

Essential

  • Basic knowledge of data warehousing

Recommended

  • Experience and sound knowledge of the subject matter in at least one SAP
  • ERP application course
Course ID:
BW305


Show Schedule for: