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 :)
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