Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Semantic Model Extension - not able to see new column added on database

Accepted answer
51
Views
3
Comments
Sidshah
Sidshah Rank 3 - Community Apprentice
edited Jun 9, 2025 1:58PM in Oracle Fusion Data Intelligence

We have an existing custom Subject Area in FDI. We have added new columns to the backend database.

image.png

While creating a Semantic Model extension to add a physical column, I am not able to see that new column.

image.png
Tagged:

Best Answer

  • Sidshah
    Sidshah Rank 3 - Community Apprentice
    Answer ✓

    "Extend a dimension" to be used to add the new attributes (columns) in the Semantic Model Extension.

Answers

  • Nehemias-Oracle
    Nehemias-Oracle Rank 5 - Community Champion

    Hello @Sidshah

    Please review the following doc -

    FDI: SME ‘Add Column’ Step Not Displaying physical Column:PAY_SYSTEM_STATUS In The Prebuilt Table DW_WRKFRC_ASG_FKB108283

  • Sidshah
    Sidshah Rank 3 - Community Apprentice

    @Nehemias-Oracle Thank you for your response. I checked the Metalink note. Can you please help - what are the steps we need to follow to check or make the new column available in physical layer