In this chapter, we have seen a large number of features of SAP HANA. We started by creating a simple analytic view on a base table, allowing us to access and work with numeric information. We joined the attribute view created in the previous chapter to our analytic view, which brought the customer information, allowing us to describe the numeric information in the view.

We then saw how we could create a column whose value would only be filled if a certain condition was filled (a restricted column). Next we created some calculated columns, whose values ranged from simple fixed values (the DATA_TYPE), to a dynamic value depending on the contents of another column (the VAT_RATE), to using the results of other calculated columns in calculations ...

Get Software Development on the SAP HANA Platform now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.