Databases Reference
In-Depth Information
If you switch to the
Analysis
tab of
Data Preview
, however, you can see your data in a much
more visual way, similar to an Excel pivot table, as shown in the following screenshot:
Here are some of the features we can see on the screenshot (feel free to play with the
Data
Preview
tab until you are comfortable with it—you cannot break anything, and nothing that
you do will be saved):
We can add fields from our view to the Labels and Values axis as we require, and here we are
visualizing the
ORDER_AMT
field by the
CUST_NAME
and
ORDER_YEAR
fields.
We're using a
Column Chart
chart option—there are a number of other chart options available.
We've added
ORDER_YEAR
to the
Filters
box; this has given us an automatic filter possibility,
either using the slider, or the drop-down box, or by entering the value on which we wish to filter.
Here, we've filtered on the year
2010
.
In this section, we've taken a look at the two basic building blocks of a SAP HANA application,
the attribute view and the analytic view, using some simple data. First, we created our sample
tables and data using standard SQL statements, and then we created a package to contain our
two views.
We created an attribute view, which allows us to use only the fields we require from master data
tables, and an analytic view, which, when combined with the attribute view, shows the numeric
data we need for our reporting application.