• 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
• 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
• Simple Queries
• Key Figures in Queries
Configuring Properties of Key Figures
Creating Restricted Key Figures
Creating Calculated Key Figures
Creating Calculated Key Figures with Boolean Operators, Aggregation
• Structures in Queries
Creating Structures
Resolving Formula Collision and Working with Cells
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
• 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
• Exceptions and Conditions in Queries
Creating a Query and Including Exceptions Creating a Query and Including Conditions
• Report-Report Interface
• Query Performance Optimization
• Query Management
• Authorizations Overview
• Business Intelligence (BI) Products Consuming Queries
• Data Modeling with SAP Business Information Warehouse (SAP BW) Powered by SAP HANA
Understanding Modeling Targets and Issues
Understanding SAP HANA From a Modeling Perspective
Understanding SAP BW From a Modeling Perspective
Comparing SAP BW with SAP HANA
Understanding the Strategy for SAP BW on SAP HANA
• Business Review
Mapping Current Processes
Getting to Know the ITelO Case Study
Understanding the Relevant Skills and Exercises
• Global Decision Areas and Best Practice Standards
Evaluating Global Standards and Local Adaptations
Planning Transport Management
Separating Master Data and Transactional Data
Designing a Layered Scalable Architecture (LSA) with Virtual Layers
Understanding Scenarios for SAP BW on SAP HANA
Understanding LSADomains
Understanding Reporting Options
• Process of Modeling
• Field-Based Rapid Prototyping
• Master Data Modeling in SAP HANA Views
• Transaction Data Modeling with SAP HANA
• Master Data Modeling with SAP BW Characteristics
• Key Figure Modeling in SAP BW
• Transactional Data Modeling in SAP BW
• Hybrid Modeling in Mixed Scenarios
• Criação e implementação de Business Case