If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

show available hours for all the dates

Started by HalfBloodPrince, 02 Jul 2013 08:59:01 AM

Previous topic - Next topic

HalfBloodPrince

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