We provide online course about BW305H SAP BW powered by SAP HANA: BW Query Design. Please register for BW405 as the course to provide an overview of query design for both SAP BW powered by SAP HANA and SAP BW/4HANA.
Course announcements:
In BW405 you will gain the knowledge to create query definitions using the eclipse-based BW Query Designer in SAP HANA Studio (used with BW powered by SAP HANA) and to make them available for analysis.
Course based on software release:
• SAP BW 7.5 on SAP HANA
Goals:
This course will prepare you to:
• Provide students with an overview of SAP BW powered by SAP HANA
• Provide knowledge to create query definitions using BW Query Designer and to make them available for analysis
Content:
1) Introduction to SAP HANA and SAP Business Warehouse (BW):
• Describing the Evolution and Data Layout of SAP HANA
• Describing the Concepts of Business Intelligence (BI) and Data Warehousing on Any Database
• Outlining the Basics of SAP BW Powered by SAP HANA
• Set Up SAP BW Modeling Tools in SAP HANA Studio
2) Report Launching and Navigation in Reports:
• Outlining SAP BusinessObjects BI Platform
• Navigating in SAP BusinessObjects Analysis, Edition for Microsoft Office
• Navigating in SAP BusinessObjects Design Studio Generic App
3) Simple Queries:
• Creating Simple Queries
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
5) Structures in Queries:
• Creating Structures
• Resolving Formula Collision and Working with Cells
6) Characteristics, Attributes, and External Hierarchies in Queries:
• Configuring the Properties of Characteristics
• Creating a Query and Running Display and Navigation Attributes
• Creating Queries and Including External Hierarchies
7) Variables in Queries:
• Explaining Variables
• Creating Characteristic Value and Text Variables
• Applying Business Content Variables
• Creating Characteristic Value Variables with a Replacement Path from a Query
• Creating Formula Variables
• Creating Hierarchy Variables and Hierarchy Node Variables
8) Exceptions and Conditions in Queries:
• Creating a Query and Including Exceptions
• Creating a Query and Including Conditions
9) Report-Report Interface:
• Applying the Report-Report Interface
10) Query Performance Optimization:
• Optimizing Query Performance
• Applying Performance Monitoring Tools
• Configuring Query Read Mode
• Describing the HANA-Optimized Analytic Manager
11) Query Management:
• Managing Query Objects
12) Authorizations Overview:
• Describing Authorizations
13) Business Intelligence (BI) Products Consuming Queries:
• Describing Business Intelligence Products Consuming Queries
Target audience:
• Application Consultant
• Business Analyst
• Business Process Owner / Team Lead / Power User
• Data Consultant / Manager
• Program / Project Manager
• Technology Consultant
• User
Prerequisites:
• Essential: None
• Recommended: Experienced and sound knowledge of the subject matter of at least one SAP ERP application course