Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Calendar Prompt display format in OBIEE
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.
Answers
-
Hello Experts,
Please suggest any solution for the scenario explained above.
0 -
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.
0 -
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.
0 -
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?
0 -
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
<localeDefinition name="en"> <!-- english base -->
<property name="localeDisplayMessage">kmsgLanguageName_en</property>
<property name="defaultLanguage">en</property>
<property name="characterSetList">locale:en</property>
<property name="listSeparator">,</property>
<property name="decimalSeparator">.</property>
<property name="thousandsSeparator">,</property>
<property name="dateSeparator">-</property>
<property name="timeSeparator">:</property>
<property name="am">AM</property>
<property name="pm">PM</property>
<property name="timeFormat">h:mm:ss tt</property>
<property name="dateShortFormat">dd-MMM-yy</property>
0 -
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.
0 -
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.
<localeDefinition name="en-us" basedOn="en"> <!-- english - united states -->
<property name="localeDisplayMessage">kmsgLocaleName_enUS</property>
<property name="characterSetList">locale:en-us</property>
<property name="primaryCurrencySymbol">$</property>
0 -
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.
0 -
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.
0 -
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.
0