SAP HANA Cookbook电子书

SAP HANA Cookbook

Table of Contents

SAP HANA Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. SAP HANA Studio – Look and Feel

Introduction

Understanding SAP HANA Studio

How it works…

There's more…

Platforms supported

System requirements

Installation paths

See also

Switching between different views – perspectives

Getting ready

How it works…

How to do it…

There's more…

See also

Navigating SAP HANA Studio – the Navigator Pane

Getting ready

How it works…

System Monitor

Administration

SQL Console

Find Table

Find System

Link with Editor

There's more…

See also

Administering SAP HANA – the Administration Console perspective

Getting ready

How to do it…

Adding a system

There's more…

Overview

Landscape

Services

Configuration

Redistribution Operations

Alerts

Performance

Volumes

Configuration

System Information

Diagnosis Files

Trace Configuration

See also

Modeling SAP HANA Studio – the Modeler perspective

Getting ready

How it works…

There's more…

Information views

SQLScript

See also

2. Data Provisioning

Introduction

Loading data into SAP HANA – data provisioning methods

Getting ready

How to do it…

How it works…

SAP Landscape Transformation

SAP Data Services

Sybase replication

There's more…

Strategic considerations

Technical considerations

See also

Uploading data from flat files

Getting ready

How to do it…

Step 1 – creating a table in the SAP HANA system

Step 2 – selecting the source file and target table in SAP HANA

Step 3 – field mapping and loading data

How it works…

There's more…

See also

Using SLT to load data into SAP HANA

Getting ready

How to do it…

SLT configuration – creating a connection

How it works…

Logging tables

Read module

Control module

Write module

There's more…

See also

Using SAP Data Services as an ETL tool to load data into SAP HANA

Getting ready

How to do it…

Creating table in SAP HANA using the import of metadata option

Step 1 – Creating a datastore for the source system in SAP Data Services

Step 2 – Importing tables in SAP DS for the datastore created

Step 3 – Configuring Import Server from the Quick Launch screen of SAP HANA Studio

Step 4 – Importing metadata from SAP HANA Studio

Creating a datastore for a target system – SAP HANA in SAP Data Services

Creating a project

Creating a job

Creating a workflow

Creating a data flow

Designing the data flow

Validating the data flow and saving the project

Executing the job

How it works…

There's more…

See also

Loading data into SAP HANA using DXC

Getting ready

How to do it…

Configuring DXC

Loading data to SAP HANA

How it works…

An SAP source system on SAP NetWeaver Version 7.0 or higher, using the embedded SAP NetWeaver BW system

An SAP source system on a version below SAP NetWeaver 7.0, using a side-by-side SAP NetWeaver BW system

There's more…

The Sidecar approach

See also

Loading data using SAP Sybase Replication Server

Getting ready

How to do it…

Oracle to SAP HANA Replication setup

Prerequisites

Configuring Replication Server to SAP HANA

Creating a Replication Server connection to the primary database

Testing the replication

How it works…

There's more…

See also

3. Modeling

Introduction

Approaching SAP HANA modeling

Getting ready

How to do it…

How it works…

See also

Creating attribute views

Getting ready

How to do it…

Creating a package

Creating an attribute view

How it works…

There's more…

See also

Creating analytic views

Getting ready

How to do it…

How it works…

There's more…

See also

Creating calculation views

Getting ready

How to do it…

Creation of a calculation view using GUI

Creation of a calculation view using SQLScript (native SQL or CE functions)

How it works…

See also

Preparing documents – Auto Documentation

How to do it…

Model Details

Model List

How it works…

Modeling with Information Composer

Getting ready

How to do it…

Uploading data

Selecting a data source and loading data into Information Composer

Data cleansing

Merging values

Changing values

Classification of data columns into attributes and measures

Saving data into SAP HANA

Composing information views

Selecting data sources – Source A and Source B

Combining data

Refining the data

Saving the view to SAP HANA and publishing

How it works…

There's more…

My Data

My Information Views

See also

4. Reporting

Introduction

The reporting layer on top of SAP HANA

How to do it…

How it works…

There's more…

See also

Connecting reporting tools to SAP HANA

Getting ready

How to do it…

How it works…

There's more…

See also

Creating reports using SAP BusinessObjects Web Intelligence

Getting ready

How to do it…

How it works…

There's more…

See also

Creating reports using SAP BusinessObjects Explorer

Getting ready

How to do it…

How it works…

There's more…

See also

Creating reports using SAP BusinessObjects Dashboards/Xcelsius

Getting ready

How to do it…

How it works…

See also

Creating reports using SAP BusinessObjects Analysis for OLAP

How to do it…

How it works…

There's more…

See also

Creating reports using Microsoft Excel

Getting ready

How to do it…

How it works…

There's more…

See also

Creating reports in SAP Lumira

Getting ready

How to do it…

How it works…

There's more…

See also

5. Advanced Features in SAP HANA

Introduction

Converting different currencies

How to do it…

How it works…

See also

Creating hierarchies

How to do it…

Level hierarchy

The parent-child hierarchy

How it works…

See also

Creating variables

Getting ready

How to do it…

How it works…

See also

Creating input parameters

Getting ready

How to do it…

How it works…

See also

Creating filters

How to do it…

How it works…

There's more…

Creating procedures using SQLScript

Getting ready

How to do it…

How it works…

See also

Creating decision tables

Getting ready

How to do it…

How it works…

There's more…

See also

6. User Management

Introduction

Creating users

Getting ready

How to do it…

How it works…

There's more…

See also

Creating roles

Getting ready

How to do it…

How it works…

There's more…

See also

Assigning roles to users

Getting ready

How to do it…

How it works…

There's more…

See also

Restricting access to data – creating analytic privileges

Getting ready

How to do it…

How it works…

See also

Securing logging in to SAP HANA – authentication methods

How to do it…

How it works…

See also

Securing logging in to SAP HANA – privileges

Getting ready

How to do it…

How it works…

A. Introduction to SAP HANA

Introduction

Explaining traditional databases and bottlenecks

How it works…

Traditional databases

There's more…

Bottlenecks

Latency

Cost

Architecture

See also

Introducing technology and hardware innovations

How it works…

Depth of data

Broadness

Real time

Simplicity

Retrieval speed

There's more…

Multicore CPUs

Parallel processing

Data compression

See also

Looking into versions and technical requirements

How it works…

Enterprise HANA

Technical requirements

SAP NetWeaver BW powered by SAP HANA

Technical requirements

There's more…

Server

RAM

Log storage

Data storage

See also

Describing why you should use SAP HANA

Getting ready

How it works…

Traditional versus in-memory

There's more…

See also

Looking into SAP HANA features

Getting ready

How to do it…

Alignment of business and IT

More efficient data processing

Business analytic applications powered by technology

Powerful analytic appliance – real-time insight

How it works…

A multi-engine query processing environment

Representation of application-specific business objects

Development of current hardware innovations

Direct access to ERP

Direct access to other (non-SAP) systems

There's more…

Leveraging BI capabilities

Comparing BWA and SAP HANA

Evolution of SAP BWA and SAP HANA

How it works…

Comparison

See also

B. Architecture

Understanding the SAP HANA architecture

Explaining IMCE and its components

Further reading

Session management

Transaction manager

Metadata manager

Persistence layer

Authorization manager

Storing data – row storage

Storing data – column storage

The delta merge process

Consistent view manager and transaction manager

Understanding the persistence layer

Further reading

Understanding backup and recovery

Further reading

C. Applications Powered by SAP HANA

Introduction

Introducing flavors on top of SAP HANA

How it works…

See also

Introducing SAP NetWeaver BW powered by SAP HANA

Getting ready

How to do it…

How it works…

See also

Introducing SAP Business Suite on SAP HANA

How it works…

See also

Index