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

Dynamic Columns through a time interval

Started by kaevne, 23 Jan 2009 03:30:38 PM

Previous topic - Next topic

kaevne

I have a report that prompts for a start date and end date.  In addition, the user can select a time increment, (Years, Months, Days, Weeks, Hours). 

I would like to create a table that creates columns starting from the start date, and increments each column based on the time increment until it hits the end date.

For example, for start date = 1/12/08 17:00, end date = 1/12/08 24:00, and time increment of Hours, it would look something like this:

1/12/08 17:00 | 1/12/08 18:00 | 1/12/08 19:00 |...............| 1/12/08 24:00 |


And for each column would be query calculations (all integers) based on each interval.

Is this possible with Cognos 8?  Or is this beyond the scope of what Cognos is capable of?  Should it instead be a chart?  I'm at a loss through the documentation and user guide as to how to do this.  Thanks for reading.