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

Date Range to show data for individual dates

Started by guchi, 14 Sep 2022 03:09:37 PM

Previous topic - Next topic

guchi

The report has a FROM and a TO prompt. (two separate prompts for the date range)
These parameters are based off of the following conditions (this is just FYI) -
[FIRSTDAYOFF] >=   ?FROM? and  [FIRSTDAYOFF]  <= ?TO?
OR
[BACKTOWORK] >=   ?FROM? and [BACKTOWORK] <?TO?
OR
[FIRSTDAYOFF]  <=?FROM? and [BACKTOWORK] > ?TO?


CURRENT STATE - When the report runs, its 1 crosstab with summarized data for the entire date range.

Next - In order to get the individual dates from the date range prompt, I'm using a stand-alone Calendar table out of Framework manager and enabling CROSS JOINS. When I run the report, all the dates from the date range are accurately shown!

But the rest of the crosstab still summarizes the data and just repeats for each day in the date range.

NOTE - When I run data for individual days i.e. FROM today and TO today, that's what I want to see for each individual day instead of summarized data for the entire date range.


FUTURE STATE - The idea is to display data for EACH DATE within the DATE RANGE. Instead, the data is summarized. i.e. If the date range is FROM 09-11 TO 09-14, then I should see 4 dates separated;

11th - data for just the 11th (as if I ran the report for date range FROM 09-11 TO 09-11)

12th - data for just the 12th
13th - data for just the 13th
14th - data for just the 14th


Any thoughts?

Thanks so much.

cognostechie

Cognos summarizes the data depending on the granularity specified in the Crosstab.

The crosstab seems not to have the Date in it so all you have to do is to add the Date column in rows or columns depending on how you want to see the data.