How to set up drop down values

[kgcognos]

I need a value prompt for my year parameter.
The drop down should show only 2 years based on the current month.
If current month < Oct, it should show current year and previous year.
If current month >= Oct, it should show current year and next year. 

We are new to COGNOS, we don't have a time dimension setup yet so I cannot reference a member.

How and where can I setup my required years and setup the prompt to display these years?

Thank you in advance.

[calson33]

You could do it using an SQL query for the prompt. I don't know how that would interact with dimensional data though.

[MFGF]

Are you using a relational package (query subjects and query items) or a dimensional package (dimensions, hierarchies, levels and members / attributes)?

MF.

[snagaboina]

Hi,
i tried with below code in the filter section of prompt query for relational model and it is working.
See if this help for u

[YEAR] in (YEAR(current_date),YEAR(current_date)+1) and MONTH(current_date) >9
or
[YEAR] in (YEAR(current_date),YEAR(current_date)-1) and MONTH(current_date) <=9

Thanks!