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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.