Viewing data according to a hierarchy
As you recall, our CUST_ATTR attribute view is used inside our CUST_REV analytic view, it is the attribute view that provides all the information describing the revenue information.
Tip
We can of course create a hierarchy at the calculation view (though not analytic view) level. This is done in the same way as for an attribute view, and will give the same results. Creating the hierarchy on the underlying attribute view however, makes it available wherever the attribute view is used, once again adhering to our philosophy of building blocks, trying to do the work only once and reusing it whenever possible.
If we now open our CUST_REV view in Excel using an Excel PivotTable
, we can use our data, and the hierarchy ...
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.
