Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Day in Japanese Format

Needs Votes
13
Views
0
Comments

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

3
3 votes

Needs Votes · Last Updated