TM1 Forum

Hi all,

Is there any way to set min value for cell?

Thanks

Have you tried the Validation feature of Excel?

BradfordElaine wrote:Hi all,

Is there any way to set min value for cell?

Peter's given you one way, but you need to be aware that it will only work if the entry mode is Excel. (In addition to which data validation is tissue-paper weak, and can be obliterated by simply pasting a value over the top of the cell which had validation on it.) It won't limit what users can enter directly into the cube via, say, Cube Viewer. (Or even a home-grown DBS formula.)

Within a TM1 cube itself, however, there is no way to limit the value range of an entry into a cell. It's not like an RDBMS where you can put constraints on a field. The only way that you can do it indirectly... and in most cases this isn't worth the effort... is to have two cells, an input cell, and a rules-calculated cell which is used for reporting. In the latter, you could have the rule be (say) If (Input Cell Value <0, 0, Input Cell Value). It would be rare for that to be worth the effort, though.

Hi all,

Thanks for your reply..
Hope in the future, in the newer version, there is a built in function to validate the data..
Sigh.. need to find a reason to push the user to use Excel instead

but thanks everyone! =)

There is the picklist option, but it will only work with a discrete set of data (e.g. "1-10", but not "greater than 0"). You also need to be on 9.5.1 (I think) or higher.

If it's of interest take a look in the Developer Guide.

Martin