Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle BI prompts date format change

703898May 28 2009 — edited May 13 2010

Good day to every one here.

I`ve got the major trouble with date format when updated the OBI version to 10.1.3.4

it looks like this:

i have the column with date data type. it is date in DB, is designated date in Admintool (was created as date - i know about OBI "remembering the first data type"). it alsow shows as a date in any table, and, even allows the calendar promt type.

it shows in format "dd.mm.yyyy".

BUT! when the user hit "Go" button - the format changes to "yyyy-mm-dd 00:00:00"!
(this appears in calendar promt and in multiselect promt. "inside" both of em "dd.mm.yyyy" was used in all cases before you pressed "Go" button. )

I checked both DBfeatures (format is set as "dd.mm.yyyy" for date, and "dd.mm.yyyy 00:00:00*.000*" for timestamp) and NQConfig (three display formats are set to "."-formats).

Alsow i`ve checked locales definition and added(there were none in my locale) shortDateformat, longDateformat and DateFormats tags.

None`ve helped.
Any ideas ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2010

Added on May 28 2009

#bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #date, #prompt

35 comments

15,281 views