multi select 'Year,Quarter,Month,Week'.

[kirankumar777]

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.

[Sreeni P]

Hi
What data sources do you have?

[jahnavi]

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

[kirankumar777]

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

[kirankumar777]

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