TM1 Forum

Hi All,

I cancelled the pick list rule in one of the elements (date) and now this intersection is not restricted by list - I cancelled it because it takes time to refresh the list evertime, however I want to restrict it (not by list), if a user will insert wrong value I want him to get an error message, is it possible?

Thanks,

Yes, it is possible. With a picklist!

Picklists do not have to be rule-based, you can just generate and load the picklist formulas using TI or manually. That can improve their performance somewhat.

That being said, picklists, especially ones with many items, can be quite slow when used in the Cube Viewer. They seem to work much faster in Excel, so maybe this is the interface you should be offering to your users.

With so little information it's really hard to give you any more advice.

Thanks for your reply,
I will explain myself again..
when you allocating pick list to some intersection it can takes a long time to open the list if there are lots of members inside (the picklist is period dimension, there are hundrands of elements in this dimension),
the strength of the picklist is the capability to restrict values in the cell, I want to restrict the values in the cell without using the picklist

You can look at Excel in-cell validation (a few assumptions made here).

Another option is to have a separate rule-calulated measure that would show if the input value is correct (meets criteria). This wouldn't block data input per se, but it could surely flag an "error" to the user.

Again, with so little information provided, it is hard to propose something more concrete. You're not even specifying which interface for data input you have adopted.

thanks