In this course, students obtain the knowledge to create query definitions using the BEx Query Designer and to make them available for OLAP analysis.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Learn how to create queries in BEx Query Designer Learn how to use advanced query functions Learn how to perform OLAP analysis

1
  • Data Warehousing

  • Describing Data Warehousing
    Describing Data Warehouse Architecture
    Using Reporting Tools

2
  • Navigation Options in Reports

  • Using the Navigation Options in Reports
    Saving Analysis Views

3
  • Simple Queries

  • Creating Simple Queries
    Finding a Query
    Filtering Query Definition Data
    Configuring Query Properties

4
  • 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

5
  • Queries with Multiple Structures

  • Creating Structures
    Resolving Formula Collision
    Designing Detailed Queries with the Cell Editor

6
  • Characteristics and Hierarchies in Queries

  • Configuring the Properties of Characteristics
    Running Display and Navigation Attribute Queries
    Adding Hierarchies to Reports
    Adding External Hierarchies to a Report
    Using Hierarchies and Structures
    Creating External Hierarchies

7
  • 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

8
  • Exceptions and Conditions in Queries

  • Creating Exceptions in Query Design
    Creating Conditions in Query Design

9
  • Report-Report Interface

  • Using the Report-Report Interface

10
  • Query Performance Optimization

  • Optimizing Query Performance
    Configuring Query Read Mode
    Use Performance Monitoring Tools

11
  • Queries Management and Authorizations Overview

  • Managing Query Objects
    Describing Authorizations

12
  • Reporting Options

  • Outlining Reporting Options for SAP NetWeaver BW

Audience

The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users.

Language

English

Prerequisites

The prerequisites for this course are as follows: Basic data warehousing knowledge, experience and sound knowledge of the subject matter in at least one SAP course, ERP application experience.

$4,335

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...