Skip to Content
avatar image
Former Member

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 😔 .

pastedImage_2.png (16.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 19, 2015 at 08:41 AM

    Hi Sourav,

    Are you running a Linux/Unix server for BusinessObjects?

    Also, are you using WebI functions in the reports?

    -Sid

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I came across SAP note - 2192833 which describes it as a defect in BI 4.1 SP6 and this is fixed in SP7.

      Pretty ridiculous to be honest 😠 .

  • avatar image
    Former Member
    Oct 19, 2015 at 10:59 AM

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

    Add comment
    10|10000 characters needed characters exceeded