Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Not able to find the exact calculation for OTBI columns in OAC

Received Response
12
Views
2
Comments
User_AYOKV
User_AYOKV Rank 4 - Community Specialist
in Oracle Fusion AI Data Platform Forum

This is more like a technical question. I was trying to migrate one OTBI report to OAC and one of the condition I was trying to create is
when cdl.reversed_flag is not null or cdl.line_num_reversed is not null then 'Y' else 'N' end cdl_net_zero (Currently used condition in OTBI report).

I can find the corresponding column for cdl.line_num_reversed in OAC which is "PPM - Project Costs"."Cost Distributions"."Reversed Line Number" , but not cdl.reversed_flag.

Is this possible to help me with the logic I can use to write this?

image.png

Answers

  • Silvio Garber-Oracle
    Silvio Garber-Oracle Rank 6 - Analytics & AI Lead

    If you need the flag but it isn´t there you can bring it to FDI using data augmentation and add it to your subject area.

  • RVohra
    RVohra Mod

    Hi @User_AYOKV , as a general recommendation, when migrating from OTBI to OAC /FDI

    • Do NOT try to map column-for-column
    • Instead map business meaning
    • OAC/FDI models are redesigned warehouse models, not 1:1 OTBI clones

    You might not need reversed_flag , for OAC/FDI, you might make it work without the flag.