Summary

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.