MMM-YY format changing to MM-DD-YYYY format when exporting to csv

3551663

Hi,

I have a field in OBIEE as Fiscal Period which will display data as 'Jan-17' but when we are exporting this to csv ,its exporting as Jan-17 but when i click on the data in csv its been chaning to '12/17/2018' which users dont like this.

Is there any way to restrict that.I just wanted to display as Jan-17 in csv as well.

Thanks,

Madhu

[Deleted User]

Which version?

3551663

In 11g and 12C

[Deleted User]

Do you know how many "11g" there were? Somehwere around 40.

Do you know how many "12c" there are right now? 3 with a 4th coming.

Be specific.

3551663

Here it is the exact versions.

Oracle Business Intelligence 11.1.1.9.0

Oracle Business Intelligence 12.2.1.2.0

Thanks

3551663

Any Suggestions on this ?

Gianni Ceresa

Isn't that an Excel behaviour you have to fix in Excel itself? Like trying to be smarter than what required and so translating things into dates?

What's the value you see in the file if you open it as text (with a text editor) ?

3551663

When i opened the csv file in text editor i got the right format as 'MMM-YY'

But how can we explain to Business Users that its working fine as expected in other formats except in csv.

Gianni Ceresa

Try importing the file in Excel using the wizard and set the column as text instead of date or just default, this will maybe forbid Excel to be "smart".

[Deleted User]

11.1.1.9 - https://docs.oracle.com/middleware/11119/biee/BIESG/answersconfigset.htm#BIESG9196

12.2.1.2 - https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-06E71C42-C30E-4F24-8809-9F2D1AED6476.htm#BIESG9196

3551663

Hi Christian,

Thanks for your response.

I have one question on updating this instance config file.

As i didnt see xsi:typpe = 'csv',so do i need to same as like below for csv also ?

<Export xsi:type="csv">

  <DataValue>UseRawValue</DataValue>

  <RepeatRows>false</RepeatRows>

  </Export>