Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Identify underlying tables for Delivered Subject Area in FAW/FDI
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
Best Answer
-
@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.
0
Answers
-
@Vaigu_27 - Please check the Data Lineage Spreadsheet.
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.
1 -
@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)
0 -
@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.
0 -
Hello,
Is there a star schema/graphical/more visual view of the data model, please?
Thank you
0 -
@Paul Bordage-Oracle : Please find the relationship diagram
0
