Software Development on the SAP HANA Platform电子书

Software Development on the SAP HANA Platform

Table of Contents

Software Development on the SAP HANA Platform

Credits

About the Author

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

Downloading the example code

Errata

Piracy

Questions

1. So, What Is This SAP HANA Thing Anyways?

Time for action – statistics about internal commercial flights in the USA from 1998 to 2011

What just happened?

Understanding the performance of SAP HANA

Massively parallel execution

Column-oriented table storage

Data compression

In-memory technology

SAP HANA as an appliance

Summary

2. SAP HANA Studio – Installation and First Look

Getting access to SAP HANA

Purchasing a SAP HANA license and appliance

Accessing SAP HANA in the cloud

Getting a free 30-day trial of a SAP HANA instance from SAP

Running the installation

Welcome to the SAP HANA Studio

The Modeler perspective

Connecting to the SAP HANA server

Importing sample data

SAP HANA object export

Importing exported data into SAP HANA

Previewing the sample data

Summary

3. Your First SAP HANA Development – An Attribute View

Creating a delivery unit

Creating a package

Creating an attribute view

Advanced features of attribute views

The client field

Joining tables in views

Join types in SAP HANA

Join cardinality

Completing an attribute view with information from different tables

Summary

Quick reference

4. Painting with Numbers – An Analytic View

Creating an analytic view

Adding a Table to an Analytic View

Attributes and Measures – what a difference an icon can make!

Adding an attribute view to an analytic view

Advanced features of analytic views

Restricted columns – what they are and how to use them

Calculated Columns

Calculated attribute – DATA_TYPE

Calculated measure – VAT_RATE

Calculated measure – VAT_AMOUNT

Accepting user input

Creating a view by copy

Filtering view contents

Creating a variable

Creating an input parameter

Creating a new calculated column

Modifying existing calculated columns

Summary

Quick reference

5. Let's Get Graphical – Graphical Calculation Views

What is a graphical calculation view?

Creating a graphical calculation view

Adding analytic views

The projection block

The aggregation block

The join block

The union block

Output

Results

Summary

Quick reference

6. You Talking to Me? – Scripted Calculation Views

Creating a scripted calculation view

Understanding CE functions

Adding analytic views

The projection block

The aggregation block

The join block

The union block

Defining the view's output

Results

Summary

Quick reference

7. Hey! That's My Data! – Authorizations in SAP HANA

Roles

Creating a role

Granted roles

Part of roles

SQL privileges

Analytic privileges

System privileges

Package privileges

Users

Testing our user and role

Summary

Quick reference

8. On Another Level – Hierarchies in SAP HANA

Hierarchy types in SAP HANA

Parent-child hierarchies

Level hierarchies

Creating a hierarchy in SAP HANA

Viewing data according to a hierarchy

Summary

Quick reference

9. Deploying Your Reporting Application to Reporting Software

Getting software to talk to SAP HANA

SAP Lumira

Downloading and installing

Connecting to SAP HANA

Analyzing data with Lumira

Visualization options and formatting concerns

Microsoft Excel®

Installing the SAP HANA client for Excel

Connecting to SAP HANA using Excel

Tableau software

Installing the SAP HANA client driver

Creating an ODBC DSN in Windows

Connecting to SAP HANA using Tableau

Summary

Quick tool comparison

10. Data Provisioning Using Data Services

About the sample data

Understanding the BODS main screen

Creating a Data Services project

Creating a project

Creating a BODS job

Creating an ODBC connection to SAP HANA from within BODS

Defining a file format

Creating a data flow

Adding a source object

Adding a target object

Adding a data flow to a job

Running a BODS job

Summary

Quick reference

11. Application Development Using the XS Engine

Checking the XS Engine

Understanding XS Engine applications

Creating an application using XS Engine

Creating a delivery unit

Creating a package

Creating a project

Sharing your project on the SAP HANA Server

Creating a repository workspace

Checking the status of your project files

Understanding application descriptor files

Creating the application descriptor file

Creating the application access descriptor

Configuration options in the .xsaccess file

Hello, World!

Calling up our XS Engine application in a browser

XS Engine database access

Copying an XS Engine application

Enforcing login in an XS Engine application

Accessing the database

Developing user interfaces using SAPUI5

Adding an image resource to an XS Engine project

Creating a user interface in SAPUI5

Prototyping the interface in static JavaScript

Transforming the static JavaScript into dynamically generated code

Integrating the user interface and the database access routines

Passing information from one source file to another

Summary

Quick reference

A. So Long and Thanks – Where To Go from Here

What we've covered

Now it's your turn

Index