Report Views not using correct prompt values

[BIinNJ]

Hello,

I have a report view that has saved prompt values, for simplicity, it has two choices Year and Country.   We made the report list the years in the prompt as follows, so that the report view does not need to be updated every year, since it should run for the "Current Fiscal Year" by default, which is determined at runtime.  The Display Values on the prompt are:

2010
2011
2012
Current Fiscal Year
2014

In the properties, the report view has a saved prompt value of "Current Fiscal Year", and in this example the Use Value is 2013.  This report view is then scheduled to run weekly and should use the value "Current Fiscal Year" (use value = 2013) when running the report.  However, the report is still using the value 2012, which is the Use Value when the report view was oringally created. 

When running the source report interactively or when running the report view and checking the "Prompt for Values", it then  correctly uses the value of 2013 when I select "Current Fiscal Year".  Only when you run the report view using the Saved Prompt Values (i.e. bypassing the prompt page), it will use 2012.

Has anyone else come across this?  Thanks!

[navissar]

I think I've seen this before. It wouldn't surprise me to learn Cognos is saving the use value for the report view.
In your shoes, I'd create an event and insert as default value a data item which calculates the current fiscal year.

[tjohnson3050]

For the current fiscal year, use a static value like 9999.  In your date filter in the report, use combined 'and' / 'or' expression like:

(?dateparam? = 9999 and [year] = extract(year from current_date))
Or
?dateparam? = extract(year from current_date)