We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Default Period Prompt to Current Period (ICM BIP Report)

Question
1
Views
0
Comments
edited Oct 19, 2021 11:03AM in Reporting & Analytics for Sales

Summary:

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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