Databases Reference
In-Depth Information
In this example, we'll create a view from scratch, so just click
Next
to select the tables we
wish to include in our view. You'll be presented with the
Select table
dialog window we saw in
the previous section. For our analytic view, we want to add the
ORDERS
table from the
BOOK
schema. Once that's done, click
Next
, to add attribute views.
By including an attribute view in an analytic view, we can describe the numeric data. Of course,
if all the information necessary was already present in our
ORDERS
table, we could just use the
fields from the table. In our example, in order to be able to show the customer name alongside
their order information, we'll be adding the attribute view that we created in the previous
section. This is done using SAP HANA's
Select Attribute Views
dialog window, as shown in the
following screenshot:
This dialog is almost identical to the
Select table
dialog window, but it allows selection of
attribute views. Just add our view, then click
Next
, where we'll be able to design our analytic
view with the graphical designer.
There's quite a lot of information on this screen, so let's take a look at it in detail.
