Scehdule the report with prompt parameter

scheduling XI Scheduler
1

Hi,

I’m in BOXI R2 environment, i have to schedule my web intelligence report with prompt parameter.
Example:
prompt parameter is:-

  1. Insert Current Year (eg:2006)
  2. Insert Current Month (eg:07)
  3. Insert Current Week (eg:04)

Where can i defined those prompt parameter value when i shcedule the wb intelligence report?

Thanks for help!!

Onn

onnonn (BOB member since 2003-11-03)

2

When you schedule the reports you are asked to fill in the prompts. Those prompt values will be used each time the report is run. If you really want something like “current year” then you don’t want a prompt, you want an object or condition that provides the correct value.

There’s another topic going on now talking about how to do that with Oracle…

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Hi Dave,

I have apply query filter in the report, mean user allow to select the prompt value by year, month or day during report refreshing if they required to analysis the historical data. And my scheduler need to execute the report refreshing in daily bases with the default value of current year, current month or current day.

How can i control my query filter on the report? At the same time i need to restrict different user have different access right to the same report. for example : Company A user only allow to view Company A information.

How can i solve this?

Thanks for your help!

Onn

onnonn (BOB member since 2003-11-03)