Oracle Fusion HCM Analytics

Home› Oracle Analytics› Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Online Forum!

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

Accepted answer
41
Views
4
Comments
JDCal
JDCal ✭✭✭
in Oracle Fusion HCM Analytics

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!

Tagged:

Best Answer

  • Ashish-Oracle
    Ashish-Oracle ✭✭✭✭✭
    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 ✭✭✭✭✭
    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 ✭✭✭

    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 ✭✭✭

    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.