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

Incompatibility with all date and hours - export from BI

Received Response
1
Views
3
Comments
choracy69
choracy69 Rank 6 - Analytics Lead
edited August 13 in Oracle Analytics Cloud and Server

Hi everyone,

I have problem with export data from BI do excel 2017+.

In OBIEE I have:

pastedImage_0.png

When I export do excel 2007+ i see:

pastedImage_2.png

In excel I have one hour later....

In obiee my setting is:

pastedImage_3.png

The correct time is in BI, in excel is wrong.

What can i do?

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Can you force the Column format in the column properties?

    2019-08-21_12-47-33.png

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Thanks for response.

    In BI I have something like:

    pastedImage_0.png

    But it still not work.

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    See OBIEE 11g/12c : Excel 2007+ Export Does Not Honour OBIEE Time Zone Preference And/Or Offset Configuration (Doc ID 2375514.1)