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

Formatting Data in BI Publisher report

Received Response
451
Views
17
Comments
2»

Answers

  • Antoine KAIBER
    Antoine KAIBER Rank 6 - Analytics Lead

    As for the SQL, this is what I have for instance :

    select distinct

    shs.attribute_date1 as Arrival_Plan_stop,
    (utc.get_local_date(shs.ESTIMATED_ARRIVAL,shs.LOCATION_GID)) as Arrival_Estimate_stop,
    (utc.get_local_date(shs.planned_departure,shs.LOCATION_GID)) as Departure_Plan_stop,
    (utc.get_local_date(shs.estimated_departure,shs.LOCATION_GID)) as departure_estimate_stop,

    from...

     

    But I didn't check for all the reports, but they seem to all have had this update on time at the same time

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Antoine.

    My default for Report Timezone is JVM. That is on the FO processing, not sure it will apply on this case.

    If you can test move your timezone one hour less and the results should display as expected. This will make a case to Oracle to see that some or the report properties are not been respected when you change them.

    Cheers

    Fernando

    MyDateDemo4.JPG

  • Antoine KAIBER
    Antoine KAIBER Rank 6 - Analytics Lead

    Hi Fernando,

    Ok I tried with JVM as well but it didn't work. I also already tried changing my timezone, directly in OTM (the concerned information system) and BIP but it had no impact unfortunately.

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Antoine.

    So many places to change the timezone and none is being fully respected by BIP.

    I know that if you change some of your properties you need to log off and log in again for them to take effect.

    Are we missing something!?

    Fernando

  • Antoine KAIBER
    Antoine KAIBER Rank 6 - Analytics Lead

    Hi Fernando,

    Yes I have disconnected and reconnected but it still doesn't work. I found this link which apparently is about this same issue but on Oracle Sales Cloud : https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=269643864077291&id=2328335.1&_afrWindowMode=0&_adf.ctrl-state=125hed2gci_4

    I'm wondering whether I should make a service request or not actually

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Antoine.

    I would open an SR. They may have some additional information that we may be missing.

    One additional test. The report properties.

    How is the last property configured to you, the one at the bottom of the Formatting Tab.

    My reports where upgraded from 11g 1.1.5 all the way to 12c and some still hold the setting "Use 11.1.1.5 compatibility mode" equals TRUE.

    This caused troubles to me but once we set it to FALSE the date works fine.

    Best Regards.

    Fernando

  • Antoine KAIBER
    Antoine KAIBER Rank 6 - Analytics Lead

    Hi Fernando,

    Thanks for your help, unfortunately this compatibility mode was set to False so it doesn't seem to be the solution.

    I will see for an SR and if I have an answer I will keep this thread updated, even though i'm not in charge for SR's so it might take some time.

    Thanks again,

    Antoine