Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to setup dynamic filters in BIP report?
The dynamic filter should adhere to the following logic:
Year: If today falls between February and December, use the current year. If today is in January, use the previous year.
Start Month: Always set to the previous month.
End Month: Always set to the previous month.
-----------------------------Example 1-------------------
If today is 4/30/2024
The filter should follow
Year: 2024
Start_Month: 3
End_Month: 3
------------------------------Example 2-------------------
If today is 1/10/2024
The filter should follow
Year: 2023
Start_Month: 12
End_Month: 12
Tagged:
0