Trang chủ » Node




  • The course focuses on the latest BW on HANA InfoProviders like Advanced DSO, Open ODS View and CompositeProvider. Data Extraction and Provisioning is demonstrated with the new Operational Data Provisioning Framework (ODP).

  • This course will prepare you to:
    • Work with Data Warehousing Workbench and SAP HANA Studio to set up different data models.
  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Developer
  • Enterprise Architect
  • Solution Architect
  • System Architect
  • Technology Consultant
  • None
  • Introduction to SAP HANA Architecture
  • SAP Business Warehouse (BW)
  • SAP HANA Studio
  • Data Warehousing Workbench
  • InfoObjects like Characteristics and Key Figures
  • Master Data Loading from SAP source system with Operational Data Provisioning
  • Generic DataSources
  • Transformation and Data Transfer Process
  • Difference between Classic and Graphical Data Flow Modeling
  • 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 BW powered by SAP 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 powered by SAP HANA
  • Provide knowledge to create query definitions using BW Query Designer and to make them available for analysis
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Data Consultant / Manager
  • Program / Project Manager
  • Technology Consultant
  • User
  • None.
  • 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
    • Creating 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
    • Creating Calculated Key Figures with Exception 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
    • Applying the Report-Report Interface
  • Query Performance Optimization
    • Optimizing Query Performance
    • Applying Performance Monitoring Tools
    • Configuring Query Read Mode
    • Describing the HANA-Optimized Analytic Manager
  • Query Management
    • Managing Query Objects
  • Authorizations Overview
    • Describing Authorizations
  • Business Intelligence (BI) Products Consuming Queries
    • Describing Business Intelligence Products Consuming Queries
Updating ....




  • This course will help you get the most of your SAP BW implementation by not only giving you a detailed view of operations and InfoProviders, but also by helping you to optimize performance of data loads and query execution.

  • Acquire extended knowledge and skills in SAP BW Operations
  • Acquire extended knowledge and skills in SAP BW Perfomance Optimization
  • Database Administrator
  • Solution Architect
  • Technology Consultant

Essential
BW310
Extensive SAP Data Warehousing Experience"

Content

  • An Overview of SAP NetWeaver Business Warehouse (BW), BW Accelerator, and SAP HANA
    • Identifying the Components and architecture of SAP NetWeaver BW, BW Accelerator, and SAP HANA
  • InfoProvider Administration
    • Managing InfoCubes
    • Managing DataStore Objects
    • Managing MultiProviders
    • Managing HybridProviders
    • Managing Semantically Partitioned Objects (SPOs)
    • Managing TransientProviders
    • Managing Analytical Indexes
    • Managing VirtualProviders
    • Managing Real-Time Providers
    • Creating a DataStore Object for Direct Update
  • Process Chain Administration
    • Designing Process Chains
    • Maintaining Process Chains
    • Monitoring Process Chains
  • Data Acquisition Administration
    • Describing the Data Load Cycle
    • Examining the Technical Details of Data Loading
    • Loading Master Data
    • Using Transformations
    • Monitoring Data Load
  • Working with the BW Trace Tool
    • Working with the BW Trace Tool
  • Information Lifecycle Management
    • Classic Archiving in Information Lifecycle Management
    • Making Archived Data Available for Queries Using BW Near-Line Storage
  • BW Transports
    • Describing the BW Transport System Landscape
    • Determining Object Versions and Metadata
    • Managing BW Transports
    • Transporting BEx Objects
    • Transporting Roles and Workbooks
    • Investigating Transport Strategies and Troubleshooting
  • Performance Management with BW InfoProvider Indexes
    • Determining Relational DBMS Indexes
    • Indexing for InfoProviders
  • Optimizing Performance for InfoProviders
    • Optimizing Performance for DataStore Objects
    • Optimizing Performance for InfoCubes
    • Optimizing Performance Using Semantically Partitioned Objects
    • Optimizing Performance Using Analytical Indexes
    • Optimizing Performance Using TransientProviders
    • Working with Aggregates
    • Optimizing Performance Using MultiProviders
    • Optimizing Performance Using HybridProviders
  • Optimizing Data Acquisition Performance
    • Configuring Data Acquisition Parallel Processing
    • Improving Data Acquisition Performance
    • Loading and Activating DataStore Objects
  • Performance Through Partitioning
    • Performing Table Partitioning
  • Reporting Performance
    • Designing Queries for Optimal Performance
    • OLAP Caching
    • Maintaining Query Properties
  • Managing Performance with BW Statistics
    • Getting an Overview of BW Statistics
    • Implementing Technical Content for BW Statistics
    • Administering and Analyzing BW Statistics Data
    • Monitoring with BW Administration Cockpit and BO Dashboard
  • Performance Management with BW Accelerator
    • Performance Optimization with BW Accelerator
    • Determining BW Accelerator Architecture
    • Increasing Query Read Performance Using BW Accelerator Indexes
    • Monitoring BW Accelerator
    • Envisioning the Future of SAP HANA with BW
Updating ....




Updating ....
  • Learn how to extract data from SAP source systems with Service API and how to manage delta data
  • Acquire data from other source systems using different interfaces such as: DB Connect, Universal Data Integration, XML, and Data Services
  • Application Consultant
  • Business Analyst
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Enterprise Architect
  • Program / Project Manager
  • Technology Consultant

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

Content

  • SAP BW Data Acquisition Process
    • Explaining Data Acquisition in SAP BW
    • Creating SAP BW 3.x Data Flow
    • Comparing and Migrating 3.x / 7.x SAP BW Data Flows
    • Directly Accessing Source System Data
    • Loading Directly Without Persistent Staging Area (PSA)
    • Reviewing Details of Real-Time Data Acquisition (RDA)
  • Data Acquisition with the SAP BW Service API
    • Connecting SAP Source Systems to SAP BW
    • Displaying the Configuration of SAP BW Service API
    • Explaining BI Content
    • Examining the Transfer of GL Data
    • Examining Generic DataSources
    • Enhancing BI Content DataSources
    • Configuring Logistics Data Extraction
  • Delta Data Flow Management
    • Describing Delta Management
    • Explaining Terms and Basic Processes of Delta Enabled DataSources
    • Analyzing Delta Management
  • Data Acquisition with Operational Data Provisioning (ODP) and SAP Landsape Transformation (SLT)
    • Describing Data Acquisition with ODP
    • Analyzing Operational Delta Queue (ODQ)
    • Replicating Data with SLT
    • Acquiring Data in Real Time with SLT
  • Flat File Data Transfer
    • Loading Data from a Flat File
    • Loading Hierarchies in SAP BW Using the Hierarchy Framework
    • Exporting a hierarchy using OpenHub
  • Data Acquisition with DB Connect
    • Creating a DB Connect DataSource
  • Data Acquisition with Universal Data (UD) Integration
    • Creating UD Connect DataSources
  • XML-Based Data Acquisition
    • Explaining XML-Based Extraction
    • Acquiring Data Using an XML-Based Web Service
    • Creating HybridProviders
  • Data Acquisition with SAP Business Objects Data Services
    • Integrating SAP Business Objects and SAP BW
  • Data Mart Interface and Open Hub
    • Examining the Data Mart Interface for Data Transfers
    • Implementing OpenHub Destinations
Updating ....




  • 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.4.

  • 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
BW310
Basic knowledge of data modeling

Content

  • Enterprise Data Warehouse (EDW) Architecture
    • Determining EDW Architecture
    • Planning the Architecture of an EDW
    • Using the EDW Layers
    • Determining the Purpose of the Data Mart Layers
    • Determining the Purpose of the Operational Data Store Layer
  • The Modeling Process
    • Identifying Decision Areas within SAP BW Projects
    • Performing Requirements Analysis
    • Creating a Logical Data Model
    • Developing the SAP BW Data Model
    • Creating Graphical Data Models and Templates
  • Data Modeling Practice
    • Drafting a Data Model
    • Summarizing Data Modeling Practice
  • BI Content Analysis
    • Listing the Uses of BI Content
    • Comparing a Data Model with BI Content
  • InfoObject Models
    • Listing the Tables in the SAP BW Data Model
    • Implementing Tracking History Scenarios
    • Using Reference Characteristics
    • Using Hierarchies
    • Using Key Figures
    • Creating Translation Types for Currency Translation
    • Creating Translation Types for Quantity Conversion
    • Creating a Data Model for Mapping Non-Cumulative Values in SAP BW
  • Modeling DataStore Objects
    • Modeling DataStore Objects
    • Using Real Time Data Acquisition (RDA)
  • Multi-Dimensional Modeling
    • Determining the SAP BW Star Schema
    • Designing the Dimensions of the SAP BW InfoCube
  • Enhanced InfoProvider Modeling
    • Modeling MultiProviders
    • Modeling an SPO
    • Modeling an InfoSet
    • Modeling a VirtualProvider
    • Modeling a HybridProvider
    • Explaining InfoProviders in SAP BW and the InfoProvider Decision Tree
  • Data Model Remodeling
    • Modifying a Data Model
  • Information Lifecycle Management
    • Describing Information Lifecycle Management
  • LSA++ with SAP BW on SAP HANA
    • Determining the Advantages of SAP BW on SAP HANA
    • Determining the Enhancements of LSA++ with SAP HANA
Updating ....




Updating ....
  • Participants will gain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscape The knowledge you will acquire will form the basis for more advanced courses in the BW curriculum
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Program / Project Manager
  • Technology Consultant
  • User

Essential

  • Basic knowledge of Data Warehousing

Content

  • Data Warehousing
    • Describing Data Warehouse Systems
    • Describing Data Warehouse Architecture
    • Using the Data Warehousing Workbench
  • Master Data Modeling in SAP BW
    • Describing InfoObjects
    • Creating Characteristic InfoObjects
  • The Loading of Master Data from SAP Data Sources
    • Describing Data Flow
    • Modeling a Master Data Flow
    • Loading a Master Data Flow
    • Modeling with the Graphical Data Flow Tool
  • Loading of Transaction Data from SAP DataSources
    • Describing the Core InfoProviders
    • Creating a Key Figure InfoObject
    • Creating a DataStore Object (DSO)
    • Loading Transaction Data into a Data Store Object
    • Describing the Extended Star Schema of an InfoCube
    • Creating InfoCubes
    • Loading Transaction Data into an InfoCube
  • Master Data Loading from Flat File Data Sources
    • Loading Data From a Flat File
    • Describing the Data Flow in Detail
    • Describing the Data Loading Process in Detail
  • InfoProviders in SAP BW
    • Explaining the InfoProviders Used in SAP BW – Introduction
    • Creating MultiProviders
  • Usage of SAP BI Content
    • Using BI Content
  • Query Performance Optimization
    • Optimizing Query Performance
    • Monitoring Performance
    • Creating and Filling Aggregates
  • The SAP BW Administration
    • Describing Administrative Tasks and Tools
    • Administrating the InfoCubes
    • Administrating the DataStore Objects
    • Creating Process Chains
Updating ....




Updating ....
  • Create complex Web Intelligence documents using advanced query and reporting techniques, including:
    • Combined queries and sub-queries
    • Character and date string functions
    • Variables and calculation contexts
    • Link documents using hyperlinks"
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User

Essential
BOW310 SAP BusinessObjects Web Intelligence: Report Design

Content

  • Web Intelligence Core Report Design
    • Reviewing Core Report Design Concepts
  • Multiple Data Sources
    • Synchronizing Data from Multiple Data Sources
    • Creating Multiple Queries in a Document
    • Synchronizing Data with Merged Dimensions
    • Interacting with Other Data Providers
  • Advanced Query Techniques
    • Implementing Combined Queries
    • Implementing Subqueries
    • Creating a Query Based on Another Query
    • Changing Data Sources
  • Calculation Contexts
    • Describing Calculation Contexts
    • Redefining Calculation Contexts
    • Implementing Extended Syntax Operators
    • Implementing Extended Syntax Keywords
    • Defining Calculation Context
  • Formulas with Character and Date String Functions
    • Creating Formulas with Character and Date String Functions
    • Implementing the Right() Function
    • Implementing the Replace() Function
    • Implementing the SubStr() Function
    • Implementing the Pos() Function
    • Concatenating Character Strings
    • Implementing Date Functions
  • If Logic
    • Grouping Data
    • Executing the If() Function to Modify Calculation Behavior
  • Additional Reporting Techniques
    • Implementing Data Tracking
    • Implementing Additional Report Functions
  • Link Options in Web Intelligence Documents
    • Managing Links in Web Intelligence Documents
    • Using Element Linking to Filter Data
  • Managing Hyperlinks in the Web Intelligence Interactive Panel
Updating ....




  • This 2-day instructor-led course is designed to give you the comprehensive skills and in-depth knowledge needed to access, analyze and share data using SAP BusinessObjects BI launch pad and SAP BusinessObjects Web Intelligence™. You will learn how to create Web Intelligence documents for your reporting needs, to retrieve data by building queries using SAP BusinessObjects universes and to use Web Intelligence to enhance documents for easier analysis. You’ll also learn how to organize, manage and distribute documents using the BI launch pad.

  • Manage personal and corporate documents to access the information you need, when you need it.
  • Design your own reports using Web Intelligence and share your analysis with other users.
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User

Essential

  • None

Content

  • Web Intelligence
    • Describing Web Intelligence Concepts
    • Explaining Web Intelligence Core Functions
  • Web Intelligence Documentation Management
    • Describing Web Intelligence and the SAP BusinessObjects Business Intelligence Platform
    • Logging In to the BI Launch Pad
    • Viewing a Web Intelligence Document in the BI Launch Pad
    • Sharing Web Intelligence Documents
    • Setting BI Launch Pad Preferences
    • Logging Off From the BI Launch Pad
    • Publishing Documents to the Corporate Repository
    • Managing Documents in BI Launch Pad
  • Web Intelligence Documents with Queries
    • Creating Queries
    • Creating a Document
    • Modifying a Document’s Query
    • Modifying Queries
  • Data Return Restrictions from Queries
    • Restricting Data with Query Filters
    • Modifying a Query with a Predefined Query Filter
    • Applying a Single-Value Query Filter
    • Using Wildcards in Query Filters
    • Using Prompts to Restrict Data
    • Using Complex Filters
  • Web Intelligence Document Design
    • Modifying Web Intelligence Documents
    • Displaying Data in Tables
    • Using Tables
    • Presenting Data in Free-standing Cells
    • Presenting Data in Charts
  • Presentation of Data in Documents
    • Using Breaks and Calculations
    • Using Sorts and Hiding Data
    • Formatting Breaks and Cross Tables
    • Filtering Report Data
    • Ranking Data
    • Highlighting Information with Formatting Rules
    • Organizing a Report into Sections
  • Web Intelligence Document Formatting
    • Formatting Documents
    • Formatting Charts
  • Data Calculation
    • Applying Formulas and Variables
    • Using Formulas and Variables
  • Drilling Functionality
    • Analyzing the Data Cube
    • Drilling in a Web Intelligence Document
  • Comparing the Web Intelligence Clients
    • Comparing the Web Intelligence Clients
Updating ....




Updating ....
  • Create applications for desktop clients and mobile devices using SAP Lumira 2.0 Designer previously known as SAP BusinessObjects Design Studio.
  • Project team members
  • Application consultants

Essential

  • None

Content

  • Positioning and Architecture for both SAP Lumira 2.0 clients
  • Create script free applications
    • adding online and offline data to an Application
    • using Table components
    • using Chart components
    • using Filter Components
    • using Container components
    • using Basic components
    • using components with data bound properties
    • using the Scorecard component for highly formatted tables
    • using conditional formatting settings within the application
    • using existing re-usable composites
  • Define the layout of applications
    • understanding the usage of Templates
    • using predefined Themes
    • using the direct CSS property
    • using a Custom CSS file
    • using the Adaptive Layout Container
  • Create advanced applications using scripting techniques
    • Introduction to scripting
    • defining the navigation behavior of basic components with scripting
    • using local variables in script functions
    • using global variables as URL parameter
    • using global script objects and formatter functions
    • defining exporting functionality
  • Understanding the existing Interoperability Scenarios e.g. to SAP BusinessObjects Analysis
Updating ....




Updating ....
  • Explain SAP Lumira
  • Create documents and acquire data
  • Prepare datasets
  • Visualize data
  • Share stories
  • Application consultants
  • Business Analyst
  • Executive
  • Technology Consultant
  • User

Essential

  • None

Content

  • Positioning and Overview of SAP Lumira Discovery
  • Navigating the BI Launchpad
  • Acquiring Data
  • Enrich the Dataset
  • Create a Story
  • Create Visualizations
  • Export Options
  • Using the Lumira Discovery Formula Editor
  • Additional Data Sources
  • Working with Multiple Datasets
Updating ....

Trang