nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Calendar Prompt display format in OBIEE

User_DTFOB

Hello Experts,

I would like to change the display format for all calendar prompts in OBIEE dashboards. Kindly note that the query is specific to the calendar prompt option. The custom format of analysis criteria do not have any impact on this display.

Appreciate your help.

Find more posts tagged with

Accepted answers

All comments

User_DTFOB

Hello Experts,

Please suggest any solution for the scenario explained above.

Jerry Casey

That was answered here: Doc ID 2067123.1 for 11G. I don't know a way to do it in the front end.

Do you have the correct locale selected? That will change your default date formats.

User_DTFOB

Hello Jerry,

Thank you for the reply. The locale selected is English. The display of date is specific to the dashboard calendar prompt.

When we select the date from the calendar, the format displayed is '06-02-2020' and I would like to change it to 02-Jun-2020.

I tried modifying the localdefinitions.xml file but it does apply to the caledar prompt option.

This is a specific client requirement, kindly suggest something or any workaround.

[Deleted User]

2634558 wrote:I tried modifying the localdefinitions.xml file but it does apply to the caledar prompt option.

Can you please explain this sentence in detail. WHAT did you modify EXACTLY? Did it apply? Did it *not" apply and the sentence above is erroneous?

User_DTFOB

Hello Christian,

Thank you for the reply. I modified the below attribute in bold in localdefinitions.xml file to change calendar display format. The however did not apply to the format in calendar display

<property name="localeDisplayMessage">kmsgLanguageName_en</property>

<property name="characterSetList">locale:en</property>

<property name="dateShortFormat">dd-MMM-yy</property>

[Deleted User]

Ok this should be quite obvious:

You are using the en-us locale but change the english base locale definition. Do you really expect any change to be reflected? Think about it.

User_DTFOB

Hello Chiristian,

Thank you for the reply. All the main properties are given in english base and the specific ones are given as per language and country in localdefinitions.xml file. So that is why i changed it in english base section

Please let me know, if we have to make changes in any other section to make it reflect.

<property name="localeDisplayMessage">kmsgLocaleName_enUS</property>

<property name="characterSetList">locale:en-us</property>

User_DTFOB

Hello Christian,

Please guide if the display format is feasible. This is a client requirement and they are looking for an answer if it is doable in the OBIEE tool.

[Deleted User]

It's perfectly doable with the information you have been provided. If you can't get it to run you can forward your client to me and I'll invoice them for the solution.

User_DTFOB

Hello Christian,

It does not seem to work for the calendar prompt even after i make the required changes in the localdefinitions.xml file.

I will raise an Oracle SR to see if the issue is with my OBIEE version.

Thank you for your guidance.