TM1Cube.setCellValue against a consolidated cell

[isakk3]

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

[jim wood]

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.

[isakk3]

Hi, Jim,

Thank you very much for your comment!

Regards,
Isao

[Gabor]

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

[jim wood]

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.

[isakk3]

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