Oracle Fusion Data Intelligence

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

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

Accepted answer
33
Views
3
Comments
Scott_Turner_
Scott_Turner_ Rank 5 - Community Champion
edited Aug 13, 2024 7:28PM in Oracle Fusion Data Intelligence

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

Tagged:

Best Answer

Answers

  • 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_
    Scott_Turner_ Rank 5 - Community Champion

    @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