Special Characters (Äܧ usw.) in SAP BW on HANA Calculation View

[mirjam_becker]

Dear experts,

We build a calculation View to get data from SAP BSEG via SDA into BW. One field contains special characters (Äܧ) and has to be shortend, too.

So we created a calculated colum with following SQL:

if( strlen("Q_UMSKZ_P") != 0, leftstr("Q_UMSKZ_P",1), '')

The Problem is that with this SQL every Special character is translated as

'Ã' and if you want to make a data preview you get an error with this message:

Error: SAP DBTech JDBC: [7]: feature not supported: invalid character encoding: 'Ã', () at function __trex_field_String__()

Within the Composite Provider this field is assigned to a character und in SPRO ÄÜ$ are within the exception table - so normally it should work but doesn´t...

Has someone an idea what SQL could help to get Äܧ?

Thanks in advance.

Mirjam

[Former Member]

Hello,

try this in column engine:

if(match("Q_UMSKZ_P",'Ä*'), 'Ä',IF(strlen("Q_UMSKZ_P") != 0, leftstr("Q_UMSKZ_P",1), ''))

Match function could do the thing but only in simple case like this one, an auxiliary info object might help in more complex cases.

Regards

[Former Member]

Hi,

I0'm facing same issue, didi you find any solution ?

thanks

Jean