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

Custom data format override issue

Received Response
3
Views
3
Comments
User_TN9BE
User_TN9BE Rank 2 - Community Beginner
edited Aug 13, 2024 5:40PM in Oracle Analytics Cloud and Server

Hello,

I'm noticing issue in OBIEE 12c while try to migrate report from 11g that has a date column with custom data format as "MM/DD/YYYY" which is getting overridden to default  [FMT:timeStampShort].  Initially, I thought its 11g to 12c migration issue but subsequently, I'm noticing same behavior within 12c when deploy from Dev to Test environment.

I wonder if there is something to do with BI server side value set up or any possible way to fix this, would be greatly appreciated.   The issue is minor but amount of report changes are in 100s as part of the 11g migration.  Hence its bothering.

Please see attached sample.

Thanks

Bala

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Which version of OBIEE 12c have you upgraded to?

  • User_TN9BE
    User_TN9BE Rank 2 - Community Beginner

    The version is 12.2.1.2.0.  

    Originally, the purpose is to migrate all 11g reports to 12c env.  I noticed this issue when I migrated from 11g to 12c (Dev instance) and I thought its related to migration issue from 11g to 12c.  But eventually, I fixed the format in one or two reports manually within 12c (Dev instance) and tried to move to 12c Test instance (all similar 12c versions) and realized it's not the issue related to 11g to 12c migration.

    Because now it's happening within 12c instances.

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hello User,

    How you are migrating the reports from 11g to 12c?

    Can you please specify the high-level steps you have followed?