I am building up a report. The reports needs to have cross tab shown as between year and month selection e.g. nov 2011, dec 2001, jan 2012, feb 2010. My problem is that the database has got year and Period in different columns. So, if I make <Year> between ?from year? and ?to year? and <month> between ?from month? and ?to month? then it brings up data for only nov to feb of 2011 and 2012. I used the combination of prompt as (YEAR and PERIOD) between (?P_Year? and ?To_Year?) and (?P_Month? and ?To_Period?) but it is throwing error. Any suggestion on how to achieve the from to range with different columns of year and month.
I am using cognos 10.1
Pinned topic Cognos year and month prompt combination
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-27T14:34:34Z at 2013-03-27T14:34:34Z by DanielWagemann
SystemAdmin 110000D4XK15496 Posts
Re: Cognos year and month prompt combination2013-03-27T12:18:15ZThis is the accepted answer. This is the accepted answer.
- DanielWagemann 2700058MAJ
DanielWagemann 2700058MAJ411 Posts
Re: Cognos year and month prompt combination2013-03-27T14:34:34ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK