How to Auto-Schedule with a Dynamic Date Parameter

building reports webintelligence
1

I am using Web Intellignece 4.1 support pack 3.

I have a report that is run on a date parameter basis.

I want to auto-schedule this report to run everyday based on the previous day’s data.

How do I do set this up in the auto-scheduling section?

JoeyB99 (BOB member since 2015-06-17)

2

Either create a new Predefined Condition in the universe that applies the necessary date condition, or upgrade to SP06 and use the new default values feature for prompts (which requires unx).

Joe

joepeters :us: (BOB member since 2002-08-29)

3

Hi everybody, it’s me again.

I do not have access to create an object for a universe, or whatever Joe is suggesting.

I am using version 4.1.

I have a relatively simple report and I want the output to always provide forecasted data based on the date field, such that it is >= today.

What options do I have? Is there something I can do with the report filter and simply omit any date criteria in the query filter?

JoeyB99 (BOB member since 2015-06-17)

4

Aren’t these confusing?

I want to auto-schedule this report to run everyday based on the previous day’s data.

I want the output to always provide forecasted data based on the date field, such that it is >= today.

Which is it?

Guess… Maybe Relativedate function?

datawizard (BOB member since 2015-01-20)

5

Speak to your universe designer - they will be able to create the objects in the universe for you, as per the objects in this topic: