3 arrows

Winter-Ready Savings Up To $500 Off Training 


SAP Business Warehouse Query Design and Analysis

Skills Gained This course will prepare you to:    -Learn how to create queries in BEx Query Designer    -Learn how to use advanced query functions...

Read More
$4,090 USD GSA  $3,250.43
Course Code BW305-v015
Duration 5 days
Available Formats Virtual, Classroom
5260 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

Skills Gained

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

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


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

Course Details

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


  • This course focuses on BEx query design. SAP BusinessObjects Analysis is the tool that is used for query execution.
  • Course material available as flipbook in LH

Course based on software release

  • SAP Business Warehouse 7.4
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward