OTBI Dashboard Prompt: Year, Quarter,Month

Mohan Murali P-Oracle

Hi Team,

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")}))

But finding difficulty for Quarter and Month filter. Any help is highly appreciated. Created a custom column for Quarter but finding difficult to create the filter using the variable.

CONCAT(CONCAT(CAST(YEAR("Worker"."Employee Hire Date") AS CHAR(35)),' Q '),CAST(QUARTER_OF_YEAR("Worker"."Employee Hire Date") AS CHAR(35)))

Same need for months too.

Regards,

Murali

Mihaela P-Oracle

https://community.oracle.com/customerconnect/discussion/788407/otbi-dashboard-prompt-year-quarter-month