TM1 Forum

I know it's possible, but I can't remember/find how to test to see if a cell is open for writing. Specifically, I need to test to see if a rule applies before trying to CellPutN to avoid process errors. Anyone remember or have a pointer to the docs (optimist, I know)?

Thanks,
Matt

Hi Matt,

You're looking for CellIsUpdateable(Cube, e1, e2 [,...en]);
Have a look in the reference guide under Turbo Integrator functions.

Michel

Hi Matt,

You are looking for CELLISUPDATEABLE(cube, d1, d2[, ...]) - it will return 0 if either the cell in question is rule calculated or not a leaf, otherwise 1. Unfortunately TI doesn't provide ISLEAF (which is available in rules), but you can check the level of each and every dimensions's element of your cell.
However, if the element of the last dimension in the cube is a string, the cell will be updateable and not every element has to be a leaf.
(This will work from 9.0 to 9.1.4, and if you feel lucky you can try it on 9.4, but don't come to me crying after you hurt yourself doing so )

Lukas

PS: too slow curse you keyboard, its all your fault!

Awesome, thanks to you both. The manual can be less than searchable (as we all know)... but the hive-mind always comes through for me

Matt