TM1 Forum

Hello, TM1 expert,

I'm a beginner of Cognos TM1. I'm now trying to use TM1 Java API and had the subject question.
When I tried to call TM1Cube.setCellValue() against a consolidated cell, I got an error message ObjectSecurityNoWriteRights although I expected another error such as UpdateNonLeafCellValueFailed. Why I got ObjectSecurityNoWriteRights? Can I overwrite a consolidated cell by setting such a write right?

Regards,
Isao

In TM1 the oly way you can overwrite a consolidated value is with a rule. as for the error message you're getting I'm no API expert but I'm sure the likes of Alan will be able to help you out with that,

Jim.

Hi, Jim,

Thank you very much for your comment!

Regards,
Isao

You could do data spreading to the leaf elements below that consolidation.

Good point Gabor. That's one way round it. Once you start opening up the children there's a fe wspreading options and some others as well.

Hi, Jim & Gabor,
Thank you for your suggestions.
Regarding my question about ObjectSecurityNoWriteRights, I confirmed TM1Cube.setCellValue() returns the same error when calling it against a calculated cell as well as a consolidated cell.

Regards,
Isao