Default Value for a Tuple

[wyconian]

Hey guys

It's been awhile since I used transformer and OLAP, I'm a bit rusty  :D Can anyone help?

I've built a cube that has a 3 dims and a number of measures, I need to d a calculation based on some tuples, the calculation is basically VALUE(TUPLE([REVENUE],[AMOUNT])) / VALUE(TUPLE(OTHER ITEMS],[AMOUNT)) where other items is a hold all for a number of different tuples.

This works OK untill the value of one of the other items tuples is null.  Then I don't get any data coming back.  I'm thinking this is because report studio is trying to perform a calculation on a null value.  I've tried denulling the value of the tuple but RS don't like it.

Any ideas how I can either denull / decode etc the value of a tuple or set a default value for the tuple?  I've already set the measures in the cube to default to 0.

Thanks for the help :)

[Grim]

Change nulls to "0"?

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cogtr.8.4.0.doc/ug_cogtr_id6086SpecifyHowMissingValuesAppear.html