Incorrect date format in webI charts with English(...

Former Member · ‎10-17-2015

Hello Experts ,

We have recently upgraded to BI 4.1 SP6 with BW upgraded to 7.4 from 7.0 .

We have tested that the following steps ensure Date format appears in dd/mm/yyyy for our customers based out of UK .

- When working in BI Launchpad -> Preferences -> Locale and Time Zone

-> Preferred Viewing Locale -> set it to "English (United Kingdom)"

now log out and log in again and test the behaviour.

- When using In Rich Client -> Open the report -> Properties ->

Application -> Locale -> set Preferred Viewing Locale to "English

(United Kingdom)" and check the second radio button "Use the preferred

viewing locale to format the data".

Close and re-open WRC completely.

This has ensured data is appearing as dd/mm/yyyy for universe based reports /BEx based reports and even for webI formulas .

But the date is not appearing correctly in dd/mm/yyyy when we are using them in charts .

Would like to have opinion from experts what we are missing here .

ragove · ‎10-19-2015

Does the chart date appear different while you view in WRC and CMC?

Former Member · ‎10-19-2015

Hi Sourav,

Are you running a Linux/Unix server for BusinessObjects?

Also, are you using WebI functions in the reports?

-Sid

Incorrect date format in webI charts with English(UK) as preferred viewing locale.