When working in "HCM - Workforce Core" using #Headcount measure, data returned is accurate, however when I add an Attribute such as Tenure Grouping to Category section the data returned is not accurate. I have the following filter expressions added: * Assignment Status Type Code = 'Active' * Assignment Type = 'Employee' * Assignment Category <> 'Board Member' The issue also occurs when I add 'User Person Type' or 'Age Band Name' into the Category section. Can anyone point me in the right direction? Thanks Scott

Oracle Communities

Oracle Analytics and AI

Child Item

Why is Head Count returning a different result when I add a category?

When working in "HCM - Workforce Core" using #Headcount measure, data returned is accurate, however when I add an Attribute such as Tenure Grouping to Category section the data returned is not accurate.

I have the following filter expressions added:

Assignment Status Type Code = 'Active'
Assignment Type = 'Employee'
Assignment Category <> 'Board Member'

The issue also occurs when I add 'User Person Type' or 'Age Band Name' into the Category section.

Can anyone point me in the right direction?

Thanks

Scott

Find more posts tagged with

FDI Front End

FDI

Fusion AI Data Platform

Accepted answers

Subha_Tripathy-Oracle

Hello @Scott_Turner_

Happy to hear that issue is bieng resolved!

Thank you for letting us know!

-Subha

All comments

Subha_Tripathy-Oracle

Hi Scott,

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Please provide a screenshot of the issue, also would request you to create an SR so that we can assist you better in this case.

Thanks

Subha

Scott_Turner_

@Subha_Tripathy-Oracle Thank you for responding, I raised a SR and the issue is now resolved. I had not applied Current Day filter.

Thank you

Subha_Tripathy-Oracle

Hello @Scott_Turner_

Happy to hear that issue is bieng resolved!

Thank you for letting us know!

-Subha