ROADMAP OF HANA
MODELIN
8082060006, 8104836993, 7039904327, 9892178457
Call Us
ERP
smart Automation
ERP
ISO 9001:2015 Certied
Introduction
History and Fundamentals of Data-warehousing in Depth.
Star Schema And Extended Star Schema Techniques.
Clear picture on OLTP and OLAP systems.
Introduction to SAP HANA
SAP In-Memory Strategy
HANA compare to BW
Architecture
Architecture Overview
IMCE and Surroundings (In memory Computing Engine)
Row Store & Column Store
Installation and deployment scenarios
Navigation
Introduction to HANA Studio
HANA Administration Prospective
Modeler Prospective
System monitoring.
LT (Landscape Transformation) OR Trigger Based Replication
Remote Function Calls
Creating RFC Destinations in SAP ABAP
Replicating SAP tables from OLTP Server using Trigger
based Replication
Real time Replication
Job Scheduling and monitoring.
Parallel and Multi-Thread processing.
SQL Scripts
Data Types
Table Creation, Modication, Updating and Deletion operations.
SQL Select Statements
Joins and Unions
String Operations
Stored procedures
CE (Calculation Engine) Functions.
Aggregations and lot more.
Modelling
Applying star schema technique in SAP HANA
Attribute Views
Calculated Columns
Hierarchies
Time Data Generation
Analytic Views
Variables & Input Parameters
Calculated & Restricted Columns
Currency & Quantity Conversions
Calculation Views
Star Joins, Cubes & Dimensions
SQL Script based Views
Calculation Engine Functions Depth.
HANA -ETL Replication Methodology
BODS (Business Object Data services)
HANA As a Central Repository
JDBC & ODBC connectivity.
Replicating data from SAP OLTP Server Using BODS
Replicating data from Flat File Source systems
Replicating data from BI System
Backward replication technique.
Bulk Load & Scheduling
Extracting ECC data using BW Extractors
Scheduling Stored Procedures
Fe
25000/-
Transformations using BODS
Merge Transform
Pivot & Reverse Pivot Transformations
SQL Transformation
Key Generation Transform
Validation Transform
Case Transform
Business Objects CMC & Information Design Tool
Creating Repository
Relational Database & OLAP Connections
Working with Universes
Creation of Project & Data Foundation to Build
the Universe
Creating Data Services Repository User
Xcelsius / SAP BO Dashboards
Consuming BEx Query
Consuming an Universe to Design a Dashboard
Working With TABs
Working with Workbook
Visualizing the data in Charts
Using Selectors
SAP HANA Reporting Using MS Excel
SAP HANA MDX Provider
Creating ODBC Connection
Reporting Fundamentals
Using Filters and Hierarchies
Graphical Reporting
Advanced Reporting Techniques.
Reporting Using Business Object Explorer 4.0
Creating HANA Source Systems
Managing Info-Spaces
Geographical Reporting
Time based reporting
Hierarchical Reporting
Conguring & Indexing the Views
Creating Exploration Viewset
Creating URLs for Web-based Reporting
Reporting with BOEx in Depth
Crystal Reports with SAP HANA
Creating Relational Database Connection
Reporting on HANA tables
Reporting on HANA Views
Reporting on Stored Procedures
SAP Lumira
Getting started With Lumira
Data Acquisition from SAP HANA and other Sources
Preparing the datasets.
Lumira on Cloud
Data Visualization
Designing Dashboards & Stories
Sharing the Stories on Cloud
