Zero Suppression - DividebyZero

[Sudha]

Hi All,
User does what Zeros to be Displayed
How to do Zero Suppression at Design Level, do I need to take care for both Measures as well as Dimensions.

Also I have a Calculated Measure like (A-B)/C
Do we need to hard code to take care of the Divide by Zero error like this at the IQD level IF (C=0) THEN (0) ELSE (A-B)/C

or the tool will take care of the DividebyZero error.

Please advice.
Thanks
Sudha

[Sudha]

Can anyone help me with how to suppress zero's.
I'm trying to build a cube which has Current Months Data which get refreshed on a Daily basis.

After I build the cube the problem is suppose if its April 10th 06 I get the rest of the days data from Apr 11th to Apr 30th with all zero's which makes sense <as they are future dates>.

But my questions is there a way to suppress all those unnecessary ZEROs at the design stage in Transformer itself.

Help is really appreciated.
Thx

[bobg4u]

On the IQD that creates the Time Dimension, add a filter to restrict data till 'current date'.
Taking care of divide by zero errors at the design stage will be a better idea,since the tool might not give good results.

[Draoued]

Change in all time levels the property to be "When needed".
So if by mistake you have a measure for the future it will pop-up.
But if all measures are Zeros, the future dates will not be included.

This topic should be in Transformer Section , I ll move it.