Transformer TR0190 arithmetic overflow error - URGENT

[Sidney786]

Hi,

I have an urgent issue with a cube build there are zeros in the calculated measures in my cube hence getting the above error. I would like a method to handle those zero's to display /0 when the cube is viewed.

Any suggestions?

Regards

Sid

 

[notadba]

Hi Sid,

Divide by zero can be handled in the cube - and you can choose the default display of them. In analysis studio Use "Settings", "Data Format" and this will allow you to change the display of most error types.

Hope that helps.

 

[Sidney786]

Hi, I am using series 7.1 and using powerplay transformer to generate my cube. The error is happening at build time. I have tried to remove measures one at a time .. still the error persists, tried clean house, looked at the precision of the decimal values etc.. still get the TR1901 error arithmetic overflow.

Anymore suggestions would be helpful.