Print Page - How we get the data between dates using time dimension(YTD)

Title: How we get the data between dates using time dimension(YTD)
Post by: Sreeni P on 19 Jan 2010 11:25:22 AM

Hi people,

How would we get the values between the dates of Time(YTD) dimension....

for example , i want show the data between Feb 24 to March 8, what is the procedure and how should we get that using any expression?

Title: Re: How we get the data between dates using time dimension(YTD)
Post by: Sreeni P on 20 Jan 2010 01:38:25 AM

Still looking for Solution....................is any body out there to explain this scenario ...........? ::)

Title: Re: How we get the data between dates using time dimension(YTD)
Post by: fshahul on 20 Jan 2010 02:18:29 AM

Use Date prompt to achieve that. Choose the operator "in_range" in Date prompt.

Thanks,
Fatima S.

Title: Re: How we get the data between dates using time dimension(YTD)
Post by: fshahul on 20 Jan 2010 02:51:22 AM

Also we can achieve that using filter
Eg: [transaction Date] between 2009-02-24 and 2009-03-08

Thanks,
Fatima S

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sreeni P on 19 Jan 2010 11:25:22 AM