O'Reilly logo

Software Development on the SAP HANA Platform by Mark Walker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required