Methodology to move a hierarchy from HCM Empower to FDI

JDCal

Wanting to move the position Hierarchy from Empower up into FDI. I am pretty new to FDI and never done this before. I see you can add a Hierarchy via the semantic extension. Would that be the correct method? Is there specific documentation for this. If so, I haven't been able to find it.

Thanks much!

Ashish-Oracle

@JDCal For HCM Analytics, DW_POSITION_CF_DH stores position hierarchy information in column flattened format.

Position Dimension (DW_POSITION_D) is a effective dated table. While joining with Position Dimension, Join on Effective dates along with POSITION_ID

Refer: 2 Tables
https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-tables.html#GUID-D3349269-ABAA-4619-9A0E-29BA69302B1F

Ashish-Oracle

@JDCal Are you looking to bring in the Position Dimension hierarchy from Empower Database and replace the OOTB Position dimension hierarchy of FDI or you are looking to Extend the existing Position dimension with additional columns from Empower Position Dimension and later have them included as a part of the FDI Position Dimension hierarchy?

JDCal

Hi Ashish, I just became a part of this project so not 100% sure but I think we are looking to Extend the existing Position dimension with additional columns from Empower Position Dimension and later have them included as a part of the FDI Position Dimension hierarchy? I will check and reply about this.

Where would I find the OOTB Position dimension hierarchy of FDI?

Thanks much!

JDCal

I found out that we are looking to bring in the Position Dimension hierarchy from Empower Database and replace the OOTB Position dimension hierarchy of FDI . Not seeing the Position dimension hierarchy of FDI yet though.