Cubeview Cell Range
I have an AIP (annual incentive plan) input form whose input range from 0 to 2. Can I create formatting rules to restrict users from entering any number beyond the mentioned range?
Forum Discussion
Henning
OneStream Employee
OneStream EmployeeHi, do you mean integer or decimal values?
For Integers, this is an easy solution:
E.g. in your columns, make those a Combo Box Cell Type and refer to a List Parameter.
This parameter can look like this:
And when you open your CV, only data can be entered that is part of the parameter (via drop down).
You can also make it more granular by adding a decimal, but that may not be very pleasant for the end users.
Otherwise, if they want to add decimals manually, just add your CV to a workflow step, followed by a confirmation step which checks if the entered data is within the allowed range.
There are more solutions out there, but the above are - IMHO - the easiest (least complex and no impact on performance).