Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Kalyan cognoise on 05 Nov 2009 05:33:13 AM

Title: Date Range selection in Tree propmt
Post by: Kalyan cognoise on 05 Nov 2009 05:33:13 AM
Hi All,

I am new to Dimensional functions.I have an issue with Dates(Tree prompt).Actually I am having Hierarchy like..

                    + Dates
                        + Year
                            +2007
                               +QTR 1 2007
                                  +Jan 2007....

Suppose If User selects QTR 1 2007 and QTR 3 2007 , the data is showing for only two quarters but my user wants to see three qtrs means qtr1,qtr2, qtr3 (i.e.,from date-to date) or Suppose if user selected 2007 and 2009 the data has to display for 2007,2008,2009.
Is there anyway to achieve this.Please suggest me.This is urgent.

Thanks in advance,
Kalyan
Title: Re: Date Range selection in Tree propmt
Post by: mallikarjuna on 05 Nov 2009 05:59:11 AM
hi kalyan i am using the same scenario but for text box prompts the user will enter two date ranges.he will get the data for the range.

   use the follwingcode:                    [Calendar day] between
#'[Business Layer].[Calendar day].[Calendar day].[Calendar day]->:[BW].[0CALDAY].['+prompt('Calendar day','token')+']'#
and
#'[Business Layer].[Calendar day].[Calendar day].[Calendar day]->:[BW].[0CALDAY].['+prompt('to day','token')+']'#


Text only | Text with Images