We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Methodology to move a hierarchy from HCM Empower to FDI
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!
Best Answer
-
@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-29BA69302B1F0
Answers
-
@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?
0 -
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!
0 -
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.
0