Unexpected Date format in Broadcasting

Robin Lei 02/11/2015

[Solution]

Symptom

A wrong language or locale is used after you logged on to the system ?

Calendar dates are formatted in an unintended way ?

Reason and Prerequisites

1. What is the default language and Default Country for Portal(Need to confirm with Terry)

\\usr\sap\SID\JID\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\WEB-INF\portal\system\properties

request.defaultlanguage=en
request.defaultcountry=us

Comment: [language=EN and country=US  => date format: mm/dd/yyyy]

2. What is the default language for SAP user (If you don’t set it, it will use default)

2.1 SAP default language  RZ11

2.2 You can customize your language and date format

T-CODE:SU3

Comment: the date format can’t work all the time, at first, it depends on Logon Language , then each language will follow its rule

http://en.wikipedia.org/wiki/Date_format_by_country

like United States of America accept format: mm/dd/yyyy, yyyy/mm/dd (but it doesn’t have dd/mm/yyyy)

So you can set any value for B, but it only works in legal format.

2.3 How does it work.

Actually, there are two dimensions what will MAKE the final format,  Language and Country .

http://XXX.apps.XXX:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=ZCNM53_TEST&LANGUAGE=EN&country=GB

http://XXX.apps.XXX:50100/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=ZCNM53_TEST&LANGUAGE=EN&country=US

So someone sets the language, but get the unexpected format. They don’t set locale

So most of time, we may set the language in SAP, and the country will use portal default country.

2.4 how to customize country

We can customize country in Portal user management

Solution:

Step:

1.  Set language / date format in SAP System

2.  Set Country in Portal User Management

3.  Test broadcasting result, if it can’t reach your expectation, try to change date format and country .

4.  Refer to Note: 1416730, if it still can’t work, please try another precalculation sever

Resource:

1. T005X – default date format for Each country

2. Personalization of Portal

3. Note: 1416730  - Regional Settings in Broadcasted Precalculation Workbooks Version  

            947081   - Locales, languages, date and time formats in Web Dynpro

4. How to change the default Portal Language

  Path: \\usr\sap\SID\JID\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\WEB-INF\portal\system\properties

#request.defaultlanguage=en
#request.defaultcountry=us

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/554557/viewspace-1435026/，如需轉載，請註明出處，否則將追究法律責任。