9.5.1: Relative Proportional Spread Error
Posted: Thu Feb 17, 2011 12:15 pm
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!
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!