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

Prerequisites

  • 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

Notes

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

Content is consistent with the class you enroll in. Instructor was thorough and engaging.

Exactly what we needed for our organization, at the right time, at the right price. We'll be back!

Great training company. Use them. Worth every penny. Instructors are great, equipment is great, system is great.

The AWS Training & Certification course was fantastic. Ryan Dymek was the instructor; he was awesome. I learned a lot in 3 days!

The course material and instructor were very good. easy to follow, lab was setup nicely and was able to complete most of the lab material.
The Koretex App is absolute garbage and very cumbersome to use on a tablet/ipad. A PDF file would be 100 times better than that atrocious app.
As a recommendation this class should be 5 days instead of 4 as some chapters had to be rushed.

3 options available

undo
  • GTR Nov 16, 2020 Nov 20, 2020 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Jan 25, 2021 Jan 29, 2021 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Aug 2, 2021 Aug 6, 2021 (5 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward