Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

SAP BW - Query Design and Analysis

( Duration: 5 Days )

The SAP BW - Query Design and Analysis training course provides the knowledge to create query definitions using the Bex Query and to make them available for OLAP Analysis.

By attending SAP BW - Query Design and Analysis workshop, delegates will learn to:

  • Create queries in BEx Query Designer
  • Use advanced query functions
  • Perform OLAP analysis

  • Basic knowledge of data warehousing
  • Experience and sound knowledge of the subject matter in at least one SAP

This SAP BW - Query Design and Analysis classis intended for:

  • Application Consultants
  • Business Analysts
  • Business Process Owners / Team Leads / Power Users
  • Program / Project Managers

COURSE AGENDA

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 and Workbooks
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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X