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.