Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Software Development on the SAP HANA Platform

You're reading from   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.

Arrow left icon
Product type Paperback
Published in Jul 2013
Publisher
ISBN-13 9781849689403
Length 328 pages
Edition Edition
Arrow right icon
Author (1):
Arrow left icon
Mark Walker Mark Walker
Author Profile Icon Mark Walker
Mark Walker
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Software Development on the SAP HANA Platform
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. So, What Is This SAP HANA Thing Anyways? FREE CHAPTER 2. SAP HANA Studio – Installation and First Look 3. Your First SAP HANA Development – An Attribute View 4. Painting with Numbers – An Analytic View 5. Let's Get Graphical – Graphical Calculation Views 6. You Talking to Me? – Scripted Calculation Views 7. Hey! That's My Data! – Authorizations in SAP HANA 8. On Another Level – Hierarchies in SAP HANA 9. Deploying Your Reporting Application to Reporting Software 10. Data Provisioning Using Data Services 11. Application Development Using the XS Engine So Long and Thanks – Where To Go from Here Index

Creating a scripted calculation view


The creation of a scripted calculation view is done in exactly the same way as a graphical calculation view:

  1. Open the Modeler perspective of the Studio (see the previous chapter for detailed instructions on how to do this).

  2. Open the Quick Launch panel.

  3. Select Calculation View | Create. You will be presented with the New Calculation View dialog we saw for the first time in the previous chapter.

  4. Enter a Name and Description values (we'll use BOOK_CV_SC, for Book, Calculation View, Script for both Name and Description).

  5. Select our book package.

  6. Set the View Type option to SQL Script, as we can see in the following screenshot:

    Setting the View Type option to SQL Script changes the options available at the bottom of the dialog. We now have the following options available to us:

    • Default Schema: This option lets us define the database schema holding the tables that contain the data with which we want to work. In our case, this database schema is BOOK.

    • Run With: Like...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime