Free Sample
+ Collection
Code Files

SAP HANA Starter

Mark Walker

Everything you need to know to be able to build your first SAP HANA standalone application! with this book and ebook.
RRP $19.99

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849688680
Paperback66 pages

About This Book

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results.
  • Understand key principles behind SAP HANA
  • Discover the main features of the SAP HANA Studio for application design
  • Create a reporting application on the SAP HANA platform
  • Visualize your reporting data in Microsoft Excel

Who This Book Is For

SAP HANA Starter is aimed at SAP consultants and users of competing database technologies, as well as anyone curious as to what all the fuss concerning SAP HANA is about. No previous SAP ERP, BW, or database programming experience is necessary, though notions of how SQL and table joins work will be advantageous. Access to a SAP HANA box is necessary to follow the examples locally.

Table of Contents

Chapter 1: SAP HANA Starter
Quick start – creating your first SAP HANA application
Top features you'll want to know about
People and places you should get to know

What You Will Learn

  • Understanding the concepts behind the SAP HANA System – what makes it different
  • Installation and configuration of the SAP HANA Studio
  • Creation of database tables and attribute and analytic views – the building blocks of any SAP HANA application
  • Development of graphical calculation views for more advanced reporting needs
  • Use of calculated attributes and measures in reporting views to manipulate data on the fly
  • Addition of filters and user prompts to your application for more dynamic output
  • Integration with reporting tools such as Microsoft Excel using MDX
  • Discover some of the most useful websites and blogs documenting SAP HANA

In Detail

SAP HANA is SAP's in-memory database technology, and the focal point of their next generation strategy. Using column-based storage to provide highly compressed and rapidly accessed data, a SAP HANA application can be several hundred times faster than the same application on previous generation database technology.

SAP HANA Starter is a hands-on book, taking you step-by-step through the creation of your first SAP HANA application. You will discover the building blocks that SAP HANA provides, and use them to create a robust reporting application. More advanced features are shown, allowing you to transform your reporting application into a yearly sales increase simulator. Finally, you’ll learn how to access your SAP HANA application from Microsoft Excel.

Using easy to understand examples and logical progression, you will build your first SAP HANA application – a sales amount simulator, from scratch.

Starting with the creation of tables in the database, and using the modeling building blocks provided by the SAP HANA Studio, you will first see how to build a reporting application on these tables, and then extend this application to allow sales increase simulation, finally making the data available to others in Microsoft Excel.


Read More