Dynamic Date without initial prompting

[alamrin]

My requirement is

If current date is 30th of April.
Report should run for 28th April automatically without displaying the Date and time prompt page.

I am working on Cognos v10 with Netezza backend.


1)I tried the javascript work around, but they don't seem to work for Cognos v10.

2)Setting the prompt filter as optional generates report for current date and not current_date-2.
Moreover I do not want to make prompts optional as it is an interactive report(not active reports)

3)Since the report is part of the dashboard;
user should have the option to change the date; therefore i cannot put the value(current_date -2) directly in filter.
Instead i am using a dynamic date prompt(Prompt in the report page instead of prompt page)


For the time being  i am setting the value of prompts manually in the cognos connection so that the report runs without prompting the user.

But would like a better solution.

Any advice on how to handle the above mentioned scenario would be helpful.

Thanks,
ALAM

[cfunkho]

I don't know anything about Netezza, but it probably has some kind of system date function you can use.

So, for example, with Oracle as the backend, you can make this data item:  _add_days (sysdate(),-2).  Today is May 3rd, that gives May 1st as the result.  You can then use that in a filter.

Chris Funkhouser

[alamrin]

thanks for the reply Chris.

But my requirement is that the date and time prompt page should not be displayed and the report automatically runs for (<date>-2).

but i cannot put it directly in the filter as it is a dynamic date prompt;
if the user selects a different date at runtime the selected date should be displayed and not (<date>-2)

so default date should be (<date>-2) and after that the report should run for the selected date from the prompt.

Any input on this regard would be helpful.

[pricter]

Have tried to use a prompt macro (in which you put as default value  _add_days (sysdate(),-2)) instead of using the parameter itself.
The above I can not test it since I do not have a report studio in front of me its just an idea.

[MMcBride]

We were forced to switch from java code to prompt Macro's for our default dates back in version 8.4 so we use Prompt Macro's heavily.

With that being said... prompt macro's do not work in Business Insight... so if you are using Business Insight as your dashboard and this report is a 'module' a prompt macro won't really give you what you are looking for.

If you find a solution please repost here as our solution was to disable the ability to use Business Insight for most users since the reports they currently use are heavily embedded with Prompt Macros...