Oracle Communities

Oracle Analytics and AI

Child Item

FTE by Gender/Nationality

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.

Regards,

Find more posts tagged with

HCM

OAC

Accepted answers

All comments

Raghavendra Raghunath-Oracle

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

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).

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

User_AYOKV

I could find these values under GL Detail Transaction LSA.

, 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

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

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.

User_AYOKV

@Raghavendra Raghunath-Oracle,

Can you suggest? I am still struggling with this. I don't see a joint to connect HCM and GL related subject area/datasets.

User_AYOKV

Also one more question please. why CPR number is not visible in HCM workforce core subject area in OAC , even though it is available in Workforce management OTBI subject areas.

Regards,