Date Range selection in Tree propmt

[Kalyan cognoise]

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

[mallikarjuna]

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')+']'#