Download PDF
of this course

SAP Business Warehouse Query Design and Analysis (BW305 )

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Course Duration: 5 Days

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

Who Should Attend

  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Program / Project Manager
  • User

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 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 ID: BW305


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register