Incorrect date format in webI charts with English(UK) as preferred viewing locale.
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 .