TM1 Forum

Hello!
I'm using the function CellPutSpreadProportional into a TurboIntegrator Process.
es. CellPutProportionalSpread( value, cube, e1, e2, e3...,en );

It works fine unless the value to spread is negative.

Is there a way to spread a negative value ? or I need to convert into positive (with abs function) for spreading and then set a cube's rule for multiplying by -1?

The error message generated is: "Spreading failed due to conflicts with rules"

I hope someone could help me.

Thank you very much
Claudio

You can't spread into a cell that has a rule associated with it. When you say "it works fine unless the spread is negative" did you try to the exact same spread, same cells, same area in the cube, using a positive number once and then a negative number the next time?

tm1_faster wrote:The error message generated is: "Spreading failed due to conflicts with rules"

What happens when you lower the required spreading precision by increasing the value of the parameter SpreadingPrecision in the TM1 server configuration file tm1s.cfg ?


See the IBM Technote 1474015:

https://www-304.ibm.com/support/docview ... wg21474015
A data spreading fails with the error message "Spreading failed due to conflicts with rules"

Technote (troubleshooting)

Problem(Abstract)
A data spreading may fail with the the english error message "Spreading failed due to conflicts with rules" or the german error message "Verteilung aufgrund von Ruleskonflikten fehlgeschlagen". Despite the error message pointing to a rules conflict, the cube may not have any rules at all. On some sites, the error message is triggered by a relative proportional spreading of negative values.

Cause
There is an error as a data spreading failed, but the wrong error message is returned:
Instead of the error message "Spreading failed due to conflicts with rules" an error message should be returned that the required spreading precision could not be meet.

Environment
TM1 Version 9.5.1

Resolving the problem
Lower the required spreading precision by increasing the value of the parameter SpreadingPrecision in the TM1 server configuration file tm1s.cfg:

The default value is SpreadingPrecision=1e-8
Increase that value to SpreadingPrecision=1e-2 and test again.
If the data spreading did succeed, start lowering that value, for instance to SpreadingPrecision=1e-4, and test again.