Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Software Development on the SAP HANA Platform
  • Table Of Contents Toc
  • Feedback & Rating feedback
Software Development on the SAP HANA Platform

Software Development on the SAP HANA Platform

By : Mark Walker
3.3 (3)
Buy this Book
close
close
Software Development on the SAP HANA Platform

Software Development on the SAP HANA Platform

3.3 (3)
By: Mark Walker
Buy this Book

Overview of this book

Table of Contents (19 chapters)
close
close
close
Software Development on the SAP HANA Platform
Icon
Software Development on the SAP HANA Platform
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Free Chapter
1
So, What Is This SAP HANA Thing Anyways?
Icon
So, What Is This SAP HANA Thing Anyways?
Icon
Time for action – statistics about internal commercial flights in the USA from 1998 to 2011
Icon
Understanding the performance of SAP HANA
Icon
Summary
2
SAP HANA Studio – Installation and First Look
Icon
SAP HANA Studio – Installation and First Look
Icon
Getting access to SAP HANA
Icon
Running the installation
Icon
Welcome to the SAP HANA Studio
Icon
Connecting to the SAP HANA server
Icon
Importing sample data
Icon
Previewing the sample data
Icon
Summary
3
Your First SAP HANA Development – An Attribute View
Icon
Your First SAP HANA Development – An Attribute View
Icon
Creating a delivery unit
Icon
Creating a package
Icon
Creating an attribute view
Icon
Advanced features of attribute views
Icon
Summary
Icon
Quick reference
4
Painting with Numbers – An Analytic View
chevron up
Icon
Painting with Numbers – An Analytic View
Icon
Creating an analytic view
Icon
Adding an attribute view to an analytic view
Icon
Advanced features of analytic views
Icon
Summary
Icon
Quick reference
5
Let's Get Graphical – Graphical Calculation Views
Icon
Let's Get Graphical – Graphical Calculation Views
Icon
What is a graphical calculation view?
Icon
Creating a graphical calculation view
Icon
Summary
Icon
Quick reference
6
You Talking to Me? – Scripted Calculation Views
Icon
You Talking to Me? – Scripted Calculation Views
Icon
Creating a scripted calculation view
Icon
Summary
Icon
Quick reference
7
Hey! That's My Data! – Authorizations in SAP HANA
Icon
Hey! That's My Data! – Authorizations in SAP HANA
Icon
Roles
Icon
Analytic privileges
Icon
System privileges
Icon
Package privileges
Icon
Users
Icon
Testing our user and role
Icon
Summary
Icon
Quick reference
8
On Another Level – Hierarchies in SAP HANA
Icon
On Another Level – Hierarchies in SAP HANA
Icon
Hierarchy types in SAP HANA
Icon
Creating a hierarchy in SAP HANA
Icon
Viewing data according to a hierarchy
Icon
Summary
Icon
Quick reference
9
Deploying Your Reporting Application to Reporting Software
Icon
Deploying Your Reporting Application to Reporting Software
Icon
Getting software to talk to SAP HANA
Icon
SAP Lumira
Icon
Microsoft Excel®
Icon
Tableau software
Icon
Summary
Icon
Quick tool comparison
10
Data Provisioning Using Data Services
Icon
Data Provisioning Using Data Services
Icon
About the sample data
Icon
Understanding the BODS main screen
Icon
Creating a Data Services project
Icon
Summary
Icon
Quick reference
11
Application Development Using the XS Engine
Icon
Application Development Using the XS Engine
Icon
Checking the XS Engine
Icon
Understanding XS Engine applications
Icon
Creating an application using XS Engine
Icon
Hello, World!
Icon
XS Engine database access
Icon
Developing user interfaces using SAPUI5
Icon
Summary
Icon
Quick reference
So Long and Thanks – Where To Go from Here
Icon
So Long and Thanks – Where To Go from Here
Icon
What we've covered
Icon
Now it's your turn
Index
Icon
Index

Advanced features of analytic views

As we have seen so far, an analytic view allows us to use numeric information. We can present salaries, sales amounts, turnover, and all kinds of numbers with an analytic view. We can also join an analytic view to an attribute view, and profit from the metadata they provide, enabling us to describe our numeric information.

Analytic views have a lot more functionality however, making them considerably more powerful. In this section we'll take a look at a few of the functions they provide.

Restricted columns – what they are and how to use them

One feature that an analytic view can provide is a restricted column. This option will create a new column in our view, based upon an existing numeric value, and only populate it for a given line if a specified condition is true.

Note

For readers familiar with the SAP BW BEx reporting suite, this feature is equivalent to a restricted key figure.

The easiest way to understand the concept is to make a restricted column ourselves...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 4
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY