HANA2.0, BW 7.4, BODS

$ 100.52 $ 50.26

Categories: ,
Description

Description

HANA 2.0 COURSE CONTENT

SAP HANA

  • Modeler , Administration View, Navigator

MODELLING in SAP HANA

  • Create Attribute Views
  • Design Analytical Views
  • Create Calculation Views from multiple analytical
  • Views
  • Best Practices while Creating Information
  • Models
  • Performance Optimisation techniques in SAP HANA
  • Currency Conversion
  • Variables in HANA
  • Meta data import to SAP HANA Using SAP
  • Export Models
  • Import Models
  • SQL Script
  • CE Functions
  • Procedures
  • Hierarchies– Level Based Hierarchies and Parent Child Hierarchies
  • Restricted Measures&Calculated Measures&Calculated Attributes
  • Joins in SAP HANA: Referential Join,Text Join, Inner Join, Right Outer Join & cardinalities
  • Auto Documentation of Information Models

Data Reporting

  • SAP BIBO 4.0 Reporting Tools connectivity with SAP HANA
  • Microsoft Excel 2010 Connection to HDB
  • Create Universe through Information Design Tool using JDBC Connections
  • Web Intelligence Document on SAP HANA Universe REPORTING TOOL.
  • IDT Designing TOOL
  • SAP LUMITRA
  • BO Analysis for Office
  • BO Analysis for OLAP
  • BO Explorer
Data Provisioning or Data loading
  • BODS
  • Database Creation
  • Repository Creation
  • Project
  • Job
  • Job Schedule
  • Work Flow
  • Data Flow
  • ABAP Data Flow
  • Functions
  • Query Transform
  • Case Transform
  • Merge Transform
  • Validation Transform

SLT

  • SLT Integration with HANA
  • SLT integration with ECC
  • SLT configuration
  • DATA Loading
  • Replication of jobs through SLT.
  • Hana User Management &Security
  • Creating users
  • Creating Roles
  • Assign privileges to Users/ Roles
  • Template Roles
  • SQL statements for user management
  • Analytical privileges,Package Privileges,System
  • Privileges,SQL Privileges

BW 7.4 COURSE CONTENT

  • Understanding the concepts of reporting techniques in SAP BW training.
  • Introduction to Business Explorer
  • Understanding Bex Browser
  • Bex Query Designer
  • Bex Web Application Server
  • Advance Reporting/Web Reporting Techniques
  • Introduction to Reporting Agent (Pre calculation)
  • Overview of Reporting Authorization Objects and their Usage in Security
  • Performance Techniques for queries by using Aggregates
  • OLAP cache
  • Debugging queries using RSRT Tcode, Open HUB
Data Extraction
  • Extraction of data from R/3 system
  • Concept of Delta Queue, Introduction to different Delta Types in R/3
  • Debugging Extraction and Concept of Data Source in R/3
  • Extraction using Generic Extraction (Table/View/Info set/FM)
  • Extraction from FI (GL/AP), Extraction of COPA Data
  • Logistics Data Extraction (SD/MM)
  • Extraction Performance Tuning Techniques, BW Customization
  • At the end of the course you will get good expertise in below areas: Data modeling, Extraction techniques and creating data targets
  • BEx reporting
  • Data scheduling with Process chains
  • Performance tuning
Business Explorer
  • Understanding the concepts of reporting techniques in SAP BW training.
  • Introduction to Business Explorer
  • Understanding Bex Browser
  • Bex Query Designer
  • Bex Web Application Server
  • Advance Reporting/Web Reporting Techniques
  • Introduction to Reporting Agent (Pre calculation)
  • Overview of Reporting Authorization Objects and their Usage in Security
  • Performance Techniques for queries by using Aggregates
  • OLAP cache
  • Debugging queries using RSRT Tcode, Open HUB
Metadata Repository
  • Introduction to Multi providers
  • Info set and Master Data Reporting
  • Introduction to Process Chains for optimal data load scheduling
  • Overview and Introduction of Metadata Repository
  • Business Content usage and Object Version
  • Introduction to the concept of delta for data loading process
  • Transport Methodology
  • Performance tuning (Aggregates, Compression etc)
  • Real time scenarios

SAP BODS COURSE CONTENT

Introduction to Introduction

  • Introduction to SAP HANA
  • SAP In-Memory Strategy
  • HANA compare to BWA

Look and Feel

  • In-Memory Computing Studio
  • Administration view
  • Navigator View
  • System Monitor
Architecture
  • Architecture Overview
  • IMCE and Surroundings
  • Row Store
  • Column Store
  • Loading data into HANA
  • Data Modelling
  • Reporting
  • Persistent Layer
  • Backup & Recovery
BODS
  • Place of BODS among modern DI software package
  • Competitive advantage of BODS
  • ETL and ELT approach
  • How both approaches can be combined in one tool
  • Data Services components and architecture
Basics of BODS
  • Concepts of Job, Workflow and Data Flow
  • Concepts of Data store
  • Creating basic Batch Job
  • Transforms overview
Basic data profiling and Query Transform
  • Analysing data sources
  • Joining data from multiple sources
  • Basic transformations and build-in functions
  • Aggregating data in BODS
  • Look ups
Working with Files
  • Defining file formats for file data source
  • Working with XML files(XSD,DTD)
  • COBAL COPY BOOKS
  • File Formats as Source and as Targets
Platform Transforms Overview
  • Case and Merge transforms
  • SQL transform
  • Validation transform
  • Row Generation
  • Map Operation
  • Combining Validation and Auditing – best practices
Data Integrator Transforms
  • Working with hierarchical data
  • Hierarchy Flattening transform
  • Merging data
  • Table Comparison transform
  • Other ways of merging data for RDBMS data stores
  • Slowly changing dimension support in BODS
  • History preserving transform
 Using built-in functions

Use date and time functions and the date generation transform to build a dimension table

Use the lookup functions to look up status in a table

Use match pattern functions to compare input strings to patterns

Use database type functions to return information on data sources

Metadata Management
  • Local and Central repositories
  • Working in a group
  • Propagating Job from development to staging and production environment – best practices
  • Backing up metadata
  • ATL file. Export\Import operations
  • Validating, tracing, and debugging jobs
  • Use description and annotations
  • Validate and trace jobs
  • Use view data and the Interactive Debugger
Management Console
  • Administrating BODS
  • Overview of all major tools
  • Execution of a Job from server
  • Scheduling a job
  • Auto Documentation reports
  • Designing ETLs with auto documentation in mind
BODS Scripting Language
  • Variables in BODS – Scope of variable
  • Scripting language – Advantages and limitations
  • Custom functions in BODS
  • Creating simple function
  • Database procedures
  • Custom functions. database functions
SAP BW 7.3 AND SAP ECC,SAP CRM BODS INTEGRATION
  • Connecting to SAP Applications
  • ABAP data Flow processing using Data services
  • IDoc interface connectivity using Data services
  • SAP Application table source in real jobs using Data services
  • Executing Batch jobs that contain ABAP Data flows
  • Connecting to SAP Net weaver Business warehouse
  • Using Data services in SAP NW BW environments,Open hub tables
  • Defining SAP Net Weaver BW Data stores using Data services Loading into SAP NW BW using Data services.

Data Provisioning using BODS 4.2 workbench
1. Workbench user Interface

  • Data Flow editor
  • Monitoring editor
  • File Format editor
  • Replication job editor
  • Data store editor

2.Information Steward

  • Getting started with Cleansing Package Builder
  • About cleansing data
  • About cleansing packages
  • Cleansing package types
  • Create cleansing packages
  • Assign standard forms and variations
  • updating a published cleansing package
  • viewing published cleansing packages
  • Person and firm cleansing package
SAP HANA 1.0 SPS67 BODS INTEGRATION
  • BODS 4.0 With SAP HANA to built Agile Data marts using Different Transforms and File systems
  • Error Handling in BODS
  • Validating Data Flow, Workflow, Job
  • Error handling on Workflow label – Try and Catch objects
  • Analyzing execution of Batch Job – Log files
  • Debugging in BODS
  • Handing execution errors – best practices
Performance optimization in BODS – Part 1
  • Push-down concept
  • Cases when push-down doesn’t work
  • Data Transfer transform
  • Cashing in BODS
  • Defining cashing for look ups and Table Comparison
Performance optimization in BODS – Part 2
  • Degree of parallelism
  • Designing custom function for parallel execution
  • Bulk loading operation
  • using Multi Load for Tera data targets
  • Execution parameters
  • Rows per commit
  • Number of loaders
Using BODS Metadata
  • Access to BODS metadata
  • Operational metadata
  • Auditing metadata
  • Creating your own metadata by using BODS metadata
Possible Alternative Topics
  • Data Quality in BODS
  • SAP and SAP BODS
  • Real-time jobs
  • Integration with other applications
  • Automatic job creation from template

https://www.govideotutorials.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Reviews (0)

Reviews

There are no reviews yet.

Be the first to review “HANA2.0, BW 7.4, BODS”
Contact Us