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.
Error: Data procedure line (52): Rule applies to cell
-
- Posts: 13
- Joined: Wed Dec 07, 2011 4:18 pm
- OLAP Product: cognos tm1
- Version: 9.5.2
- Excel Version: 2007
-
- 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
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.
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.
- 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
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
Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.