I need to know the key column information to be associated with the OOTB subject area.

Michi-Oracle

I need to know the key column to be tied to the OOTB subject area.

I want to create a custom subject area in the semantic model extension based on the OOTB subject area definition.

It is difficult to define in the Semantic Model Extension because the definition of the Dimension/Fact binding settings (inner join , left outer join, key column) of the OOTB subject area is not disclose .

I exported the RPD file with the semantic model extension and checked the contents with the ADMIN tool, but
I could not confirm the complete definition of Dimension/Fact.

Sumanth V -Oracle

@Michi-Oracle -

Welcome to the Oracle Analytics Community!
For each module, a data lineage guide is available for reference to understand its usage. In FDI, this is currently the only provided option.

For example, in HCM, you can find the data lineage details in the following document:

https://docs.oracle.com/en/cloud/saas/analytics/25r1/fahia/chapter-data-lineage.html#GUID-69B6BE1A-183B-4F76-B211-7A9295AA1D02

Michi-Oracle

Thank you for your reply.

I have referred to this document,
but it does not state which DB column is the Dimension/Fact JOIN key column.

I downloaded the OOTB RPD file from FDI,
but this also has some (*) settings to match the external RPD,
so I am unable to check the settings.