Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Day in Japanese Format
What we wish to do
To be able to display excel-exported day data in Japanese just like "2024/11/19 (火)" on the screen as well.
Issue
As to exporting, we could configure the setting below to instanceconfig.xml to make the day display format as exactly how we want, but other data format on Excel is also affected.
<Download>
<Export xsi:type="excel">
<DataValue>UseFormattedValue</DataValue>
</Export>
</Download>
Improvement request
Please make the same level of format setting as Excel as described below to the property of BI column available.
The day format when exported to Excel
Due to the day display format does not match between BI and Excel (Previously the day display format was same for BI and Excel, but it seems Excel separated it into Japanese and English.)
BI Column property : yyyy/MM/dd("ddd")
Excel : yyyy/MM/dd("aaa") *yyyy/MM/dd("ddd") format has been changed to English format.
Therefore, defining yyyy/mm/dd("aaa") at BI side does not mean anything in terms of screen display but the day display is changed into Japanese when exported to Excel.
Related to SR#3-36790050911、3-38378592671