Fusion Analytics Warehouse

Products Banner

Can DFF VO's be used as a source for Data Augmentation

Received Response
63
Views
4
Comments

Summary:

It seems that the requirement to whitelist VO's in order to use them as a source in data augmentations is not there anymore. Does any one know which release onwards this option is available.

Also, does that mean we can access any of the DFF related VO's through data augmentation? Currently, the list of DFF VO's are limited, and, the one i am looking for(FscmTopModelAM.POHeaderDFFPublicBIAM.FLEX_BI_POHeaderDFFPublic_VI) is not available.

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Hi Amrita,

    You could try running an OTBI report on the PO Headers subject area for the DFF attribute to see if it has an reference to this PVO in the query log.

    Ideally you should be able to add via a custom data store as illustrated here which was last updated on Sep 8, 2022. So I presume, this content is latest.

    FA BICCC : Data Lineage Document for DFFs and Their Associated VOs (Doc ID 2463485.1)

    Regards

    Venkat

  • Hi Venkat,

    My query was in relation with FAW. The VO is available in OTBI, however was not coming up in the list of System Provided PVO's while created a Data Augmentation.

    Figured out that it is available when we select Customer Provided as an option, and, type the PVO name in.

  • @Venkat Koduvayur-Oracle what do to if the view object does not have either last updated or creation dates to define extract and incremental keys? for example "FscmTopModelAM.DooTopAM.FulfillLineBIEffEFFBIFlattened" view object? how do we solve this issue?


    thanks,

    Ram

  • Hi

    In such cases, when there is missing last update date/create date in the PVO, do a full data extract of the PVO and do a comparison with last extract with current extract to identify the delta changes (MINUS operation) in the target system/extraction process.

    The PK of this PVO is Fullfilllineid

    Other method is to use BIPublisher to extract on the base table DOO_FULFILL_LINES_EFF_B of the PVO and do the incremental extract by referring the last update columns. Will recommend this method if there are many missing columns in the PVO along with the need for last update/creation date for incremental data extraction..

    Hope this helps


    Regards

    Venkat