Significance of Fuzzy Search Setting in an Attribute View

[Former Member]

Hi All,

Could anyone please explain the significance of the Fuzzy Search Setting (under Search Properties ) on an attribute in an attribute view?

I would like to implement fuzzy search on an attribute in an  attribute view and like to know how this setting can be used.

Thanks,

Goutham

[Former Member]

Fuzzy Search helps to enable a search on particular column with high fault tolerant level. Like in case if particular column holds names which can be different because it has been transcribed from different system.

so when you use your attribute view in the abap you can make use of the contains() and score() functions to make use of fuzzy search.

[Former Member]

My understanding about fuzzy search. However not sure if this info may help you.

A fuzzy search can help you seach records even if the search contains additional or missing data with spelling errors.

Fault-tolerant will help you search in text columns or check for duplicate records.

SQL syntax to search

select * from <<your tablename>>  where contains (<<column_name>>, "search_string", FUZZY (0.8))

There is scording system where 1.0 is exactly match to 0.0.

Not all data types are supported.

For more info. "http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf"