Oracle Communities

Oracle Analytics and AI

Child Item

Logical Table Details in Data Lineage

The FDI data lineage document currently does not have Logical Layer information. Providing Logic Table details will help in identifying the Dimension Logical Tables which can be used to join with custom facts. Please consider providing this at earliest as it helps the developers to build custom logical stars.

Find more posts tagged with

Administration

Needs Votes

Status: Needs Votes

Comments

Nupur Joshi-Oracle

Hi @Suraj Shenoy K S - In FDI documentation refer data lineage section - https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-data-lineage.html#GUID-455C2845-B374-4A3E-8FA5-5A310D437BEE this has details of presentation object and corresponding physical tables and attribute. Similar details would be available for all pillars in similar sections for each pillar.

Please let us know if this does not meet your ask. We can look into solving the issue that you may be facing.

Regards,

Nupur

Suraj Shenoy K S

Thank you for your response Nupur. I was specifically looking for Logical Table details, since that is what will be required when we create custom logical stars and would want to re-use OOTB logical dimension tables. Right now we are having to guess the name of the Logical Dim since it is not available in the documentation.

Krishna Prasad Kotti-Oracle

Hi @Suraj Shenoy K S Can you elaborate why we need logical table details ?

If you are looking for details of the logical star is arranged, then you can use the below documentation for the information to get information about Relationship Diagram
https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-relationship-diagram.html#GUID-331D5F7D-B928-4056-9252-9BAE97B95C0D

Suraj Shenoy K S

Thank you for checking on this @Krishna Prasad Kotti-Oracle. We need the logical table details of OOTB dimensions so that we can use those to join with custom fact tables in custom logical stars, thereby increasing the extensibility of FAW without having to recreate OOTB dimensions in custom schema again.

Also I had looked at the document you referenced above, but it has only physical star details and not the logical start details.

Shaun Mullen

Experiencing the same issue for the same use case described above.

Suraj Shenoy K S were you able to overcome this issue without having to guess the name of the Logical Dim?

Krishna Prasad Kotti-Oracle would you know if any documentation including logical Dims is now available ?
I had a search but unable to locate.

Many thanks,
Shaun

User_A4SYN

Even am looking for documentaion or lineage document which has logical table details… as the data lineage document has only physical and presentation tables.. could not able to identify the corresponding logical table . really bad. :(

not sure why oracle is doing this half baked