Databases Reference
In-Depth Information
We can choose the type of filter to apply—for example,
Select all lines where the filter field has
a value equal to
, or
Select all lines where the filter field has a value less than
, then we just
need to give the value for comparison, and SAP HANA will do the rest.
Here, we'll select
Equal
. Next to the
Value
field is the input help button; click on that to see the
Value Help Dialog
window, which you can see in the previous screenshot. If you click on the
Find
button, SAP HANA will present a list of unique values in the view, for the field selected.
Here, for our
ORDER_YEAR
field, we find our two values of
2010
and
2011
. Select the value
2011
and click
OK
to create the filter. You'll see a funnel icon in the view builder, indicating a
filter is in place.
If we activate the view and then preview the data in it, we'll see that only data from
2011
is present.
Calculated attributes
Now that we have our view filtering only on data from 2011, we're going to create a new
column from scratch, which will show us the year 2012. This is the base of our simulator
application—we'll simulate data from 2012, based upon the data from 2011.
To do this, we're going to create a
calculated attribute
. As its name suggests, this function
allows us to do calculations on attribute (non-numeric) values. For readers familiar with
SAP's BW system, this feature is unique to HANA—you can't create calculated attributes
(at query level) in BW, but can only create calculated measures (which are referred to as
ratios or key figures).
In our example, we'll be taking the
ORDER_YEAR
value, adding one year, and storing the
result in a new column that we'll call
NEXT_YEAR
.
