COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: HalfBloodPrince on 02 Jul 2013 08:59:01 AM

Title: show available hours for all the dates
Post by: HalfBloodPrince on 02 Jul 2013 08:59:01 AM
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