You want to search for all GL postings with relate to ‘insurance’. Because insurances are exempted from tax, there should be no tax amount included in these postings. But how do you look for these postings? Using HANA Fuzzy search this can be done.
In the HANA full-text search options within SQL, fuzzy search is one of the options. SAP describes fuzzy search as follows:
Fuzzy Search is a fast and fault-tolerant search feature for SAP HANA. A fuzzy search returns records even if the search term contains additional or missing characters or other types of spelling errors.
Source: SAP HANA Search Developer Guide
What this means is that when someone makes a typo, you most likely still will get a hit within your search parameters. The result of the fuzzy search will give you a hit score known as fuzzy score. This rates from 1 to 0, 1 being a full hit. It will tell you how good the hit is with your search query, and possibly you can filter out low ranking results.
Basically there are 3 steps
Once saved, the index is available and ready for use.
Then in the WHERE the fuzzy search is included as a filter to only get the records that contain my keywords. Being SQL I can also add an extra filter to exclude historical data at the end.
In the fuzzy search statement several things are happening: there are multiple search words used who are all given in 1 string separated by the OR-statement and then I only wish to include hits with a fuzzy score of 0.8 or higher.
The result is a set of records that can be used in another calculation view for example.
This is an example on the ease of use. For my scenario this worked well and I guess for 80% of the scenarios this works well. However there is a whole set op parameters that can be added to tweak the fuzzy search. You can find these in the SAP HANA Search Developer Guide.
Thanks for your interest!