Oracle Fusion HCM Analytics

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

Categories

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

As of Date Filtering - Oracle Analytics Workbook

Accepted answer
80
Views
5
Comments
User_AJ
User_AJ Rank 3 - Community Apprentice
in Oracle Fusion HCM Analytics

By default, in our headcount report, we are only able to see current date in the date filter. How can we modify change this so users can filter for headcount on a specified date.

Tagged:

Best Answer

  • Jennifer Nakata
    Jennifer Nakata Rank 2 - Community Beginner
    Answer ✓

    I also experienced this challenge .. the only solution I found was to click the green filter box in the upper right hand corner, and select "None". This opened the selection options.

Answers

  • gclampitt
    gclampitt Rank 6 - Analytics Lead

    Hi Advanced Tab > Prefix

    SET VARIABLE PARAM_EFFECTIVE_DATE can be used to run report as at a specific date.
    EG to run report as at 2021-01-01 :
    SET VARIABLE PARAM_EFFECTIVE_DATE= '2021-01-01';

    For users to set the date - set up a dashboard prompt and set the results to a presentation variable eg VAR_DATE

    Then just use this in the prefix (below also defaults to todays date if no value entered)

    SET VARIABLE PARAM_EFFECTIVE_DATE= '@{VAR_DATE}{@{system.currentTime}[YYYY-MM-DD]}';

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Anna Aj

    Thanks for using Oracle communities.

    Can you share me more details about out of box report name/dashboard for the further review?

    Regards,

    Arjun

  • User_AJ
    User_AJ Rank 3 - Community Apprentice

    Hi @Mallikarjuna Kuppauru-Oracle

    Thanks for your response. It is a custom dashboard not out of the box.

    We used the Headcount metric in HCM Workforce Core to generate the Employee Headcount. Users are only able to filter by the current date; they are requesting to the ability to filter an as-of-date so they can view historical headcount.

    image.png
  • User_AJ
    User_AJ Rank 3 - Community Apprentice

    @Jennifer Nakata thanks, this worked.