Topic
  • 3 replies
  • Latest Post - ‏2013-03-27T14:34:34Z by DanielWagemann
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Cognos year and month prompt combination

‏2013-03-27T10:20:59Z |
Hi Users,

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

Thanks
Updated on 2013-03-27T14:34:34Z at 2013-03-27T14:34:34Z by DanielWagemann
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: Cognos year and month prompt combination

    ‏2013-03-27T11:45:33Z  
    Can you please post the output from a list with the Year and Period column side by side.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cognos year and month prompt combination

    ‏2013-03-27T12:18:15Z  
    Can you please post the output from a list with the Year and Period column side by side.
    I am attaching the result mockups. The expected output and generated output

    Thanks,
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: Cognos year and month prompt combination

    ‏2013-03-27T14:34:34Z  
    I am attaching the result mockups. The expected output and generated output

    Thanks,
    Thanks for the expected output, can you please post the output from a list that has the Year and Period column side by side. With this I can see what the data looks like and possibly determine what is going on.