Want to eliminate prompts in XI; use Scheduling, Events or??

scheduling XI Scheduler
1

Hi, I have a 6.5 report built in DESKI and is now converted over to XIR3. It’s a scheduled report which uses code to do several things, among them calculating a rolling start date for a Start Date prompt. The calculation takes NOW-120 and uses this date as the start date. There is no end date. I’m wondering…is there any way to do this calculation in XIR3 with scheduling, events, conditions or something like this? I want to get rid of the code if possible. We just installed XIR3 in a QC environment so I’m on a steep learning curve here. I don’t know if this is possible. Or…am I better off just leaving the code in and let it go at that? Any help is appreciated…

thanks!

nonyup (BOB member since 2008-01-07)

2

You could create a time dimension table in your database that would hold all of your start-end dates , then create predefined conditions in your universe and modify your report to use those conditions instead of the code that you currently have. (you would obviously need some sort of process in place to keep this table up to date).

jresendez :mexico: (BOB member since 2004-05-03)

3

That’s a great idea, thanks. We have considered that in the past but were hoping to keep this at the report level…

nonyup (BOB member since 2008-01-07)

4

You could build a universe object / filter to do this…

Mak 1 :uk: (BOB member since 2005-01-06)