null
NextTech
  • All Courses
  • Applications
    • Adobe
    • Microsoft 365
    • Microsoft Apps for Business
    • Windows 10
  • Information Technology
    • AI & Machine Learning
    • Apps, Infrastructure, & Networking
    • Big Data
    • Business Applications
    • Cloud Computing
    • Data Centre
    • DevOps
    • SAP
    • Security
    • Software Development
  • Process Management
    • Agile
    • APMG
    • Business Analysis
    • IT Services
    • MSP
    • PRINCE2
    • Project Management
    • Quality
    • RESILIA
    • Software Testing
  • Professional Development
    • Business Communication
    • Sales
    • Business Skills
    • Customer Service
    • Digital Marketing
    • Learning and Development
    • Management and Leadership
    • Performance Enhancement
  • Contact Us
    • Online Evaluations
    • Training Guide
    • Google Review
  • Blog
  • Request a Quote
  • Sign in
  • Register
  • Australian Dollars
  • Request a Quote
Vertical Categories
NextTech
0
NextTech
  • Hello, sign in My Account
    • Sign in
    • Register
  • My Cart

    0 items $0
All Courses
  • Applications
    • Adobe
    • Microsoft 365
    • Microsoft Apps for Business
    • Windows 10
  • Information Technology
    • AI & Machine Learning
    • Apps, Infrastructure, & Networking
    • Big Data
    • Business Applications
    • Cloud Computing
    • Data Centre
    • DevOps
    • SAP
    • Security
    • Software Development
  • Process Management
    • Agile
    • APMG
    • Business Analysis
    • IT Services
    • MSP
    • PRINCE2
    • Project Management
    • Quality
    • RESILIA
    • Software Testing
  • Professional Development
    • Business Communication
    • Sales
    • Business Skills
    • Customer Service
    • Digital Marketing
    • Learning and Development
    • Management and Leadership
    • Performance Enhancement
  • Home
  • Contact Us
    • Online Evaluations
    • Training Guide
    • Google Review
  • Blog
  • Request a Quote

BW405 - SAP BW/4HANA Query Design and Analysis

This course provides an overview of SAP BW/4HANA and detailed knowledge to design BW Queries in both SAP BW/4HANA and SAP BW powered by SAP HANA. Users of either system will gain the knowledge to create query definitions using the eclipse-based...
MSRP:
Was:
Now: $5,368
(You save )
Brand
SAP
SKU:
SAP-BW405
Duration:
5 Days
Delivery:
Virtual Classroom
Course Date :

Adding to cart… The item has been added
Request a Quote
Share this course
  • Facebook
  • Email
  • Print
  • Twitter
  • Linkedin
  • Pinterest
  • Home
  • All Courses
  • BW405 - SAP BW/4HANA Query Design and Analysis

BW405 - SAP BW/4HANA Query Design and Analysis

This course provides an overview of SAP BW/4HANA and detailed knowledge to design BW Queries in both SAP BW/4HANA and SAP BW powered by SAP HANA. Users of either system will gain the knowledge to create query definitions using the eclipse-based BW Query Designer in SAP HANA Studio and to make them available for analysis.

  • Course Overview
  • Course Content
  • FAQs

Pre-requisites

The following pre-requisites are essential:

  • None

The following pre-requisites are recommended:

  • Experienced and sound knowledge of the subject matter of at least one SAP Business Suite or one SAP S/4HANA application course

Course Benefits

The course will prepare you to:

  • Provide students with an overview of SAP BW/4HANA
  • Provide knowledge to create query definitions using eclipse-based BW Query Designer in SAP HANA Studio and to make them available for analysis
  • Provide an overview of SAP Analytics including SAP Analytics Cloud

Audience Profile

This course is suitable for:

  • Application Consultant
  • Business Analyst
  • Power User
  • Data Consultant / Manager
  • User

Course Content

BW405 - SAP BW/4HANA Query Design and Analysis

  • Lesson 1: Introduction to SAP HANA and SAP BW/4HANA
    • Introducing SAP BW/4HANA
    • Describing the Basics of SAP HANA
    • Describing SAP BW/4HANA Data Models
    • Setting Up SAP BW/4HANA Modeling Tools in the SAP
  • Lesson 2: Report Launching and Navigation in Reports
    • Outlining SAP BusinessObjects BI Platform
    • Navigating in SAP Analysis for Microsoft Office
    • Navigating in SAP Lumira Generic Analysis Document
  • Lesson 3: Simple Queries
    • Creating Simple Queries
  • Lesson 4: Key Figures in Queries
    • Configuring Properties of Key Figures
    • Creating Restricted Key Figures
    • Creating Calculated Key Figures
    • Creating Calculated Key Figures with Boolean Operators
    • Creating Calculated Key Figures with Exception Aggregation
  • Lesson 5: Structures in Queries
    • Creating Structures
    • Resolving Formula Collision and Working with Cells
  • Lesson 6: Characteristics, Attributes, and Hierarchies
    • Configuring the Properties of Characteristics
    • Creating a Query and Running Display and Navigation Attributes
    • Adding Hierarchies to Reports
  • Lesson 7: Variables in Queries
    • Explaining Variables
    • Creating Characteristic Value and Text Variables
    • Applying Variables delivered by Business Content
    • Transferring Values Between Queries Using Characteristic Value Variables
    • Creating Formula Variables
    • Creating Hierarchy Variables and Hierarchy Node Variables
  • Lesson 8: Exceptions and Conditions in Queries
    • Creating a Query and Including Exceptions
    • Creating a Query and Including Conditions
  • Lesson 9: Report-Report Interface
    • Applying the Report-Report Interface
  • Lesson 10: Query Performance Optimization
    • Optimizing Query Performance
    • Describing the SAP BW/4HANA Analytic Manager
  • Lesson 11: Query Management
    • Managing Query Objects
  • Lesson 12: Authorizations Overview
    • Describing Authorizations
  • Lesson 13: SAP Analytics Overview
    • Outlining Strategy and Portfolio: SAP Analytics
    • SAP Analytics Cloud Overview
  • Lesson 14: Glossary
    • Glossary

FAQs

  • What products does this course align with?

    This course aligns with:

    • SAP BW/4HANA 2.0 SP07
    • SAP HANA 2.0 SPS05
    • SAP S/4HANA 2020 FP01
    • SAP HANA Studio 2.3.59
    • SAP BW/4HANA Modeling Tools 1.23.21
    • SAP Web IDE for SAP HANA 2.0 SPS05
    • SAP Analysis for Microsoft Excel 2.8
  • How do I enrol in this training?

    You can enrol in this training on our website and make an online payment using any of the following option

    • Visa Credit or Debit Card
    • MasterCard
    • American Express
    • Diners Club
    • PayPal

    Once payment is received, you will automatically receive a payment receipt and access information via email.

Buy Now

Our Most Popular Training Courses

PD1

S4H420 - SAP S/4HANA Analytics for Business Users

MSRP:
Was:
Now: $2,147

SAP

  • Duration 2 Days
View Course The item has been added
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
S4H420 - SAP S/4HANA Analytics for Business Users 2 Days
MSRP:
Was:
Now: $2,147
course info View Course
PI1

BW410 - SAP BW/4HANA Data Warehousing

MSRP:
Was:
Now: $5,368

SAP

  • Duration 5 Days
View Course The item has been added
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
BW410 - SAP BW/4HANA Data Warehousing 5 Days
MSRP:
Was:
Now: $5,368
course info View Course
PI2

BW430 - SAP BW/4HANA Modeling

MSRP:
Was:
Now: $5,368

SAP

  • Duration 5 Days
View Course The item has been added
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
BW430 - SAP BW/4HANA Modeling 5 Days
MSRP:
Was:
Now: $5,368
course info View Course
PI3

BW450 -SAP BW/4HANA Data Acquisition

MSRP:
Was:
Now: $5,368

SAP

  • Duration 5 Days
View Course The item has been added
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
BW450 -SAP BW/4HANA Data Acquisition 5 Days
MSRP:
Was:
Now: $5,368
course info View Course
PI4

BW465 -User Management and Authorizations for BW/4HANA

MSRP:
Was:
Now: $4,294

SAP

  • Duration 4 Days
View Course The item has been added
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
BW465 -User Management and Authorizations for BW/4HANA 4 Days
MSRP:
Was:
Now: $4,294
course info View Course
NextTech
Address :
Level 9 123 Pitt Street
Sydney - NSW - 2000
1300 263 559

Information

  • Contact Us
  • Blog
  • Sitemap

Brands

  • Microsoft
  • NextTech eLearning
  • VMware
  • SAP
  • AXELOS
  • View All

All Courses

  • Applications
  • Information Technology
  • Process Management
  • Professional Development
  • View All

Sign Up For Newsletter

Get the latest updates on new products and upcoming sales

PRINCE2®, PRINCE2 Agile®, MSP®, P3O®, M_o_R®, MoV®, MoP® and ITIL® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved. The Swirl logo™ is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved. CAPM is a registered mark of the Project Management Institute, Inc. PMP is a registered mark of the Project Management Institute, Inc. PMI is a registered mark of the Project Management Institute, Inc. The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc. PMBOK is a registered mark of the Project Management Institute, Inc. PMI Program Management Professional (PgMP)® is a registered mark of Project Management Institute, Inc. PMI Agile Certified Practitioner (PMI-ACP)® is a registered mark of Project Management Institute, Inc.
© 2023 NextTech. Site by Andmine Digital Agency Melbourne Digital Agency Melbourne - AndMine