Creating filters
Filters help to reduce the amount of data to be retrieved from a database. This applies both within SAP HANA and also between SAP HANA and the reporting tools.
How to do it…
We will be applying filters as follows:
Open the analytic or calculation view, and at the data foundation level, select the field that the filter has to be applied to. Right-click on the field and select Apply Filter, as shown in the following screenshot:
Select Operator and a filter value to be applied, as shown in the following screenshot:
After applying the filter, we can see a yellow funnel symbol against the field indicating that the filter has been applied, as shown in the following screenshot:
How it works…
The type of filter we created on the field in an analytic/calculation view is called a constraint filter or design-time filter. When such a filter is created on a field, filters will be applied on the data before querying from the database when the view is called. This improves runtime performance...
