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
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
chevron up
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

Viewing data according to a hierarchy

As you recall, our CUST_ATTR attribute view is used inside our CUST_REV analytic view, it is the attribute view that provides all the information describing the revenue information.

Tip

We can of course create a hierarchy at the calculation view (though not analytic view) level. This is done in the same way as for an attribute view, and will give the same results. Creating the hierarchy on the underlying attribute view however, makes it available wherever the attribute view is used, once again adhering to our philosophy of building blocks, trying to do the work only once and reusing it whenever possible.

If we now open our CUST_REV view in Excel using an Excel PivotTable , we can use our data, and the hierarchy will allow us to have automatic subtotals and grouping of data.

Note

As explained earlier, we cannot see the results of our hierarchy from the Studio, and as yet, we don't know how to access our views from an MDX tool, such as Excel. For that reason...

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