COGNOiSe.com - The IBM Cognos Community

Hi All,
I have a below urgent requiremnt,

I need to create a period prompt based on current_date.
user can able to select past one or multi select 'Year,Quarter,Month,Week'. from current date.
I am using relational data..

Please give me the steps
I am new bee in cognos..
Please help me urgent,
quick response would be greatly appreciated.

Hi
What data sources do you have?

Hi,

You can extract6 the year from the sysdate extract(year,{sysdate}) and Keep it in a dataitem and point this data item to the prompt .same like month.
and Quarter you might have written a calculation
case
when [month] between 'January' and 'March' Then ('Quarter1')
.
.
.
end

Hope you understand

Let me know if you need any more

Quote from: srinivas_p on 20 Dec 2010 01:45:11 AM
Hi
What data sources do you have?

Thanks for response.
I am using Oracle10g as database.
And using relational data,
can you please clear me what you exactly need

Thanks,
kiran

Quote from: jahnavi on 20 Dec 2010 04:27:42 AM
Hi,

You can extract6 the year from the sysdate extract(year,{sysdate}) and Keep it in a dataitem and point this data item to the prompt .same like month.
and Quarter you might have written a calculation
case
when [month] between 'January' and 'March' Then ('Quarter1')
.
.
.
end



Hope you understand

Let me know if you need any more

Thanks for respnse,

I am confused,
This is what all i need,
Actually I need to create a prompt, so that user can select either one or more from below selection criteria(multi-select)

past 1year data from today
past 6Months data from today
past 1 quarter data from today
past 1month data from today
past 1week data from today


I also have a data item called [Reported Date]
Please give me any idea of making this.


Thanks in advance
Kiran