Unable to upload .CSV file in TM1

[BilalSuleman2019]

Hi All,

While I am trying to upload .csv file, I am getting following error message.


"Data Source line (2) Error: Data procedure line (317): Rule applies to cell"

As far I have checked, there is no rule for the cells in which I am trying to upload data.

Can anyone help?

Thanks & Best Regards

Bilal

[ascheevel]

I would say check again. Check row 2 of your source file and work through the logic of your TI to see where exactly in the cube it's trying to write. You could use LogOutput to export the values used in your CellPut statement when it encounters a rule cell. You should also make sure there aren't any locks on dimension elements you're trying to write to. A lock will prevent even an admin, often for good reason, from updating a value. I can't remember what the log will say when you try to write to a locked dim element via TI, so that might not be the case here.


example of LogOutput when CellIsUpdateable unexpectedly returns 0; look in the log for details after the TI executes:

Code: Select all

# assume you had a CellPutN that looked like this: CellPutN(vValue, vCube, vDim1Val, vDim2Val, vDim3Val);

IF(CellIsUpdateable(vCube, vDim1Val, vDim2Val, vDim3Val) = 0);
	LogOutput('ERROR', vDim1Val |', ' vDim2Val | ', ' | vDim3Val);
	ItemReject;
ELSE;
	CellPutN(vValue, vCube, vDim1Val, vDim2Val, vDim3Val);
ENDIF;