Scheduling Web Intelligence Reports

[Former Member]

Hi All,

I have set of Web intelligence reports that need to be scheduled. These reports have date and plant as input when executed interactively. If I need to schedule this report on a specific day for specific plant how can this be done.

For example plant 2000, every friday ( all data as of last 30 days), I could use current date -1 and schedule the report on Friday early morning, so it will calculate last 30 days upto Thursday. But it will bring all the plants. Is there any way I can pass parameters to the web intelligence report and schedule it?

Any ideas?

Thank you,

Arthur.

[sateesh_kumar1]

Hi Arthur ,

Create optional prompt on Plant and Date and create schedule recurrence to run on Friday .

What is your backend ? If it is BW , then create Input ready variable on date and apply -30 days offset on the variable.

Schedule the report to run on Friday .

If is on any other database , you need to create @prompt() in universe .

The below blog has all the information you need

Dave’s Adventures in Business Intelligence » Using a “Magic Date&#...