Back

HANA/BW ON HANA

$ 27.97 $ 13.98

SAP HANA (high-performance analytic appliance) is an application that uses in-memory database technology that allows the processing of massive amounts of real-time data in a short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk.

Category:
Description

Description

HANA TOPICS LIST

1.what is SAP HANA

2.why is SAP HANA to Fast …?

3.SAP Hana Architecture

3.1 Understanding about Index server and engines

4.Discussion on SAP HANA UseCases

5.Introducing SAP HANA studio

6.SAP Hana Database concepts

6.1 Schema

6.2 Database Tables_Row Store and Column store

6.3 Database Views

6.4 Synonyms

6.5 Triggers

6.6  Sequences

6.7  Table_UDF(User Defined Functions)

6.8 Stored Procedures

6.9 Table Types

6.10 Column Views

7.Basis SQL

8.Stored Procedures

8.1 Simple stored procedures

8.2 Looping Statements

8.3 Conditional Statements

8.4 Using Arrays

8.5 Using cursor

8.6  Using Temp and Table Types

8.7 Stored Procedures with Column views

8.8 using SQL functions

8.9 Using CE Functions

8.10 Debugging Stored procedures

9.SAP HANA MODELING

9.1  Introduction to the modeling

9.2  Understanding Different types of JOINS IN SAP HANA
9.2.1    INNER, LEFT OUTER ,RIGHT OUTER, Referential,TEXT, Temporal , Spatial

9.3  Attribute View

9.3.1 Standard Attribute view

9.3.2 Time based attribute view

9.3.3 Derived  Attribute view

9.3.4  Creating calculating column

9.3.5 Creating Hierarchies in Attribute views

9.3.6 Dynamic filter_ Using input parameters

9.3.7 Enabling Attribute view for time travel queries by using history tables

10    ANALYTICAL VIEW

10.1  Understanding STAR join Node

10.2  creating calculated columns and measures

10.3  Restricted columns

10.4 counters

10.5  Input parameters

10.6  Variables

10.7 Semantics

10.8 Analytical view properties

10.9 Focusing on Tempral join in Analytical view

10.10  Mapping of Input parameters

11 CALUCTION VIEW

11.1 Understing Calucation view properties _ Data category(STAR JOIN)

11.2  SQL Scripted Based & Graphical Mode

11.3 Understanding different nodes in Calculation view

11.4  Projection

11.5. Aggregation

11.6 JOINS

11.7 UNION

11. 8 RANK
11.9 Understanding Dynamic join

11.10 Understanding KEEP FLAG Property

11.11 Understanding Transparent filter property

11.12  understanding STAR JOIN NODE

11.13 Creating calculated columns and measures

11.14 Restricted columns   (Dynamic with input parameters

11.15 Counters

11.16 input parameters

11.17  Variables

11.18  semantics

11.19 Extract Semantics

11.20 Creating Hierarchies in Calculation view

11.21 Processing of HANA models

12.ANALYTICAL PREVILEGES

12.1  static

12.2 Dynamic stored procedures

13 . DECISION TABLES

13.1 Updating

13.2  What if Analysis

14.REPORTING ON SAP HANA

14.1  SAP Lumira (In detail and publishing sap lumira story boards and data sets into sap lumira server embedded on to HANA Server

14.2  Design studio( In Detail and publishing application on to SAP HANA access engine )

14.3  IDT and WEBI  ( Just on over view)

15    DATA PROVISIONING

15.1 Using BODS
15.2 Using SLT

15.3 using DXC

15.4 Flat file imports

15.5 bulk loading of flat file imports

15.6  Smart Data Access

15.7  smart data integration

16 IMPORTING AND  EXPORTING OF SAP HANA OBJECTS

17   BW4HANA

17.1 hana optimized info cube

17.2 hana optimized DSO
17.3 Transient Provider

17.4 consuming hana models in SAP BW

17.5 importing BW objects into SAP HANA

17.6 Operational Data Provisioning  using sources – ECC , SLT, HANA VIEWS

17.7  LSA ++

17.8 Advanced DSO
17.9 Open ODS
17.10 Composite Provider

17.11 Hana transformation

17.12 ABAP managed Database procedure

17.13 SAP hana  near line storage

17.14 BW workspaces

17.15 Semantic partitioned objects

18 S4HANA
18. 1 embedded analytics using Abap CDS views

18.2 HANA live (VDM)

18.3 ABAP CDS views

18.4 Exposing ABAP CDS views as ODATA Services

https://www.selflearningvideos.com

 

 

 

Contact Us