Databases Reference
In-Depth Information
First, notice that the graphical designer tab (called
*<view name>(HNA.book)
) has two tabs
at the bottom of the screen—
Data Foundation
and
Logical View
. The
Data Foundation
tab is
used to see what tables (note, not attribute views) and fields are available in the view. Here, for
example, we can see that the
ORDERS
table has been added to the view—and it is the only table
we selected. The
Logical View
, which we will see in a while, will show us how the fields we have
selected are joined to each other.
Next, we can see that the fields from our attribute view are available for use in the analytic view,
even though we can't see the attribute view on the screen. All the fields in every attribute view
selected in the analytical view are automatically visible—it is enough to add the attribute view to
the analytic view to have access to all its fields.
In much the same way as when we created our attribute view, an analytic view requires that we
define first which table fields we wish to use. The definition is done in exactly the same way as
for the attribute view, by right-clicking on the required field, and selecting
Add as attribute
.
Please add the
ORDER_YEAR
,
ORDER_ID
, and
CUST_ID
fields as attributes to our analytic
view. You'll notice that in the
Output
pane, the
CUST_ID
field, which you have just added, has
been renamed to
CUST_ID_1
, because an attribute named
CUST_ID
is already present in the
analytic view—it was provided by the attribute view.
Adding numeric data is done in a similar way, but these fields are marked as
Measures
, not
attributes; so please add the
ORDER_AMT
field as a measure. Adding a field as a measure
indicates to SAP HANA (and to reporting software) that you expect to be able to do calculations
on this field—for example, summing, calculating the average, finding the largest value, and so on.
You will end up with an analytic view resembling the one seen in the following screenshot:
