If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Prompt Value default selection

Started by Mpotla, 25 May 2010 01:52:58 PM

Previous topic - Next topic

Mpotla

Hi Guys,

I have a requirement for prompt values selection, I have three Value prompts in three different reports.
One prompt  displays YYYY-MMM, (Monthly report)
second prompt display YYYY-QQ,(Quarterly report)
third prompt displays Date which is not the calender date displays either any working wednesday or last working day of the month.
My reports are working fine with prompt value selecting manually.

Here is my requirements... i want to schedule my above three reports with default selection as the latest value in the prompt control and output should be archived in PDF format.

by the way I am using cognos 8.3.
Any help in soving the issue is appreciated.

Thanks
Potla.




mvjcognos

Try this once

I dont know how is ur datatype but u can go like this
1) Static choice enter name as Current_Year,Current_Month,Current_Day
in alll three prompts.
2) From properties select default selection for all three prompts Current_Year,Current_Month,Current_Day.
3) I think in the report query u have three filters for three prompts in that filter u write a case statement like this.....
   (Case when ?Year?='Current_Year' then (year data item) else ?Year? end)

Note= year data item = Like if u are checking for last year data in the prompt then u can write trunc(year data item ,'Year')-1 based on the calculation u are using for prompt selection.
4) Actually for scheduling u can select any one option in all the three prompts
5) Now our report will show only the latest value selected for scheduling in the output.