SAP Business Intelligence ( BI )

BW305 : SAP Business Warehouse Query Design and Analysis

Course Duration

5 Days

Delivery

ILT/VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

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

What You'll Learn

N/A

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
ERP application course

Learning Journey

Coming Soon...

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 is not associated with any Certification.

Frequently Asked Questions (FAQs)

None

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By SAP

Browse All Courses

SAP Solution Overviews

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name

Phone

I'm inquiring for

Myself

Company

Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.