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

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders

GTA 50