3 arrows

Webinar: Driving IT Success with the Right Training - Save A Seat


SAP Business Warehouse Query Design and Analysis

  • Tuition USD $4,090 GSA  $3,037.78
  • Reviews star_rate star_rate star_rate star_rate star_half 3563 Ratings
  • Course Code BW305-v015
  • Duration 5 days
  • Available Formats Virtual, Classroom

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

Great training platform, signing up for courses is made easy and a great customer support team is there to answer any question and provide assistance during application. The course was great overall, instructor explained everything throughly and quickly answer any incoming questions.

Unfortunately, internet problems on my end prevented the full experience of this.

A very good training class for the AWS Certifications and for general skill development

I took the fundamental class and passed. This is my second class. So far so good.

1 options available

  • Aug 2, 2021 Aug 6, 2021 (5 days)
    Location Details
    9:30 5:30 EST
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward