Adding an attribute view to an analytic view
Let's take a closer look at the CUSTID_COUNT value. SAP HANA says there are 13 individual values. If we were to add the attribute view we created in the previous chapter, we could have the customer's name (and all the other information we gathered together) alongside their revenue.
Adding an attribute view to an analytic view is basically the same as adding a table.
Our CUST
_REV
analytic view currently looks like the following screenshot:
In the Data Foundation we have our REVENUE
table, and we've added the YEAR, CURRENCY, and CUSTID fields as attributes, and the AMOUNT field as a measure.
In the screenshot, ...
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.