Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 12, 2017 at 09:45 AM

    Hi,

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

    thanks

    Jean

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2017 at 03:49 PM

    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


    Add comment
    10|10000 characters needed characters exceeded