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

Export analysis from obiee 12.2.1.4v to excel 2007+ time format displaying '######'

Received Response
2
Views
3
Comments
3827179
3827179 Rank 1 - Community Starter
edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

Hi,

I try to export an analysis with time format to excel 2007+, but the field display is ##### or a number (for example -692892.514513889) that excel can't translate to hour.

The data format was custom, but also when I changed it to the default, it didn't export correct.

How can I solve this problem?

Thanks.

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    What is the exact format of the Date Column? Does it have a custom date format mask? Is it an actual date column or a string with a date format? Some screenshots may be helpful in getting a better understanding of your issue.

  • 3827179
    3827179 Rank 1 - Community Starter

    I can't upload screenshots because I work on computer that isn't connected to the net.

    The column is date that in the rpd cast to time.

    The first format i try with is custom HH:mm,
    I try also don't override the default format or use suggest formats like [FMT:time] or [FMT:timeODBC] but it didn't solve the problem.

  • 3827179
    3827179 Rank 1 - Community Starter

    Hi,

    Just to update that finally I used the field as date type, I set the data format as HH:mm,

    and the problem solved.

    I think that the problem is with time field type.