Webi report scheudling with prompt value as currentdate

building reports webintelligence
1

When scheduling reports using infoview how can I set a default value for a prompt to be set to current date? any idea? so if report runs today it will set the prompt value to todays date and if it runs tomorrow it should set the prompt value to tomorrows date. I am using BO XI3.1

Thanks in advance

SAMTHEBOBJGUY (BOB member since 2010-07-24)

2

This requirement is usually addressed by creating a date condition in the universe, so that no prompt is needed at runtime.

Tom Thompson :us: (BOB member since 2003-06-04)

3

This is how I accomplish this via the Report:

(The prompts are optional).

If you leave the optional prompt blank it will return the current date, or if you select a date via the prompt it will return the selected date. Schedule the report with the optional prompt left blank which will return current data, then when a user refreshes the report they can choose a date to run if so required.

HTH

NMG
dates.JPG

mcnelson :uk: (BOB member since 2008-10-09)

4

Helllo,

Here, do I need to choose/check box OPTIONAL PROMPTS option for DATE objects? If yes, do i need to check for all DATE objects including LINE1 and LINE 3??

Please elaborate.

chaithu1983 (BOB member since 2009-05-19)

5

Yes.

Andreas :de: (BOB member since 2002-06-20)