Range of Periods in OLAP Cube

[fishpig]

I have a periods dimension in my cube but the users would like to choose a range of data between two user defined periods. Would I need to set up two period dimensions one for start date and one for end date, or am I coming at this from the wrong angle??

 

[justins57]

Does the periods dimension have a day date as the lowest level in the dimension? If so, you use these dates in your query something like this:

SET DateSet As '[Periods].[01/01/2005]:[Periods].[01/31/2005]'

Then aggregate the DateSet to a MEMBER and stick it in your WHERE clause. Or use the DateSet in your columns or rows.

hth,

Justin