FUZZY function in HANA

[Former Member]

Hi,

are you know how can i run FUZZY function on calculation view in HANA, or maybe there is another similar function?

Thank, Nir

[Former Member · Accepted solution]

Hi Nir,

As Lucas suggested we cannot use Fuzzy on calculation view

Create a table based on the calculation view output and then try applying the fuzzy function.

'LIKE' predicate with the help of '%' and '_', might do in certain scenarios.(Not sure about your requirement)

[Former Member]

Ok i will try this, Thank you for the quick response

[lucas_oliveira]

Hi Nir,

Documentation says its only meant for Attribute views and column tables. I understand column views of type dimension would also work as these would replace the attribute views anyway (haven't tried though). Source:

Supported Data Types - SAP HANA Search Developer Guide - SAP Library

BRs,
Lucas de Oliveira