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

How can I input a date and pass the period and year as parameters?

Started by meckif, 03 Mar 2009 03:13:49 AM

Previous topic - Next topic

meckif

I have a report that needs 3 parameters for filtering (Date, Period and Year). I want the user to just put in a date and then get Cognos to set the other 2 parameters automatically since every day belongs to a specific period and year. How can I do this?

Gollapudi

Hi,

You can have a common parameter [single] for all 3 filters, using extract, to_char or to_date function you can modify the filter, like if its a year filter you can fetch the year from the parameter value and compare by saying like
Quote[Year]=extract(year,?year?)
, simillery you can do for remaining filters....


Thanks,
Gollapudi.

meckif

Thanks,

but that won't work in this case. The financial year goes from 1.May to 30.April, so for the 10th of December 2008 for instance the year is 2009 and the period is 08. I have a table for this, but I don't know how I can assign these values to my parameters ?Year? and ?Period? which I need for the filtering of the report. I need to show transactions on the selected date plus the Period to Date transactions for that period.
I tried cascading prompts, but all I get is the fields greyed out.