O'Reilly logo

Real Time Analytics with SAP HANA by Vinay Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating filters

The first question that comes to our mind is why do we need filters? As discussed in Chapter 2, SAP HANA Data Modeling Approach, Modeling Principles section—consideration to make in Chapter 1, Kickoff – Before We Start: The idea is to filter the data at the lowest layer and only bring the data that is actually required by the query. (Quoting it from Chapter 1, Kickoff – Before We Start).That is, we should try to reduce data transfer between the engines. This can be achieved using the following steps:

  1. Creating client dependent views: The data is automatically filtered to one client.
  2. Using domain fix values: This can be used for several fields.
  3. Creating filters: This is defined during design time.
  4. Creating and using the WHERE clauses ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required