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