How to schedule an OTBI report to generate monthly with dynamic prompt?
Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically populate with the first day of the prior month. For example, I'd like the report to run on August 1st and have the datetime prompt automatically populate with July 1st (in datetime format). And then on September 1st have the report automatically run and have the datetime prompt automatically populate with August 1st (in datetime format). And so on. How can I go about this?
Tagged:
1