You are previewing Software Development on the SAP HANA Platform.
O'Reilly logo
Software Development on the SAP HANA Platform

Book Description

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.

  • Learn SAP HANA from an expert

  • Go from installation and setup to running your own processes in a matter of hours

  • Cover all the advanced implementations of SAP HANA to help you truly become a HANA master

  • In Detail

    SAP HANA is SAP’s in-memory database technology which offers real-time analytics and retrieval. With it, you can dramatically speed up your business processes, predictive analysis, or analytics.

    Software Development on the SAP HANA Platform covers all aspects of the SAP HANA software, taking you from your first introductions, right through to more advanced uses and integrations of the tool.

    Starting with an initial introduction and succinct guides to installation, Software Development on the SAP HANA Platform will then go on to guide you through your first development in an Attribute View. From here, we build on and consolidate SAP HANA knowledge through discussing analytic views, data authorizations, deployment, and integration with other SAP services.

    Table of Contents

    1. Software Development on the SAP HANA Platform
      1. Table of Contents
      2. Software Development on the SAP HANA Platform
      3. Credits
      4. About the Author
      5. About the Reviewers
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
          3. Instant Updates on New Packt Books
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      8. 1. So, What Is This SAP HANA Thing Anyways?
        1. Time for action – statistics about internal commercial flights in the USA from 1998 to 2011
          1. What just happened?
        2. Understanding the performance of SAP HANA
          1. Massively parallel execution
          2. Column-oriented table storage
          3. Data compression
            1. In-memory technology
            2. SAP HANA as an appliance
        3. Summary
      9. 2. SAP HANA Studio – Installation and First Look
        1. Getting access to SAP HANA
          1. Purchasing a SAP HANA license and appliance
          2. Accessing SAP HANA in the cloud
          3. Getting a free 30-day trial of a SAP HANA instance from SAP
        2. Running the installation
        3. Welcome to the SAP HANA Studio
          1. The Modeler perspective
        4. Connecting to the SAP HANA server
        5. Importing sample data
          1. SAP HANA object export
          2. Importing exported data into SAP HANA
        6. Previewing the sample data
        7. Summary
      10. 3. Your First SAP HANA Development – An Attribute View
        1. Creating a delivery unit
        2. Creating a package
        3. Creating an attribute view
        4. Advanced features of attribute views
          1. The client field
          2. Joining tables in views
            1. Join types in SAP HANA
            2. Join cardinality
          3. Completing an attribute view with information from different tables
        5. Summary
        6. Quick reference
      11. 4. Painting with Numbers – An Analytic View
        1. Creating an analytic view
          1. Adding a Table to an Analytic View
          2. Attributes and Measures – what a difference an icon can make!
        2. Adding an attribute view to an analytic view
        3. Advanced features of analytic views
          1. Restricted columns – what they are and how to use them
          2. Calculated Columns
            1. Calculated attribute – DATA_TYPE
            2. Calculated measure – VAT_RATE
            3. Calculated measure – VAT_AMOUNT
          3. Accepting user input
            1. Creating a view by copy
            2. Filtering view contents
            3. Creating a variable
            4. Creating an input parameter
            5. Creating a new calculated column
            6. Modifying existing calculated columns
        4. Summary
        5. Quick reference
      12. 5. Let's Get Graphical – Graphical Calculation Views
        1. What is a graphical calculation view?
        2. Creating a graphical calculation view
          1. Adding analytic views
          2. The projection block
          3. The aggregation block
          4. The join block
          5. The union block
          6. Output
          7. Results
        3. Summary
        4. Quick reference
      13. 6. You Talking to Me? – Scripted Calculation Views
        1. Creating a scripted calculation view
          1. Understanding CE functions
          2. Adding analytic views
          3. The projection block
          4. The aggregation block
          5. The join block
          6. The union block
          7. Defining the view's output
          8. Results
        2. Summary
        3. Quick reference
      14. 7. Hey! That's My Data! – Authorizations in SAP HANA
        1. Roles
          1. Creating a role
          2. Granted roles
          3. Part of roles
          4. SQL privileges
        2. Analytic privileges
        3. System privileges
        4. Package privileges
        5. Users
        6. Testing our user and role
        7. Summary
        8. Quick reference
      15. 8. On Another Level – Hierarchies in SAP HANA
        1. Hierarchy types in SAP HANA
          1. Parent-child hierarchies
          2. Level hierarchies
        2. Creating a hierarchy in SAP HANA
        3. Viewing data according to a hierarchy
        4. Summary
        5. Quick reference
      16. 9. Deploying Your Reporting Application to Reporting Software
        1. Getting software to talk to SAP HANA
        2. SAP Lumira
          1. Downloading and installing
          2. Connecting to SAP HANA
          3. Analyzing data with Lumira
          4. Visualization options and formatting concerns
        3. Microsoft Excel®
          1. Installing the SAP HANA client for Excel
          2. Connecting to SAP HANA using Excel
        4. Tableau software
          1. Installing the SAP HANA client driver
          2. Creating an ODBC DSN in Windows
          3. Connecting to SAP HANA using Tableau
        5. Summary
        6. Quick tool comparison
      17. 10. Data Provisioning Using Data Services
        1. About the sample data
        2. Understanding the BODS main screen
        3. Creating a Data Services project
          1. Creating a project
          2. Creating a BODS job
          3. Creating an ODBC connection to SAP HANA from within BODS
          4. Defining a file format
          5. Creating a data flow
            1. Adding a source object
            2. Adding a target object
          6. Adding a data flow to a job
          7. Running a BODS job
        4. Summary
        5. Quick reference
      18. 11. Application Development Using the XS Engine
        1. Checking the XS Engine
        2. Understanding XS Engine applications
        3. Creating an application using XS Engine
          1. Creating a delivery unit
          2. Creating a package
          3. Creating a project
          4. Sharing your project on the SAP HANA Server
          5. Creating a repository workspace
          6. Checking the status of your project files
          7. Understanding application descriptor files
            1. Creating the application descriptor file
            2. Creating the application access descriptor
              1. Configuration options in the .xsaccess file
        4. Hello, World!
          1. Calling up our XS Engine application in a browser
        5. XS Engine database access
          1. Copying an XS Engine application
          2. Enforcing login in an XS Engine application
          3. Accessing the database
        6. Developing user interfaces using SAPUI5
          1. Adding an image resource to an XS Engine project
          2. Creating a user interface in SAPUI5
            1. Prototyping the interface in static JavaScript
            2. Transforming the static JavaScript into dynamically generated code
            3. Integrating the user interface and the database access routines
            4. Passing information from one source file to another
        7. Summary
        8. Quick reference
      19. A. So Long and Thanks – Where To Go from Here
        1. What we've covered
        2. Now it's your turn
      20. Index