Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 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; Chapter 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 cloudGetting 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; Chapter 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 tablesSummary; Quick reference; Chapter 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 variableCreating an input parameter; Creating a new calculated column; Modifying existing calculated columns; Summary; Quick Reference; Chapter 5: Let's Get Graphical -- Graphical Calculation Views; What is a graphical calculation view?; Creating a graphical calculation view; Adding analytic views; Projection block; Aggregation block; Join block; Union block; Output; Results; Summary; Quick reference; Chapter 6: You Talking to Me? Scripted Calculation Views; Creating a scripted calculation view; Understanding CE functions; Adding analytic views; Projection block.

The aggregation blockThe join block; The union block; Defining the view's output; Results; Summary; Quick reference; Chapter 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; Chapter 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.