Skip to Content
author's profile photo Former Member
Former Member

BI Launchpad input date format is mm/dd/yyyy while the same in Webi Rich Client is dd/mm/yyyy

Hello Friends

I am working on BO upgrade from 3.1 to 4.1 for BO BMC Analytics. The current situation while using BI Launch Pad is that the calendar that pops up while entering date taken the date in mm/dd/yyyy format. Due to this, while validating the SQL, the dates like 13,14.....are not processed. We want this calendar to take the values as dd/mm/yyyy.

While using Rich Client from the server, the date format appears properly - as dd/mm/yyyy. This seems to be a trivial issue but is taking up a lot of our time. Please provide suggestions to resolve this.

BO version -BI 4.1 SP01

Windows Server 2008 R2 Enterprise

Connectivity - ODBC

Steps tried so far:

1) Checked the sqlsrv.prm file under E:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\odbc\extensions\legacy

2) Checked the calendar file under E:\Program Files\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\eclipse\plugins\webpath.AnalyticalReporting\web\webiDHTML\dhtmllib

3) Checked the calendar file under E:\Program Files\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\eclipse\plugins\webpath.AnalyticalReporting\web\dhtmllib

Date_Issue.jpg (135.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 12, 2016 at 01:52 AM

    Can you check Launchpad browser settings in preferences? Locales and Timezone settings

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2016 at 11:42 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.