Software Development on the Sap Hana Platform

Software Development on the Sap Hana Platform - Opis

Spis treści:
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 (...) więcej 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. Lets 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 O autorze: Mark Walker has been working with computers since a very early age, starting out with programming the Sinclair ZX Spectrum. After graduating from Cardiff University, he moved to France, starting a 17-year (so far) career in SAP development, first on the SAP ERP, then moving to SAP BW in 2004. He specializes in process optimization, especially in the SAP BPS and BI-IP modules. He's been following SAP HANA since its release in 2011, and is a certified HANA Application Associate since early 2012. Mark has been working for the last six years for Censio, a consultancy in Paris, France, which has expertise in SAP, Microstrategy, Business Objects, and Microsoft BI technologies. During that time he's worked on several end-to-end projects for some prestigious clients, and done some missions in SAP's name. In November 2012, he published SAP HANA Starter, Packt Publishing, a small book about getting a foothold in the SAP HANA world. mniej