Chapter 4. Painting with Numbers – An Analytic View
In the previous chapter, we made our first development in HANA, an attribute view, pulling data from several tables and making sure that wherever we have a code we also have its description. Additionally, when we are looking at a customer ID, associated data (attributes) are also available at the same time.
The main limitation with attribute views is that they cannot work with numeric data, which means that we cannot use a customer's revenue, or the number of orders he has placed, or anything else vaguely numeric in an attribute view and then do calculations on it. To put things simply, an attribute view can't count; it doesn't know that one order in January plus one order in February equals two ...
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.
