Hi,
I have many webi reports which would be used by people from different countries.
I want date and number format to change according to their locale. By changing the preferred viewing locale in infoview preferences, we can get the locale specific default date and number formats. It is working fine.
But I needed to further modify the formats set for diffeent countries. So I went into Control Panel and then Regional and Language options and changed the date and number format for few locales.But this change is not getting reflected into Webi.
I’ve found that you have to change the viewing locale in InfoView as well as change the region settings in the control panel.
There is a GetLocale() function in WebI which I display on a report to determine which locale is being chosen. Also note that the viewing locale string returned in WebI Rich Client vs what is being returned in WebI view info do not always match. I would make sure that you use WebI via Infoview for testing the regional differences.
Hi mcliffordgoo,
I have used GetLocale() function in webi to see correct locale is being selected. Webi formats date and number based on this locale(As as chose use preferred viewing locale to format data in infoview preferences).
It uses some default formats for that specific locale.
Now what I am trying to accomplish is change the default formats used for a particular locale. For example by default for US(en_Us) it uses MM/DD/YYYY.
I am trying to see what I can do to change this default to something else like DD.MM.YYYY for example.
For this purpose I wenet into control panel and changed language settings and ran the report but to no avail.
It am still getting date in previous default formats and not using the one I changed.
Unfortunately I don’t know of a way to change the default date format based on the User Locale outside of what their PC settings in combination with InfoView preferences.
What you can do is make sure that your objects in the universe are of the data type ‘Date’ and then the tool will format object according to the user preference.
What you can do is create a variable on the report side stating that If GetLocale()=en_US Then Formate Date “mm/dd/yyyy” else dd/mm/yyyy)
I believe the US is the only country displays the date mm-dd-yyyy. You might be better off with a standard of DD-Mmm-YYYY or 01-Jan-2011. We had to do this on the report side in the event that a user decided to print the report there was no mistake on the date being displayed on the report.
(BOB member since 2008-05-26)
(BOB member since 2003-02-13)