Oracle Fusion Data Intelligence

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

Columns not available when extending entity - Semantic Model Extensions

Accepted answer
22
Views
1
Comments

Goal: I am looking to add a column to one of the dimensions, Procurement - Requisition: Requisition History.

I want to add the column ACTION_TIMESTAMP to the presentation layer. As of now the only column is ACTION_DATE and we would like both. The timestamp is available in the source table, DW_REQUISITION_DOCUMENT_HISTORY_CF.

When I go into the Semantic Model and add column to the dimension. The ACTION_TIMESTAMP Is not available under physical columns.

How can you add available columns from tables in ADW to the corresponding dimensions without Custom tables/augmentations?

Is this not available because it is only a preview feature?

Thanks,

Conor

Best Answer

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    edited Mar 19, 2025 4:00PM Answer ✓

    @Conor Murnane I just tested your scenario and even I do not see the Action_Timestamp column. I will suggest you log an Idea labs request for this column to be mapped to the OOTB Semantic Model.