Hana built-in functions working different in DWC - flaw or intentionally?

edited September 2019 in Data Modeling

Hello,

fooled a little bit around using Hana functions for calculated columns in Graphical views / SQL views. There are functions like substr_regexpr, which seem to be different in DWC. E.g. a syntax like


right('0' || substr_regexpr ('(\d*)\.(\d*)\.(\d*)(.*)' in '12.3.18 03:45 AM' group 2),2) as "Day"

is working fine in Hana (result: 03), in DWC I get the error : Mismatched IN, expecting ',', ')', '*', '+', '-', '/', '||'


Another flaw: when adding a column with syntax like 'to_decimal(<operations_on_string_source>, <precision> ,<scale>) as "alias" I would expect to get a column "alias" of type decimal that can be added to the measures of an SQL view of type Fact. Unfortunately the output of this operation is still a column of type string

Are these shortcomings of the Beta or - if not - is there a kind of documentation available describing this behaviour?

Best regards

Klaus

Best Answer

Sign In or Register to comment.