Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

FTE by Gender/Nationality

Received Response
50
Views
5
Comments
User_AYOKV
User_AYOKV Rank 4 - Community Specialist
in Oracle Fusion AI Data Platform Forum

I am trying to create a workbook using the subject area 'HCM - Workforce Core'. Attached the one I created. , but I have to filter it with some salary code(lonkode). ( We already have the same report available in Qlik and I am trying to recreate it in OAC), but I don't see any HCM related subject area is having this lonkode value. Please suggest how I can rectify it.

image.png

Regards,

Tagged:

Answers

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Hi @User_AYOKV by Salary Code, you mean Salary Basis Code which is part of the HCM - Workforce Rewards - Salary Basis subject area? Import this attached dv, modify the filter on Salary basis Code and test.

    Thanks

    Raghu

    FTE by Salary Basis.dva
  • User_AYOKV
    User_AYOKV Rank 4 - Community Specialist

    Thanks for your quick reply and I checked the above, but unfortunately it is not the one I was expecting. Its having the below sample values(Any of the 1st 2 columns).

    image.png

    Please let me know how I can get it in any HCM related subject areas?

  • User_AYOKV
    User_AYOKV Rank 4 - Community Specialist

    I could find these values under GL Detail Transaction LSA.

    image.png

    , but connecting HCM and GL transactions subject area is not an easy task. Is there any way we can get these components in HCM related subject areas?

    Regards,

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Hi,

    can you try using datasets? You can have separate datasets coming from Workforce Core and the GL subject areas. Join them based on this column, and build the workbook

    Thanks

    Raghu

  • User_AYOKV
    User_AYOKV Rank 4 - Community Specialist

    Yes, I can create separate datasets coming from Workforce Core and the GL subject areas, but the issue is I don't see a common column to connect/joints these 2 datasets.