Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Methodology to move a hierarchy from HCM Empower to FDI

Accepted answer
41
Views
4
Comments
JDCal
JDCal Rank 3 - Community Apprentice

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

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    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-29BA69302B1F

Answers

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    edited August 27

    @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
    JDCal Rank 3 - Community Apprentice

    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
    JDCal Rank 3 - Community Apprentice

    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.