MDX - Range of dates with 2 Time Dimensions

[davidagnew37]

Hi,

I have a Time Dimension which allows me to select a specific YEAR, or YEAR & QUARTER or YEAR & QUARTER & MONTH, or YEAR & QUARTER & MONTH & DAY.

Is there any way that I can have a range of dates?

Is it possible to have 2 time Dimensions for example which did the following:

a start: Year|Month for example (>= Year|Month )
.......and......
an end: Year|Month (<= Year|Month )

Thus I would be able to select a range of dates/months.

Do you know if this is possible to write this in the dimension?

Thanks,

David

 

[justins57]

Yes, you can have two time dimensions. I don't understand why you can't query a start and end date using the one dimension. Can you explain?