You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Dashboard Prompt: Year, Quarter,Month

in Reporting and Analytics for HCM 1 comment

Summary:

Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable

Content (please ensure you mask any confidential information):

We are working on a customizing line manager dashboard, Workforce Event page. The used column are are not giving correctly result by using the delivered facts like # of Hire, Termination count etc. So, I am working directly with the columns like ("Workforce Management - Worker Assignment Event Real Time"."Worker"."Employee Hire Date").

Prompts required:
Year: 2024
Quarter: 2024 Q 1,2024 Q 2,2024 Q 3,2024 Q 4
Month: 2024 / 01, 2024 / 02, 2024 / 03, 2024 / 04,….. 2024 / 12.

For year, I have created a custom filter using the variable and working fine.
FILTER(COUNT(DISTINCT "Worker"."Person Number") USING (YEAR("Worker"."Employee Hire Date") = @{YEAR}{VALUEOF("CURRENT_YEAR")}))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!