nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

As of Date Filtering - Oracle Analytics Workbook

Jae.L

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.

Find more posts tagged with

Oracle Fusion Analytics

FDI

Fusion HCM Analytics

Accepted answers

Jennifer Nakata

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.

All comments

gclampitt

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

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

Jae.L

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.

Jennifer Nakata

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.

Jae.L

@Jennifer Nakata thanks, this worked.

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders