SAP BW 7.5 on HANA

 15,000.00

Description

 

HANA Topics

Motivation for SAP-HANA

  • Enterprise Data Characteristics
  • Big Data
  • Hardware Innovations
  • Software Innovations
  • Limitations of Traditional  Databases
  • need of Converging OLTP and OLAP
  • Text Analysis
  • Data Mining and Predictive Analytics

Introduction to SAP-HANA   

  • Column Store
  • Dictionary Encoding
  • Compression Techniques
  • Partition ing Methods
  • Delta Merge

 

BW Topics

BW

  • Field Based Modeling
  • Open ODS View
  • Advanced DSO
  • HANA optimized  Info Cubes
  • Analytic Indexes, Transient Providers
  • Virtual Providers
  • Virtual Master Data Info Objects
  • Composite Providers
  • HANA Expert Script Routine
  • HANA Analysis Process (HAP)

 

ABAP

  • New ABAP( 5)
  • ABAP CDS Views
  • ABAP Managed Data base Procedures (AMDPs)
  • ABAP Managed Database Functions (Table Functions)

 

HANA Native Topics

HANA Modeling

  • Modeling Objects
  • Attribute Views
  • M_TIME_DIMENSION
  • Analytic Views
  • Calculation Views-Graphical
  • Calculation Views-Scripting
  • Column Views
  • Hierarchies
  • Filters, Formulas and Parameters
  • Restricted & Calculated Measures
  • Currency Calculations- Graphical
  • Analytic Privileges
  • Decision Tables

 

       HANA SQL

  • Catalog Objects
  • Creating Tables with several options
  • Column Tables and Row Tables
  • CRUD operations
  • Primary Keys and Foreign Keys
  • ALTER and DROP commands
  • Sub Queries
  • Library Functions
  • Summary/Aggregate    Functions
  • SET operators
  • Views, Visual SQL
  • Indexes
  • Sequences
  • Synonyms, Various System Views

 

HANA SQL Script

  • Functional vs Imperative Processing
  • Table Types
  • Stored Functions
  • Stored Procedures – SQL Script
  • Stored Procedures – R language
  • Column Views
  • Dynamic SQL
  • Arrays
  • Exception Handling
  • Triggers
  • All 14 CE Functions

 

Data Provisioning & Reporting

Data Provisioning to HANA

  • with Sub Queries
  • with Flat Files – Local Client
  • Data Replication Methods
  1. BODS or ETL Replication
  2. ODP
  3. SLT with ABAP Transformations
  4. DXC
  • Import and Export – Delivery Units

 

Reporting Tool

  • SAP- Lumira
  • SAP- Design Studio
  • SAP- BOBI ( optional)

 

Reviews

There are no reviews yet.

Be the first to review “SAP BW 7.5 on HANA”