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

  • 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.

Welcome!

It looks like you're new here. Sign in or register to get started.