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 with current 4 years data or the current 12 years data

Started by claoker, 21 Oct 2009 08:14:22 PM

Previous topic - Next topic

claoker

Hi Admin and Friends,

I need your help, I am supposed create a report with a prompt. The Data in table "Year" is like this ...

Table ----  Year
---------------
Year   Qtr
1999    4
2000    2
..    .
..       .
...      .
..       .      
2003    1      
2003    1      
2004    3   
2004    4      
2005    1      
2006    2   
2007    4   
2007    1   
2008    1   
2008    3      
2009    4   
-----------------
and the prompt should pull the data for

1.current 4 years data or
2.current 12 years data


I need to create a prompt in such away that the prompt to should pull the data for current 4 years data or the current 12 years data

suggest me how proceed
         

I need to your help.

Thanks in Adv

claoker

whastings

I would create a value prompt with two static choices: "Current 4 Years" and "Current 12 Years".

In the report, I would create a couple of query items, one with the current year and the other with the current year less 3 or 11 depending on the result of the prompt and then create a range filter on the reporting year using these query items (reportyear between startyear and currentyear)

For example, if the current year is 2009, and the prompt choice is for "Current 4 Years", then the "start year" = 2009 - 3 or 2006. So the report would select 2006, 2007, 2008, and 2009.