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
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
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.
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.