The cell writeback operation cannot update a cell to an infinity value

I have an SQL Server Analysis Services (2014 SP2) cube with writeback operation enabled. when I try using a weighted allocation in Excel what if analysis I get the error: The cell writeback operation cannot update a cell to an infinity value. what could be the problem?. so far the fix that Microsoft suggest can be found in [this link][1] however this seems like an issue that affected SQL Server 2012 which I believe the fix would have have been carried over to SQL server 2014 codebase. [1]: https://support.microsoft.com/en-us/help/2803911/fix-errors-in-cell-writeback-message-when-you-run-update-cube-statemen

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg commented · Nov 01, 2017 at 02:29 PM

@ntiyisorm Is it possible that the error is legitimate and has nothing to do with your error? The [Errors in cell writeback][1] fix was related to "***Unable to write back as the weight expression does not return a decimal value between 0 and 1***" error message. This is somewhat different from the error in question, which could be caused by bad data in the cube resulting in the attempt to divide by zero. Please check the data subjected to your weighted allocation formula. Or better still, modify it to handle the division by zero attempts. [1]: https://support.microsoft.com/en-us/help/2803911/fix-errors-in-cell-writeback-message-when-you-run-update-cube-statemen

0 ·