Query interval based on input date user

[dwainchang]

Hi all,
In my cube I have a base date and in my query I ask the user to submit an end date.
In my query I want to create intervals , for example, interval 1 : days 0 - 30, interval 2 days 31 - 60
I calculate the number of days between base end user input .
Does anyone know how I can use this number to restrict my intervals..
for example is the number of days between begin and end date is 45, my characteristic should be restricted an appear in interval 2

gr,
dwain

[Gothmog]

Moved from Financials.