Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

File format setting when export file to excel in workbench in FDMEE

User_89JTSJun 15 2022

Hi guys,
We have just upgraded HFM to a newer version - completely new server, new installation, etc. But then we found that the file format when export to excel is by default change to .CSV while before in our old application, the file format was in .xls.
Does any one know where can i go to configure the settings to change the default from CSV to XLS?
Thanks in advance!

Comments

IGM

Hi,
has this issue been resolved?
We have just upgraded from 11.2.5 to 11.2.9 and have exactly the same issue - in Workbench within FDMEE when selecting "Export to Excel" the data is exported to a CSV file rather than XLS (or XLSX).
Kind regards,
Igor

Stewart Satterly

We have exactly the same issue after upgrading to 11.2.9 - the data is exported as a .csv rather than .xls or .xlsx file. Is this an intentional feature of 11.2.9 does anyone know ? Also, we have found that the .csv export delimits using a semi-colon rather than a comma on our Production environment whereas on our other environments the delimiter is (correctly) a comma.This is despite all the FDMEE settings and regional server settings being idential.Does anyone have any ideas on this?

Frank_Fec

Same for us, 11.2.7 to 11.2.10.
Is this still an "enhancement" of Oracle?

For EPM 11.2.11 and above there is option to choose file Format for workbench export.

Workbench Export to File Format available under Setting System.

1 - 4