Book Image

Software Development on the SAP HANA Platform

By : Mark Walker
Book Image

Software Development on the SAP HANA Platform

By: Mark Walker

Overview of this book

Table of Contents (19 chapters)
Software Development on the SAP HANA Platform
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
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...