Skip to Content
1

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

Aug 21, 2017 at 12:50 PM

160

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Hi,

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

thanks

Jean

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 20, 2017 at 03:49 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded