Data Validation checks in TM1 same as EP??

[Nidhi]

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

[ardi]

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

For String Measures, you can use PickLists

[Nidhi]

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.

[jim wood]

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

[Nidhi]

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.

[jim wood]

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.