Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 

This blog is to address a common problem related to a "Text Join" in SAP HANA graphical modelling (SAP HANA version SP08 & below).

For Example, in the following example the text join has been setup correctly, marking ‘SPRAS’ as a language column.

And also the Default Language is set to “English

Problem:

The model which has the text-join will get activated successfully but in some cases the data-preview will provide ‘NULL’ values for the test description

Though the text description table has values for ‘English


Resolution:

The text join only recognizes the single character representation in the language column. So the value in the "SPRAS" column needs to be ‘E’ instead of ‘EN’ and ‘D’ instead of ‘DE’, etc.

Once we make this change of “EN” to “E”, “DE” to “D” etc , we notice that the data-preview has the correct text description.

4 Comments
Labels in this area