Page 1 of 1

9.5.1: Relative Proportional Spread Error

Posted: Thu Feb 17, 2011 12:15 pm
by harrytm1
hi all,

I have a Profit Loss cube with data populated into Year 2010 under Actual version. Actual Version is STET in the first line of the cube rules.

I tried to perform a Relative Proportional Spread from Year 2010 to 2011 for Actual version only. Hence, in the cube view, i right-clicked on Net Profit/Loss element at Full Year to spread. However, an error message appeared suggesting that there is a conflict with rule and nothing was spread in the end.

I scanned through all n-elements in the PL Account dimension and nothing is rule-calculated, which is due to the STET statement. To troubleshoot further, I even deleted the rule and spread again. The same error appeared again.

Anyone experienced such issue with spreading in 9.5.1? i don't recall having such issues in 9.4.1 as the same model was used in 9.4.1 and spreading was odne successfully.

Many thanks!

Re: 9.5.1: Relative Proportional Spread Error

Posted: Thu Feb 17, 2011 4:03 pm
by qml
Just a stab in the dark here, but maybe you are facing the problem of circular reference? TM1 would display the same error message (which does not help much!) if you tried to spread, say, a value from a parent to its child. Check if your reference element is not a parent of your target element.

Re: 9.5.1: Relative Proportional Spread Error

Posted: Wed Mar 07, 2012 2:40 pm
by AlastairFM
Is the error message "Spreading failed due to conflicts with rules" ?

If this is the case the following IBM article may be the solution:

http://www-01.ibm.com/support/docview.w ... wg21474015