E-book details

Software Development on the SAP HANA Platform. Written by a SAP HANA expert, this book takes you from installation to running your own processes in no time. By the end of the course you’ll have awesome data retrieval and analytical powers to call on

Software Development on the SAP HANA Platform. Written by a SAP HANA expert, this book takes you from installation to running your own processes in no time. By the end of the course you’ll have awesome data retrieval and analytical powers to call on

Mark Walker

Ebook
  • Software Development on the SAP HANA Platform
    • Table of Contents
    • Software Development on the SAP HANA Platform
    • Credits
    • About the Author
    • About the Reviewers
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
        • Why Subscribe?
        • Free Access for Packt account holders
        • Instant Updates on New Packt Books
    • Preface
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the example code
        • Errata
        • Piracy
        • Questions
    • 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
    • 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 cloud
        • Getting 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
    • 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 tables
      • Summary
      • Quick reference
    • 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 variable
          • Creating an input parameter
          • Creating a new calculated column
          • Modifying existing calculated columns
      • Summary
      • Quick reference
    • 5. Lets Get Graphical Graphical Calculation Views
      • What is a graphical calculation view?
      • Creating a graphical calculation view
        • Adding analytic views
        • The projection block
        • The aggregation block
        • The join block
        • The union block
        • Output
        • Results
      • Summary
      • Quick reference
    • 6. You Talking to Me? Scripted Calculation Views
      • Creating a scripted calculation view
        • Understanding CE functions
        • Adding analytic views
        • The projection block
        • The aggregation block
        • The join block
        • The union block
        • Defining the view's output
        • Results
      • Summary
      • Quick reference
    • 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
    • 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
    • 9. Deploying Your Reporting Application to Reporting Software
      • Getting software to talk to SAP HANA
      • SAP Lumira
        • Downloading and installing
        • Connecting to SAP HANA
        • Analyzing data with Lumira
        • Visualization options and formatting concerns
      • Microsoft Excel
        • Installing the SAP HANA client for Excel
        • Connecting to SAP HANA using Excel
      • Tableau software
        • Installing the SAP HANA client driver
        • Creating an ODBC DSN in Windows
        • Connecting to SAP HANA using Tableau
      • Summary
      • Quick tool comparison
    • 10. Data Provisioning Using Data Services
      • About the sample data
      • Understanding the BODS main screen
      • Creating a Data Services project
        • Creating a project
        • Creating a BODS job
        • Creating an ODBC connection to SAP HANA from within BODS
        • Defining a file format
        • Creating a data flow
          • Adding a source object
          • Adding a target object
        • Adding a data flow to a job
        • Running a BODS job
      • Summary
      • Quick reference
    • 11. Application Development Using the XS Engine
      • Checking the XS Engine
      • Understanding XS Engine applications
      • Creating an application using XS Engine
        • Creating a delivery unit
        • Creating a package
        • Creating a project
        • Sharing your project on the SAP HANA Server
        • Creating a repository workspace
        • Checking the status of your project files
        • Understanding application descriptor files
          • Creating the application descriptor file
          • Creating the application access descriptor
            • Configuration options in the .xsaccess file
      • Hello, World!
        • Calling up our XS Engine application in a browser
      • XS Engine database access
        • Copying an XS Engine application
        • Enforcing login in an XS Engine application
        • Accessing the database
      • Developing user interfaces using SAPUI5
        • Adding an image resource to an XS Engine project
        • Creating a user interface in SAPUI5
          • Prototyping the interface in static JavaScript
          • Transforming the static JavaScript into dynamically generated code
          • Integrating the user interface and the database access routines
          • Passing information from one source file to another
      • Summary
      • Quick reference
    • A. So Long and Thanks Where To Go from Here
      • What we've covered
      • Now it's your turn
    • Index
  • Title: Software Development on the SAP HANA Platform. Written by a SAP HANA expert, this book takes you from installation to running your own processes in no time. By the end of the course you’ll have awesome data retrieval and analytical powers to call on
  • Author: Mark Walker
  • Original title: Software Development on the SAP HANA Platform. Written by a SAP HANA expert, this book takes you from installation to running your own processes in no time. By the end of the course you’ll have awesome data retrieval and analytical powers to call on.
  • ISBN: 9781849689410, 9781849689410
  • Date of issue: 2013-07-11
  • Format: Ebook
  • Item ID: e_3b3r
  • Publisher: Packt Publishing