TM1 Forum

Do we have data validation checks in TM1 same as EP or do we need to do some tweak in getting that. I mean is it straightforward or we have to apply rule function.
eg : Restrict the user to enter the input within range 0 and 9 or do we need to apply rule. if yes , can someone give me example how to implement the same.

Thanks
Nidhi

If you are using websheets you can apply Excel data Validation, which will work on TM1Web also.

For String Measures, you can use PickLists

Thanks for reply.By web sheet do you mean perspective (excel -addin) or TM1 Application (Contributor) . Can we apply same validation like excel in TM1 application once deployed on web.

You can build validation cubes and rules. Also if you're loading data from external sources you can build data validation TI processes.

Hi Jim, Can you help me in building validation in cubes it will be of great help. I am using TM1 10.2.2
My requirement is I have to restrict the user to input values with in range for eg between 0 and 1.

There are several methods to do so, but if you create a dimension with 3 elements: Entry, Validation and Final. (You can skip the Validation if you want.) Then create a lookup cube containing the lookup parameters. Then put a rule on validation to say what entry needs to be between. Finally have a rule on final that will only take entry if validation is passed.

By adding this dimension you can validate every measure / account with a seperate rule giving you the ability to validate everything as required.