Training Schedule Training Schedule

(BW305e) SAP Business Warehouse Query Design and Analysis (eLearning)
Code: BW305e v15
Type: null
Tuition (USD): $936
Length: 182 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
eLearning, US 08/25/2019
eLearning, US 08/26/2019
eLearning, US 08/27/2019
eLearning, US 08/28/2019
eLearning, US 09/01/2019
eLearning, US 09/02/2019
eLearning, US 09/03/2019
eLearning, US 09/04/2019
eLearning, US 09/05/2019
eLearning, US 09/06/2019
eLearning, US 09/07/2019
eLearning, US 09/08/2019
eLearning, US 09/09/2019
eLearning, US 09/10/2019
eLearning, US 09/11/2019
eLearning, US 09/12/2019
eLearning, US 09/13/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

Skills Gained:
Learn how to create queries in BEx Query Designer Learn how to use advanced query functions Learn how to perform OLAP analysis
Who Should Attend?
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
  • Recommended: ERP application course"
What You Will Learn:
  • 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
  • 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
  • Adding External Hierarchies to a Report
  • Using Hierarchies and Structures
  • 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
  • Use Performance Monitoring Tools
  • Queries Management and Authorizations Overview
  • Managing Query Objects
  • Describing Authorizations
  • Reporting Options
  • Outlining Reporting Options for SAP NetWeaver BW
  • Notes
  • This course focuses on BEx query design. SAP BusinessObjects Analysis is the tool that is used for query execution.
Course Info:
Course based on software release: SAP Business Warehouse 7.4

Course length: 1200 minutes.

Course notes and announcements:

1) This course gives you the knowledge to create query definitions using the BEx Query Designer and to make them available for OLAP analysis.

2) This course focuses on BEx query design. SAP BusinessObjects Analysis is the tool that is used for query execution.

E-Learning (single course access or free with the purchase of Learning Hub)

In order for your company to get the most from its SAP investment, your executives need to understand the full potential of your solution - and your users need the right skills to accomplish their daily tasks. That's why SAP Education offers a growing catalog of e-learning offerings - highly interactive, Web-based courses that enable you to deliver the timely, focused training your organization demands.

SAP Education's e-learning courses complement our tried-and-tested classroom-based training, allowing users to improve or maintain their skills by building online learning into their schedules. Your people have the flexibility to determine what, where, and when to learn. They can repeat learning units as often as required and control the duration of learning sessions. Each E-Learning course is available for six or twelve months. And your organization can realize significant benefits in reduced travel - and the resulting time and cost savings.

E-learning courses include highly effective instructional elements and simulations based on authentic situations. By completing these courses, users gain a solid understanding of how to navigate SAP solutions and how SAP solutions can support their role-specific business processes and individual objectives - as well as your overall corporate strategy.

Our eLearning curriculum meets your needs. SAP's e-learning curriculum caters to a wide range of learning styles and subject-matter requirements. Experienced consultants, project team members, support professionals, end users, power users, and executives will find courseware to meet their needs. In addition, individuals can get the training they need without the cost of travel or time out of the office. All courses are based on real-world business scenarios and the latest learning methodologies and technological standards to provide an e-learning environment that will enable users to work more productively with the SAP solutions related to their business functions.

All SAP Online Knowledge Products and SAP eLearning sessions are non-refundable.
This course gives you the knowledge to create query definitions using the BEx Query Designer and to make them available for OLAP analysis