filiter the data based on condition

[reddy_143]

Please help me to develop report'

1) On the below attachment (its not a true report but I need it like that) I need to have Units as 0 if Age Hours of particular is not available in Data base. In this screen shot we can see that but in my report I cant i.e

I am getting Age hours (0-12)- Units 37890 and for 12-24 Units 9708 but for other Age hours (24-48……48+) I am not seeing this buckets in my report so I need to see all Age hours irrespective of units if we have units value in the database, we get that value other wise I need to display 0 for respective bucket.

2) How can we maintain  version control in cognos ? is there any way do I need to follow for back of reports?

[blom0344]

1. Use a CASE construction or an 'if then else'  if you feel more comfortable with this..

But what do you mean with ' IF SKU_ID is in IMMD_NEED' ?



2. You can only create missing values for a group like Age Hours if you use an outer join with a reference table (which will return every key, even if you have no related fact data for that value)