What is native filter in SAP BI-BIP-BOE-IDT - Information Design Tool?

SAP Term: native filter

• Component: BI-BIP-BOE-IDT

• Component Name: Information Design Tool

• Description: In the information design tool, a filter created using expressions in a database language for example SQL that can reference tables and columns in the data foundation and also, but not necessarily, objects in the business layer. Called a condition in the universe design tool.

Smart SAP Assistant

• Key Concepts: 
  Native filters are a feature of SAP BusinessObjects Information Design Tool (IDT) that allow users to filter data in a report without having to write a query. This is done by selecting the desired filter criteria from a list of available options. The native filter feature is especially useful for quickly creating reports with specific criteria without having to write complex queries.
  
  How to use it: 
  To use the native filter feature in SAP BusinessObjects Information Design Tool (IDT), open the report you wish to filter and select the “Filter” option from the toolbar. This will open a window where you can select the desired filter criteria from a list of available options. Once you have selected the desired criteria, click “OK” to apply the filter.
  
  Tips & Tricks: 
  When using native filters, it is important to remember that they are applied after the query has been executed. This means that if you are using a query with multiple joins, the native filter will be applied after all of the joins have been completed. This can lead to unexpected results if you are not careful.
  
  Related Information: 
  For more information on using native filters in SAP BusinessObjects Information Design Tool (IDT), please refer to the official documentation at https://help.sap.com/viewer/product/SAP_BUSINESSOBJECTS_INFORMATION_DESIGN_TOOL/4.2/en-US