Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Issue in weekly schedule Bi report with effective date parameter — Cloud Customer Connect
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

Issue in weekly schedule Bi report with effective date parameter

Received Response
11
Views
1
Comments

Summary:

Issue in weekly schedule Bi report with effective date parameter

Content (required):

Hi Team,

Recently I was schedule a report which is weakly basis and it contain one of the parameter called as Effective date.

Actually when the schedule day come, I need a report with effective date as SYSDATE. But it will take SYSDATE date as the day that I was schedule

So, my requirement is when the day came for scheduling the report automatically the effective date should be pick as schedule date.

Ex:- Weekly basis Report

schedule start date -3/28/2022

Effective date parameter- {would be change daily and effective date would be the schedule start processing date see below pic}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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