Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Software Development on the SAP HANA Platform
  • Toc
  • feedback
Software Development on the SAP HANA Platform

Software Development on the SAP HANA Platform

By : Mark Walker
3.3 (3)
close
Software Development on the SAP HANA Platform

Software Development on the SAP HANA Platform

3.3 (3)
By: Mark Walker

Overview of this book

Table of Contents (19 chapters)
close
close
Software Development on the SAP HANA Platform
Software Development on the SAP HANA Platform
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
So, What Is This SAP HANA Thing Anyways?
So, What Is This SAP HANA Thing Anyways?
Time for action – statistics about internal commercial flights in the USA from 1998 to 2011
Understanding the performance of SAP HANA
Summary
2
SAP HANA Studio – Installation and First Look
SAP HANA Studio – Installation and First Look
Getting access to SAP HANA
Running the installation
Welcome to the SAP HANA Studio
Connecting to the SAP HANA server
Importing sample data
Previewing the sample data
Summary
3
Your First SAP HANA Development – An Attribute View
Your First SAP HANA Development – An Attribute View
Creating a delivery unit
Creating a package
Creating an attribute view
Advanced features of attribute views
Summary
Quick reference
4
Painting with Numbers – An Analytic View
Painting with Numbers – An Analytic View
Creating an analytic view
Adding an attribute view to an analytic view
Advanced features of analytic views
Summary
Quick reference
5
Let's Get Graphical – Graphical Calculation Views
Let's Get Graphical – Graphical Calculation Views
What is a graphical calculation view?
Creating a graphical calculation view
Summary
Quick reference
6
You Talking to Me? – Scripted Calculation Views
chevron up
You Talking to Me? – Scripted Calculation Views
Creating a scripted calculation view
Summary
Quick reference
7
Hey! That's My Data! – Authorizations in SAP HANA
Hey! That's My Data! – Authorizations in SAP HANA
Roles
Analytic privileges
System privileges
Package privileges
Users
Testing our user and role
Summary
Quick reference
8
On Another Level – Hierarchies in SAP HANA
On Another Level – Hierarchies in SAP HANA
Hierarchy types in SAP HANA
Creating a hierarchy in SAP HANA
Viewing data according to a hierarchy
Summary
Quick reference
9
Deploying Your Reporting Application to Reporting Software
Deploying Your Reporting Application to Reporting Software
Getting software to talk to SAP HANA
SAP Lumira
Microsoft Excel®
Tableau software
Summary
Quick tool comparison
10
Data Provisioning Using Data Services
Data Provisioning Using Data Services
About the sample data
Understanding the BODS main screen
Creating a Data Services project
Summary
Quick reference
11
Application Development Using the XS Engine
Application Development Using the XS Engine
Checking the XS Engine
Understanding XS Engine applications
Creating an application using XS Engine
Hello, World!
XS Engine database access
Developing user interfaces using SAPUI5
Summary
Quick reference
So Long and Thanks – Where To Go from Here
So Long and Thanks – Where To Go from Here
What we've covered
Now it's your turn
Index
Index

Quick reference

Here is a quick overview of the main topics covered in this chapter.

Object

Usage

Creation

Scripted calculation view

Like a graphical calculation view, this allows development of complex data models, combining data from several sources, and presenting the data in one coherent place.

Quick Launch | Calculation view | Create. Give Name and Description values, select SQLScript. Write the appropriate script, define the output parameter, and activate.

CE functions

These allow us to interact with the database, and the data we have read from it, without writing SQL.

  • CE_OLAP_VIEW: This reads an analytic view

  • CE_COLUMN_TABLE: This reads a database table (column table only)

  • CE_PROJECTION: This creates a projection on data read into a scalar variable

  • CE_CALC: This creates a calculated column in a projection

  • CE_JOIN, CE_LEFT_OUTER_JOIN, and CE_RIGHT_OUTER_JOIN: This joins two scalar variables together

  • CE_UNION_ALL: This creates a union of two scalar variables (which have the...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Chapter 6
Next Chapter
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete