Number fields losing format in BI Publisher

Question

Hi,

I have a BI Publisher report using an analysis as source in Data Model. However, when I run the analysis, the number fields have been shown with their correct formatting (Ex.: 999.999,99). However, when I open the BI Publisher report the format changes to 999,999.99 and I am unable to change the data format on Data Model.

I am exporting the BIP report to a csv file.

How can i force the correct format be displayed on BIP report ? Is there a way to set the csv export to semicolon instead a colon  as delimiter ?

Thank you in advance

Gaurav Bharadwaj-Oracle · Answer

Hi @Alvaro_Soares,

CSV is unformulated output, It pulls data from DB as is.

Please use another output if you require formatting on top of the data that is stored in the DB.

Alternatively do this conversion in the Data Model SQL.

Regards,

Gaurav