Default Period Prompt to Current Period (ICM BIP Report)
We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period.
We tried using the SQL below, but it does not reflect correctly in the dashboard prompt for BIP. It shows the current month and year (Oct-21) instead of Oct-22 (this is the correct current period) and sometimes, it shows the Period ID. It works for OTBI reports though.
SELECT "Incentive Compensation - Earnings Real Time"."Calendar"."Period Name"
FROM "Incentive Compensation - Earnings Real Time"
WHERE "Calendar"."Start Date" <= CURRENT_DATE AND "Calendar"."End Date" >= CURRENT_DATE
Any help would be appreciated.