SAP HANA

SAP HANA Studio

Modeler

Administration view

Navigator

System Monitor

Architecture of SAP HANA

HANA architecture

HANA Chipset

HANA Modeling Architecture

HANA Engine Architecture

HANA Reporting Architecture

Column Store

Row store

SAP HANA Modeling

Creating Attribute Views

  • Master data
  • Text Data
  • Hierarchies

Creating Analytical views

  • Restricted measures , calculated Measures
  • Referential joins,
    • Text Joins,
    • Inner Join,
    • left Outer join,
    • Right Outer join and Cardinalities
  • Star schema
  • Extended star schema
  • Integrated star schema

Calculation Views

  • Using Joins
  • Using Unions
  • Using Projection Views
  • Using SQL Code
  • CE Functions

Performance optimization techniques in HANA

Import Models

Export Models

SQL Script

Procedures

Triggers

ETL Tools in HANA

HANA import option

SLT( SAP Landscape transformation)

BODS(Business Objects Data Services)

SDA(Smart Data Access)

BW7.4 Powered by HANA

BODS

Project

Jobs

Data Flow

Data connections

Importing source metadata

Importing source Files

Oracle to HANA load

SQL Server to HANA Load

ECC to HANA Load

BW to HANA Load

Data Cleansing

Data scrubbing

Data Merging

Data Aggregations

Type1 data loading into HANA

Type2 data loading into HANA
Fact data loading into HANA

BW Powered by HANA

HANA optimized info cube

HANA optimized DSO

Performance in BW using HANA

Open ODS Views

Advanced DSO

Hybrid Provider

ABAP on HANA

Accessing Attribute Views into ABAP Editor

Accessing Analytical Views into ABAP Editor

Accessing Calculation Views into ABAP Editor

Calling HANA Procedures from ABAP

Core Data Service Views in ABAP

User Management and security

Creating users

Creating Roles

Assigning privileges to roles / users

Template Roles

SQL statements for user management

Analytical Privileges, Package Privileges, System Privileges, SQL Privileges.

Reporting

BO Universe Designer Tool

BO IDT

WEBI reports

Dashboards (Xcelsius)

Lumira (Predictive Analysis

BO Designer studio

© 2016 Copyright. All rights reserved.

Click Me