cancel
Showing results for 
Search instead for 
Did you mean: 

WEBI report come out weird character after promotion.

former_member419024
Participant
0 Kudos

Webi report showing weird character or chinese character after promotion from 4.0 SP7 to 4.1 SP5. Image attach as below:

Checked value in IDT, which all value is fine. But when come to WEBI it show weird character.

1. Is it possible ODBC Driver problem? ODBC Driver in 4.0 SP7 is SQL Native Client 10 which is working well, the ODBC driver in 4.1 SP5 is default SQL SERVER.

2. Found out dimension date I am getting in WEBI is 0001/01/01 00:00:00 but show column value in IDT is different fine which is DEC 3 2014 03:00:00.

Accepted Solutions (1)

Accepted Solutions (1)

former_member191664
Active Contributor
0 Kudos

Is you BI4.1 SP05 platform running on UNIX/Linux, if so, please include the LANG and LC_ALL to your .bashrc/.cshrc/.profile and restart the SIA.

export LANG=EN_US.UTF-8

export LC_ALL=EN_US.UTF-8

Hope this helps,

Jin-Chong

Answers (0)