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

Post Reply
segunfunwaoluwa
Posts: 13
Joined: Wed Dec 07, 2011 4:18 pm
OLAP Product: cognos tm1
Version: 9.5.2
Excel Version: 2007

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

Post by segunfunwaoluwa »

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.
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Error: Data procedure line (52): Rule applies to cell

Post by Edward Stuart »

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.
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: Error: Data procedure line (52): Rule applies to cell

Post by mattgoff »

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
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
Post Reply