Software Development on the SAP HANA Platform

Description

Software Development on the SAP HANA Platform is a general tutorial guide to SAP HANA. This book is written for beginners to the SAP HANA platform. No knowledge of SAP HANA is necessary to start using this book. Abstract: Software Development on the SAP HANA Platform is a general tutorial guide to SAP HANA. This book is written for beginners to the SAP HANA platform. No knowledge of SAP HANA is necessary to start using this book Content: 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.