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

Question

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 · Accepted Answer

@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