Oracle Fusion SCM Analytics

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

How do I pull PROCESSED_FLAG from DW_REQUISITION_CF to my Requisition Subject Area in FDI

Accepted answer
11
Views
4
Comments

Hi Team,

I have been struggling to get a simple solution to get PROCESSED_FLAG from DW_REQUISITION_CF to my Requisition Subject Area in FDI.

Could you please suggest the available options?

Thanks,

Naga

Best Answer

  • Conor Murnane
    Conor Murnane Rank 5 - Community Champion
    Answer ✓

    If you beleive you did everything correctly go to Data Configuration and Reset Cache.

    image.png

    However, you may have missed a step

    image.png

    Manage Factory Customization's

    image.png

    Add in your new columns and add foldersd

    image.png

    Finish. Then publish your sandbox.

    You should have two steps in your augmentation.

Answers

  • Conor Murnane
    Conor Murnane Rank 5 - Community Champion

    Use the Semantic Model Extension to see if that column is available in the Physical Columns. If it is you can follow the wizard to add it in to the presentation layer.

    https://docs.oracle.com/en/cloud/saas/analytics/25r1/fawag/semantic-model-customization.html

  • rajesh_e
    rajesh_e Rank 1 - Community Starter
    image.png

    I have tried adding the column in the requisition details dimension but when tried edit subject area, I still dont see these columns and also when I published I dont see in the front end as well..

  • rajesh_e
    rajesh_e Rank 1 - Community Starter

    You are right on.. I was looking in to "Manage New Customizations".. Thanks for helping out