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 ...

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.