Hi everybody,

I was wondering how to integrate intervals (to be used within a star schema / OLAP Cube):

I got several rows looking like:
o_id: integer (e.g. 202)
start: date (e.g. 2009/05/12)
end: date (e.g. 2009/12/24)
valueperday: integer (e.g. 1 package)
some_dimensions:
- fk_dim1key (e.g. 120)
- fk_dim2key (e.g. 130)
- fk_dim3key (e.g. 1)

I would like to integrate the data so that I can set up a cube, looking like:

dimensions:
the "some_dimensions" + a "time dimension" (day -> month -> year)
measures:
valueperday (sum)

So my first idea is to integrate the data, so that there will be a row for each day (for the example values):

day: 2009/05/12
value: 1
dim1key: 120
dim2key: 130
dim3key: 1

day: 2009/05/13
value: 1
dim1key: 120
dim2key: 130
dim3key: 1

...

day: 2009/12/24
value: 1
dim1key: 120
dim2key: 130
dim3key: 1

so for one row (of the operational system) I would have 227 rows (in the warehouse) concerning the example. Any other ideas?

Thanks a lot!