Winter Savings - Save on IT Training Using Promo Code FROSTBYTE


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 2006 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.

First remote course and I am pleasantly surprised. Love the on site facilities in Ottawa, but the online course format was very well received.

It was quick and easy to sign up and attend the class. Instructions were easy to follow. I appreciate the reminder emails of class date/time.

the professor was very clean and help students wih the labs when needed, Thank you.

Lot of material was covered in 3 days. Would be nice to have some more time to process the lab sections, especially.

I loved the class from ExitCertified, the Instructor Sean Mohseni explained the concepts in a very clear manner with real world example that helped me understand the AWS Services in depth.

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 Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward