Oracle Analytics Cloud and Server

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

Categories

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

Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method

Received Response
423
Views
6
Comments
usersrekan
usersrekan Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Summary

Time data changes after exporting to Excel from BI publisher report - not used rtf template

Content

Hello everyone,

i have date data format in the database as 07-OCT-19 12.22.29.994000000 PM. (oracle database).  

created datamodel and report  based on above date field. properties set like 

formating mask: MM/dd/yyyy hh:mm:ss tt

formatting style: Microsoft

ignore user timezone: True.

once i set above properties, in the report editor the date value displaying correctly as 10/07/2019 12:22:29 PM

Whereas once i generate the report and view in the excel output its displaying time as 10/07/2019 06:22:29 PM

why this time is changing? how to avoid this issue? please help me on this really appreciate it.

P.S. i am not using rtf template method design. in 11g getting properly values wheras in 12c getting issue.

Regards,

Joe

Answers

  • usersrekan
    usersrekan Rank 5 - Community Champion

    please any help on this? any workaround for temporary?

    Regards,

    Joe

  • usersrekan
    usersrekan Rank 5 - Community Champion

    Hi All, Any help on this request? thanks in advance.

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Srekan.

    Looks like you didn't get any reply on this.

    It is a RTF template you are working with?

    Have a look at the following options.

    https://docs.oracle.com/cd/E80149_01/bip/BIPRD/GUID-F8B5ACA1-6054-4028-8AC4-2BC43E12332F.htm#BIPRD2583

    Cheers

    Fernando

  • usersrekan
    usersrekan Rank 5 - Community Champion

    Hi,

    I am not using RTF method. BI publisher interactive mode.

     

    Regards,

  • usersrekan
    usersrekan Rank 5 - Community Champion

    Hello All,

    i have created BI publisher report, when i am looking report in  interactive mode, it is displaying only 10 records initially, if i need more records to navigate, i have to click right side scrolling button. is there any way where i can display more than 10 records default in interactive mode.

     

    Regards,

    Joe

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Srekan.

    Yes, there is.

    Navigate to your Report Template, click on the table that contains your data and on the Table tab options change the value on "Rows to Display" (see image).

    If you are using a PivotTable, I don't think that is possible.

    Cheers

    Fernando

    RowstoDisplay.JPG