We are creating cube using report as data source.
we have two dimension time and equipment. Equipment connect to time using fact.
if the equipment is used for 2 days in Jan it shows me available hours for 2 days refer to following out put
Equip 1 |Jan 1 2013 | 24
Equip 1 |Jan 2 2013| 24
It not shows any data for after 2 jan since there is no records after two. but i want the following output
Equip 1 |Jan 1 2013 | 24
Equip 1 |Jan 2 2013| 24
Equip 1 |Jan 3 2013 | 24
Equip 1 |Jan 4 2013| 24
Equip 1 |Jan 5 2013 | 24
Equip 1 |Jan 6 2013| 24
.
..
.
Equip 1 |Jan 31 2013| 24
pls help me out