SAP HANA Cookbook
eBook - ePub

SAP HANA Cookbook

  1. 284 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub
Book details
Book preview
Table of contents
Citations

About This Book

In Detail

SAP HANA is a real-time applications platform that provides a multi-purpose, in-memory appliance. Decision makers in the organization can gain instant insight into business operations. Thus all the data available can be analysed and you can react to the changing business conditions rapidly to make decisions. The real-time platform not only empowers business users and top management to make decisions but also provides the capability to make decisions in real-time.

A practical and comprehensive guide that helps you understand the power of SAP HANAs real-time and in-memory capabilities. It also provides step-by-step instructions to exploit all the possible features of the SAP HANA database, enabling users to harness the full potential of this technology and its features.

You will gain an understanding of real-time replications, effective data loading from various sources, how to load data, and how to create re-usable objects such as models and reports.

Use this practical guide to enable or transform your business landscape by implementing SAP HANA to meet your business requirements. The book shows you how to load data from different types of systems, create models in SAP HANA, and consume data for decision-making. The book covers various tools at different stages creating models using SAP HANA Studio, and consuming data using reporting tools such as SAP BusinessObjects, SAP Lumira, and so on . This book also explains the in-depth architecture of SAP HANA to help you understand SAP HANA as an appliance, that is, a combination of hardware and software.

The book covers the best practices to leverage SAP HANAs in-memory technology to transform data into insightful information. It also covers technology landscaping, solution architecture, connectivity, data loading, and setting up the environment for modeling purpose (including setup of SAP HANA Studio).

If you have an intention to start your career as SAP HANA Modeler, this book is the perfect start.

Approach

An easy-to-understand guide, covering topics using practical scenarios and live examples, and answering all possible questions.

Who this book is for

If you are a solution architect, developer, modeler, sales leader, business transformation managers, directors, COO, or CIO; this book is perfect for you.

If you are interested in other technologies and want to jump-start into SAP, this book gives you the chance to learn SAP HANA. Basic knowledge of RDBMS concepts enough is to get you started.

Frequently asked questions

Simply head over to the account section in settings and click on ā€œCancel Subscriptionā€ - itā€™s as simple as that. After you cancel, your membership will stay active for the remainder of the time youā€™ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlegoā€™s features. The only differences are the price and subscription period: With the annual plan youā€™ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weā€™ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access SAP HANA Cookbook by Chandrasekhar Mankala, Ganesh Mahadevan V. in PDF and/or ePUB format, as well as other popular books in Business & Business Intelligence. We have over one million books available in our catalogue for you to explore.

Information

Year
2013
ISBN
9781782177623
Edition
1

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 Intelligenc...

Table of contents

  1. SAP HANA Cookbook