Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

Number fields losing format in BI Publisher

Received Response
14
Views
1
Comments
Alvaro_Soares
Alvaro_Soares Rank 4 - Community Specialist
edited Jul 29, 2025 4:25PM in Oracle Analytics Publisher

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

Tagged:

Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    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