Software Development on the SAP HANA Platform. (2013)

• Record Type: Book
• Other Names: Walker, Mark
• Contents: 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.
• Publisher Details: Place of publication not identified : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 005.7565; COMPUTERS -- Enterprise Applications -- Business Intelligence Tools; Database management; Business enterprises -- Data processing; Database management; Business enterprises -- Data processing; SAP (Programes d'ordinador); Bases de dades -- Gestió; Empreses -- Informàtica; COMPUTERS -- General; Business enterprises -- Data processing; Database management; Database management; Business enterprises / Data processing; Llibres electrònics
• Languages: English
• ISBNs: 1299735096; 9781299735095; 9781849689410; 1849689415; 1849689407; 9781849689403
• Related ISBNs: 9781849689403
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.