TM1 Forum

Hi everyone,
I am getting this message "Error: Data procedure line (52): Rule applies to cell" for some of my users in my salary cube.I ran an update to staging TI for my employee and active positions,then ran a TI process to Dim_create salary position and employee.After the successful run of the above TI's,i then ran a data load salary TI which also ran fine.On checking the cube for the loaded scenario and version, most of my employee salaries loaded but got the above error message on those that didnt load.
Pointers anyone?
Thanks.
Segun.

Pointer (1): "Error: Data procedure line (52): Rule applies to cell"

Check the code on line 52 of your process

Pointer (2): What rules are applied on the cube you are updating

Open the cube to the data you are attempting to update, the grey cells are the one's you cannot update. If you Trace Calculation on one of these cells it will (at some point) refer to the Rule(s) on the cube.

Also, they just recently fixed a bug where you'd get this error even if you'd excluded rule-calculated cells in your view. The only options are to live with the error or test each cell to see if a rule applies with CellIsUpdateable before the CellPutN. We live with it rather than take the performance hit. Not sure if this is the case for you, but it's worth mentioning.

Matt