Trang chủ » Node




  • This course is designed for users with some experience in BW/4HANA or for users who have visited BW410 who know the BW/4HANA terms and basic data warehousing tasks. They learn to design a LSA++ layered architecture model and BW/4HANA object models. Focus topics are master data (especially hierarchies), open ODS views, Composite Providers, staging scenarios with InfoSource, Calculation views, BW Workspaces, currency and unit conversion.

  • Outlining advantages of the new SAP "In-Memory" database foundation for SAP BW in general.
  • Understanding modeling requirements.
  • Best Practices guidelines such as separating master data and transactional data, LSA++ for SAP BW/4HANA, partitioning.
  • Describing steps in designing an architecture overview and a detailed data model.
  • Comparing BI Content with requirements
  • Explaining field-based modeling.
  • Creating hierarchies with BW/4HANA InfoObjects or native SAP HANA calculation views
  • Master data reporting using hierarchies
  • Harmonizing transactional data from two different sources
  • Currency Conversion in BW/4HANA transformations or in native SAP HANA calculation views
  • Generating external HANA views, and designing "mixed scenarios".
  • Implementing HANA Analysis Processes.
  • Designing Inventory Management
  • Designing Stock coverage scenarios
  • Application experts and consultants with a basic experience in SAP BW/4HANA
  • Project team members implementing and maintaining SAP BW/4HANA

Hands-on experience in data warehousing with SAP BW/4HANA
BW410 (SAP BW Enterprise Data Warehousing with SAP BW/4HANA)

  • Challenges for Data Modeling
    • Introduction to Data Modelling
    • Solving Requirement Conflicts
  • Overview about the Business Case
    • Getting to know the ItelO Case Study
    • Understanding the Source Model
  • Modeling Approaches in SAP BW/4HANA
    • Introducing SAP HANA modeling
    • Advantages and issues of SAP BW modeling
    • Comparing SAP BW/4HANA focus, SAP HANA focus and mixed strategies
  • Best Practice Standards in BW/4HANA Modeling
    • Optional: Understanding Object Changeability
    • Separating Master Data and Transactional Data
    • Tracking history
    • Mapping and Transforming Data
    • Designing a Layered Scalable Architecture with Virtual Layers (LSA+
    • Understanding Physical and Logical Partitioning
  • Process of Modeling
    • Defining the Sequence of SAP BW/4HANA Projects
    • Planning the Phases of a SAP BW/4HANA Project
    • Performing a Requirement Analysis
    • Creating an Architecture Overview
    • Creating a Logical Data Model
    • Developing a SAP BW/4HANA Data Model
  • as
    • Working with SAP Business Content
    • Introducing ABAP CDS Views provided by SAP BW/4HANA
  • Implementing Native SAP HANA Views
    • Modeling Master Data
    • Modeling Transactional Data
  • Implementing SAP BW/4HANA Field-Based Rapid Prototyping
    • Implementing Field-Based Modeling with Open ODS Views
    • Implementing Snapshot and Corporate Memory Models with Advanced DataStore Objects
  • Implementing Models in SAP BW/4HANA
    • Modeling and Implementing SAP BW/4HANA Master Data
    • Modeling and Implementing InfoSources
    • Modeling and Implementing Advanced DataStore Objects (ADSOs)
    • Modeling and Implementing Transformations
    • Modeling and Implementing CompositeProviders
  • Implementing Agile Data Marts
    • Generating External SAP HANA Views
    • Enhance an External SAP HANA View
  • Implementing SAP BW/4HANA Workspaces
    • Defining a Workspace
    • Implementing Local Composite Providers
  • Advanced Modeling in SAP BW/4HANA
    • Introducing the HANA Analysis Process (HAP)
    • Defining Inventory Scenarios
    • Stock Coverage
    • Planning Mode
    • Additional Sources of Information
Updating ....




  • The course introduces the BW/4HANA Data Warehousing. InfoProviders like Advanced DSO, Open ODS View and CompositeProvider are explained and created. Data Extraction and Provisioning is executed with Operational Data Provisioning Framework (ODP). Native HANA data models are created and combined with BW data models.

  • Understand the architecture and fundamentals of SAP BW/4HANA
  • Create and maintain InfoObjects, Advanced DataStore Objects, CompositeProviders, and ODS Views
  • Perform master and transaction data load into SAP BW/4HANA
  • Understand SAP HANA native models
  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Developer
  • Enterprise Architect
  • Solution Architect
  • System Architect
  • Technology Consultant
  • none
  • Introduction to SAP BW/4HANA Architecture
  • SAP Business Warehouse (BW)
  • SAP HANA Studio
  • InfoObjects like Characteristics and Key Figures
  • Master Data Loading from SAP source system with Operational Data Provisioning
  • Generic DataSources
  • Transformation and Data Transfer Process
  • Modelling DataStore Object (Advanced)
  • Transactional Data Loading from SAP source system with Operational Dat Provisioning
  • Data Loading from Flatfile
  • Modeling CompositeProviders
  • HANA Native Modeling with Calculation Views
  • Modelling Open ODS Views
  • Process Chains
Updating ....




  • This course provides an overview of SAP BW4/HANA, and gives you the knowledge to create query definitions using the eclipsed based BW Query Designer in SAP HANA Studio, and to make them available for analysis.

  • 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
  • Application Consultant
  • Business Analyst
  • Power User
  • Data Consultant / Manager
  • User
  • none
  • Introduction to SAP HANA and SAP BW/4HANA
  • Report Launching and Navigation in Reports
  • Simple Queries
  • Key Figures in Queries
  • Structures in Queries
  • Characteristics, Attributes, and External Hierarchies in Queries
  • Variables in Queries
  • Exceptions and Conditions in Queries
  • Report-Report Interface
  • Query Performance Optimization
  • Query Management
  • Authorizations Overview
  • SAP Analytics Products Consuming Queries
Updating ....




Updating ....
  • Understand the key concepts of SAP HANA and in-memory computing
  • Create a data model with SAP HANA native modeling tools
  • Provision data to SAP HANA
  • Consume SAP HANA Information Views and run applications on SAP HANA
  • Application Consultant
  • Change Manager
  • Data Consultant / Manager
  • Developer
  • None
  • Introduction
  • Architecture
    • Explore the SAP HANA landscape
    • Interfaces for administrators and developers
    • Learn about the in-memory database
    • Explain High Availability
    • Describe the main security features
  • Modeling and Data Processing
    • Create Information Models
    • Exploring SAP supplied virtual data models (HANA Live and CDS)
    • Define Spatial Processing, Text Search and Analysis, Predictive modeling, Graph modeling
  • Data Provisioning
    • Understand the main data provisioning scenarios
    • Overview of SAP HANA Vora
    • Overview of all SAP HANA data provisioning tools
  • Running Applications on SAP HANA
    • Describe the different types of applications supported by SAP HANA
    • Overview of native application development using XS
    • Connect SAP Business Intelligence tools to SAP HANA
    • Overview of Data Warehousing Foundation
    • Use SAP Business Warehouse with SAP HANA
Updating ....




Updating ....
  • Describe how security is implemented in SAP BW.
  • Implement and manage security in an SAP BW environment.
  • Application Consultant
  • System Administrator

Essential
ADM940 or previous SAP security experience in SAP ERP.

  • SAP Business Warehouse (BW)
    • Identifying SAP BW Architecture and Administration Tools
    • Creating and Modifying SAP Business Explorer (BEx) Queries
  • Security Components
    • Comparing Transactional and Analytical Security Needs
    • Differentiating Between Standard and Analysis Authorizations
    • Protecting Data with Analysis Authorizations
    • Identifying the Prerequisites for Analysis Authorizations
  • Standard Authorization Objects for Reporting Users
    • Creating Standard Authorizations for Reporting Users
  • Special Authorization Objects for Reporting Users
    • Creating Analysis Authorizations for InfoProvider Data
    • Enabling and Disabling the InfoArea Structure
    • Identifying the Differences Between the Handling of Workbooks and Queries in Roles
  • Analysis Authorizations
    • Creating Analysis Authorizations for Specific InfoProvider Data
    • Creating Analysis Authorizations for Specific Characteristic Values
    • Creating Analysis Authorizations for Aggregated Values
    • Creating Analysis Authorizations for ""Not Assigned"" Values
    • Creating Analysis Authorizations for Display and Navigational Attributes
    • Creating Key Figure Authorizations
    • Creating Hierarchy Authorizations
    • Adding Variables to Authorizations
  • Maintenance of Authorizations
    • Maintaining Authorizations
  • Data Access for Administrators and Users
    • Securing Data Access for Administrators
    • Assigning Role-Based Authorizations using Templates
    • Tracing Performance Issues
    • Setting Up System Communication Security
  • Migration of Reporting Authorizations to Analysis Authorizations
    • Migrating Reporting Authorizations to Analysis Authorizations
  • SAP NetWeaver Portal
    • Managing SAP NetWeaver Portal Access for SAP BW Users
    • Publishing SAP BW Content in the SAP NetWeaver Portal
  • SAP BusinessObjects Business Intelligence (BI) Platform + Integrating SAP BW Security into the SAP BusinessObjects BI Platform
    • Managing SAP BusinessObjects BI Platform Access for SAP BW Users
  • Additional Topics in SAP BW
    • Differentiating Between Planning Tools
    • Identifying the Interaction Between Planning and Other SAP BW Activities
    • Preventing and Troubleshooting Performance Issues
    • Generating Structural Authorizations from SAP ERP Human Capital Management (HCM)
Updating ....




  • Availability as of January 2017
  • This course enables experienced SAP BW Query Designer users to create BW Queries with BW Query Designer in SAP HANA Studio in an SAP BW powered by SAP HANA system environment. This course is targeted at experienced users of BEx Query Designer who are migrating to a SAP Business Warehouse powered by SAP HANA system.

  • Understand and get an overview of SAP BW powered by SAP HANA from a Reporting perspective
  • Learn the process of creating BW Queries with the new BW Query Designer in SAP HANA Studio
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Data Consultant / Manager
  • Technology Consultant

Profound Knowledge of BEx Query Designer (BW305, TBI10)

  • Introduction to SAP HANA
  • Comparison of SAP Business Warehouse on any database with SAP Business Warehouse running on SAP HANA database with focus on the reporting and analysis
  • Overview of SAP HANA Studio and BW Modelling Tools
  • Creation of BW Queries with BW Query Designer in SAP HANA Studio
  • Differences of BW Query Designer in SAP HANA Studio to BEx Query Designer relating to Queries, reusable query elements and where-used- list
  • Basic concepts of query performance optimization
  • Overview of Business Intelligence (BI) products based on SAP BW Queries (BI Platform server, Analysis for Office, Design Studio, Lumira, Web Intelligence, Crystal Reports)
Updating ....




  • This course enables experienced SAP BW users, modelers as well as administrators to run and work with SAP BW on SAP HANA. The highlight is on how to optimize an existing SAP BW architecture and leverage new data models and functions provided by SAP HANA. This course also provides the foundation to plan the further roadmap towards SAP BW/4HANA.

  • Outlines advantages of the new SAP "In-Memory" database foundation for SAP BW.
  • Explains HANA specific features as well as optimized existing and new data models or functions of SAP BW.
  • Enables you to support a migration project to SAP BW on SAP HANA from application side.
  • Introduces the SAP architecture framework of LSA++ and provides guidelines on how to adapt your existing one.
  • Explains native HANA modeling and how both, HANA information views as well as BW InfoProviders can complement each other in so-called "mixed scenarios".
  • Provides an overview on new SAP HANA-related data provisioning methods for SAP BW including HANA Smart Date Integration
  • Gives an overview of SAP´s next generation Data Warehouse Solution SAP BW/4HANA and how to get there
  • SAP BW application consultants
  • Project team members implementing and maintaining SAP BW on SAP HANA.

Essential
BW310
Hands-on experience in data modeling with SAP BW 7.x

  • Getting started
    • SAP HANA Basics
    • SAP BW Basics
    • SAP HANA BW Modeling Tools
    • SAP HANA Native Modeling
    • SAP HANA Live
    • SAP S/4HANA embedded Analytics
  • Migration to SAP BW on HANA
    • Migration Strategies and Tools
    • SAP BW Migration Cockpit
  • BW on HANA Data Management
    • Multi-Temperature Data Management
    • Optimizing BW Data Management based on Dynamic Tiering as well as Active/Non-Active Concept
    • Optimizing BW Data Management based on Nearline-Storage
  • Optimization Areas in BW on HANA
    • HANA-Optimized Data Modeling: InfoCubes
    • HANA-Optimized Data Modeling: Advanced DataStore-Objects
    • HANA-Optimized Data Modeling: CompositeProviders
    • HANA-Optimized Data Modeling InfoObjects
    • HANA-Optimized Data Staging and Transformations
    • HANA-Optimized Analytic Manager
    • HANA-Optimized Analysis Processes
  • Modeling with SAP´s Reference Architecture LSA++
    • Review of Layered Scalable Architecture (LSA)
    • From LSA to LSA++: Streamline Core Layers
    • LSA++: Open Operational Data Store Layer based on Open ODS Views
    • LSA++: BW Workspaces
  • Hybrid Modeling in Mixed Scenarios
    • Generation of HANA-Views for BW Objects
    • Modeling Mixed Scenarios
    • HANA-Optimized BI Content
    • Use case for Mixed Scenarios: SAP BusinessObjects Predictive Analytics
  • Data Provisioning into SAP HANA and SAP BW
    • Overview of Data Provisioning Methods into SAP HANA
    • SAP LT Replication into SAP HANA
    • SAP HANA Smart Data Integration for SAP BW
    • Operational Data Provisioning into SAP BW
    • DB-Connect and Open Hub Destination
  • Summary & Outlook
    • Introduction of SAP BW/4HANA
    • The HANA Data Warehouse
    • Overview of new Transactions and Authorizations
Updating ....




Updating ....
  • Understand the Components and Architecture of SAP BW and SAP HANA
  • Create and Manage CompositeProviders and ADSO
  • Perform Delta Merge
  • Administer and Monitor Data Acquisition
  • Information Lifecycle Management
  • Manage SAP BW Transports
  • Manage SAP HANA Transports
  • Optimize Query Performance
  • Administer and Analyze BW Statistics
  • SAP HANA Administration for BW
  • Database Administrator
  • Enterprise Architect
  • Solution Architect
  • System Administrator
  • Technology Consultant

Essential
BW310H

  • SAP Business Warehouse and SAP HANA Overview
    • Identifying the Components and Architecture of SAP BW and SAP HANA
  • InfoProvider Administration
    • Describing InfoProvider
    • Managing ADSO
    • Managing Open ODS View
    • Creating and Managing CompositeProviders
  • Delta Merge
    • Describing Delta Merge in BW
  • Data Acquisition Administration and Monitoring
    • Describing Data Acquisition Administration into SAP BW
    • Loading Master Data
    • Designing Process Chains
    • Maintaining Process Chains
    • Monitoring Process Chains
    • Using Transformations
    • Describing Data Aqusition in SAP HANA
  • Information Lifecycle Management
    • Describing Multi Temperature Data Management
    • Optimizing SAP BW Data Management (Warm Data)
    • Optimizing SAP BW Data Management (Cold Data)
  • SAP BW Transports
    • Describing the BW Transport System Landscape
    • Determining Object Versions and Metadata
    • Managing BW Transports
    • Transporting Query Objects
    • Troubleshooting Transport Strategies
  • SAP HANA Transports
    • Explaining SAP HANA Transports
  • Optimization Areas in SAP BW on SAP HANA
    • Describing HANA Optimized Data Modeling for InfoProviders
    • Improving Data Acquisition Performance
  • Performance in Reporting
    • Getting Acquainted with SAP HANA Analytic Manager
    • Designing Queries for Optimal Performance
    • Optimizing Query Performance Using the Online Analytical Processing (OLAP) Cache
  • Performance Management with BW Statistics
    • Optimizing Performance with BW Statistics
    • Implementing Technical Content for BW Statistics
    • Administering and Analyzing BW Statistics Data
    • Monitoring with BW Administration Cockpit
  • SAP HANA Administration for BW
    • Explaining Database Traces
    • Describing the DBA Cockpit
    • Analysing Memory Usage
    • Analyzing the Performance of SAP HANA Views
  • Additional topics for SAP BW on SAP HANA
    • Describing SAP HANA Data Warehousing Foundation
    • Explaining Solution Manager Configuration and Monitoring
    • Describing BW Housekeeping Tasks
    • Describing BW/4HANA
    • Performing Traces with BW Trace Tool
Updating ....




  • You will learn how to design and maintain your own data flow components including Process Chains. You will work with data flows for attributes, text, hierarchies, and transaction data. You will learn how to position the various interface options. You will work with the Service API as well as the ODP to extract data from ECC for example. You will learn how the delta mechanism works for the Service API, ODP, and other interfaces. You will learn about Smart Data Integration and Smart Data Access. You will perform flat file imports and how to extract with Data Services. You will learn how to perform debug with the Data Transfer Process (DTP) as well as how to use the DTP Full vs. Delta settings. You will learn how to do transports for all BW objects.

  • Learn how to extract data from SAP source systems with the SAP API (Application Programming Interface) and how to manage delta data
  • Acquire data from using different interfaces such as : SDI - Smart Data Integration, SDA - Smart Data Access, ODP -Operational Data Provisioning, Flat File, DB Connect, XML, and Data Services
  • Design and maintain process chains and perform transports * Distribute data via Data Marts and Open Hub
  • Developer
  • Solution Architect
  • System Administrator
  • Technology Consultant
  • Trainer

Essential
Sound knowledge of the content that is covered in BW310H - Data Warehousing course, especially working with the Data Warehousing Workbench

  • SAP BW and HANA Data Acquisition
    • Introducing BW and HANA
    • Explaining Data Acquisition in SAP BW
    • Explaining SAP HANA Optimized Data Staging
    • Comparing & Migrating 3.x to 7.x Data Flow Components
    • Introducing Data Replication to HANA using SLT, SDI, and SDA
  • Data Acquisition with the SAP BW Service API
    • Connecting SAP Source Systems to SAP BW
    • Displaying the Configuration of the SAP BW Service API
    • Modeling Generic DataSources
    • Explaining Business Intelligence(BI) Off The Shelf Content
    • Loading hierarchies from ECC
    • Examining the Transfer of GL Data
    • Adapting BI Content DataSources
    • Implementing Process Chains
  • Delta Data Flow Management
    • Describing Delta Management
    • Explaining Terms and Basic Processes of Delta Enabled DataSources
    • Configuring the Logistics Data Extraction (LO Cockpit)
    • Configuring Generic Delta DataSources
    • Learning Data Transfer Process(DTP) Settings
  • Data Acquisition with ODP and SLT
    • Describing Data Acquisition with Operational Data Provisioning (ODP)
    • Analyzing Operational Delta Queue (ODQ)
    • Replicating Data with SAP Landscape Transformation (SLT)
    • Learning the Details of Real Time Data Acquisition (RDA)
    • Extracting to BW via ODP-SLT
  • Flat File Data Transfer
    • Accessing Data from a Flat File
    • Loading Flat File Hierarchies
    • Using Workspaces for Local Flat File load
  • Additional Data Acquisition Techniques
    • Positioning DB Connect
    • Positioning Universal Data (UD) Integration
    • Explaining XML-Based Extraction
    • Acquiring Data Using an XML Based Web Service
    • Integrating SAP Data Services and SAP BW
    • Positioning HANA SDI capabilities for BW
  • Data Mart Interface and OpenHub
    • Positioning the Data Mart Interface
    • Implementing OpenHub Destinations
    • Exporting a Hierarchy with OpenHub
    • Exporting from a BW InfoProvider to a Native HANA Table
  • Overview of BW Transports
    • Describing the BW Transport System Landscape
    • Determining Object Versions and Metadata
    • Managing BW Transports
    • Troubleshooting Transport Strategies
Updating ....




  • Course Availability as of February 2017
  • Learn the procedures within modeling of the BW Enterprise Data Warehouse and acquire deep knowledge about modeling and implementation of data warehousing with SAP BW 7.5.

  • Learn procedures within modeling of SAP Business Warehouse
  • Learn how to create a Layered Scalable Architecture
  • Application Consultant
  • Business Analyst
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Enterprise Architect
  • Program / Project Manager
  • Technology Consultant

Essential

BW310H
Basic knowledge of data modeling

  • 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
    • Defining the Sequence of SAP BW Projects
    • Planning the Phases of a SAP BW Project
    • Creating a Logical Data Model
    • Developing a SAP BW Data Model
  • Field-Based Rapid Prototyping
    • Getting an Overview SAP HANA Live
    • Overviewing Business Content
    • Implementing Field-Based Modeling
  • Master Data Modeling in SAP HANA Views
    • Using Hierarchies in SAP HANA Views
  • Transaction Data Modeling with SAP HANA
    • Using Measures in SAP HANA Views
  • Master Data Modeling with SAP BW Characteristics
    • Listing Tables in the SAP BW Data Model
    • Using Reference Characteristics
    • Using Hierarchies in SAP BW Characterisitcs
  • Key Figure Modeling in SAP BW
    • Defining Key Figures as InfoObjects
    • Creating Translation Types for Currency Translation
    • Creating Translation Types for Quantity Conversion
    • Creating a Data Model for Calculating Stock Coverage
    • Creating a Data Model for Non-Cumulative Values
  • Transactional Data Modeling in SAP BW
    • Modeling Advanced DataStore Objects (ADSOs)
    • Modeling a Composite Provider for Agile Data Mart Scenarios
    • Implementing Tracking History Scenarios
    • Modeling Transformations
  • Hybrid Modeling in Mixed Scenarios
    • Modeling Mixed Scenarios
    • Enhancing Views in SAP HANA
  • Areas of SAP BW Workspaces
    • Modeling a Workspace
  • Enhanced Scenarios in SAP BW
    • Implementing Enhanced Scenarios
  • Existing Model Enhancement
    • Converting Silos or LSAs to LSA
    • Using the SAP BW Remodeling Toolbox
    • Remodeling with an SPO in SAP BW
  • Optional: SAP BW Data Management
    • Implementing Dynamic Tiering
    • Implementing Lifecycle Management and Near-Line Storage (NLS)
Updating ....

Trang