Identify underlying tables for Delivered Subject Area in FAW/FDI

Vaigu_27

Hello Team,

Is there a Oracle forum/blog we can identify list of Tables used in the OOTB/Delivered subject Area in FAW/FDI.

For Ex; identify list of tables used in Financials - GL Balance Sheet in FAW Subject Area.

Please let us know your thoughts on this?

Thanks,

Vaigu

Sumanth V -Oracle

@Vaigu_27 - It appears you are looking for the logic of the pipeline on how data is loaded from Fusion Application to FDI Data Warehouse which is currently not exposed. The lineage details covered in the provided guide is the only source of information we have currently.

Also, Budget data is stored in Budget_CF table. We have a separate SA called GL Budget Facts to get the budget related information.

Sumanth V -Oracle

@Vaigu_27 - Please check the Data Lineage Spreadsheet.

https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/data-lineage.html#FAIAE-GUID-0AF78720-4C42-4346-8B1E-CA27079C09BD

You can filter based on Subject Area in the excel and find out both the FAW physical table and even the corresponding column information as well.

Kindly accept the answer, if it does answer your question, so that it helps other users referring the community thread as well. Thank you.

Ashish-Oracle

@Vaigu_27 Another slightly longer way is to identify the Fact table being used in the Subject Area (by dragging any measure column and checking the physical query) and then checking the relationship diagram corresponding to that fact table. (This will give you only the table level information)

https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/relationship-diagram.html

Vaigu_27

@Sumanth V -Oracle @ashish.f.singh-Oracle - We were trying to identify how Actual & Budget data are brought into Financials - GL Balance Sheet Subject Area as the underlying DW_GL_Balances_CF contains both Actual & Budget or Budget data is brought into Subject Area from DW_GL_Budget_CF.

Can you pls let us know how the Actual & Budget data are brought into Financials - GL Balance Sheet Subject Area.

Your thoughts are appreciated.

Paul Bordage-Oracle

Hello,

Is there a star schema/graphical/more visual view of the data model, please?

Thank you

Indra Sardana-Oracle

@Paul Bordage-Oracle : Please find the relationship diagram https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/relationship-diagram.html#GUID-49961A66-2AB0-4425-8EA4-6A269475357C