Hello Everyone,In Live tables we use INV_FLAT_HIERARCHIES to get Parent & Child Information, but in DWH which table will replicate same as FLAT_HIERARCHIES.
Please try querying DWH_INV_HIERARCHY in PPM_DWH, this should have the information about parent and child investment you need.
Hope this helps -Nika
I believe you will be able to find the details within these two tables: DWH_INV_TASK_HIERARCHY, DWH_INV_HIERARCHY.
Hope that helps.
Retrieving data ...