Today we can discuss about the filtering concepts from interview standpoint:
- Report Filter
- Report Limit
- View Filter
- Metric Filter
- Prompt Filtering
- Applies in “WHERE” clause of the Report SQL
- You can either use “Filter” object – which can be re-used on any reports or create them locally within the report (on the fly)
- SQL Engine
It defines a set of criteria used to limit the data returned in the report data set after the report metrics are calculated.
It is local to the report only. (Available under Data >> “Report Data Options” )
It applies in “HAVING” clause of the Report SQL
- Local to the report
- Analytical Engine calculation
- Doesn’t apply to SQL
- OLAP in nature
Will discuss about Prompt & Metric Filter on next week.
Enjoy learning! Stay Safe & Healthy!!