Cubeview Cell Range

Hello Sahil,
I hope you're doing great.

I'm not sure the desired result is achievable via cell format or in the data explorer form of cubeviews.
However, assuming your CubeView is used within a workflow form, one effective way to achieve this would be to assign a spreadsheet to the form template instead of the CubeView itself. This spreadsheet should contain a CubeView connection pointing to the specific CubeView you want to use and have lists inserted in the cells you want to limit the input in.

Here’s a simple step-by-step approach:

1- Open a spreadsheet and create a CubeView connection to your CubeView.
2- Save the spreadsheet with the CubeView connection to a local folder on your computer.
3- Open the saved Excel file, and insert a list composed of the values 0, 1, and 2 in the specific cells where you want to restrict the input range.
4- Save the file again and assign it to the form template of your workflow.

Now, when users open the form in the workflow, they’ll see the spreadsheet interface. The cells where you inserted the list will enforce the input restriction : 

You can submit the number chosen from the list with no issues : 

And any user trying to enter a value outside the allowed range of the list will receive the following error message :

You’ll just need to instruct your users to go to the OneStream tab in the spreadsheet and click “Submit Sheet” once they’ve finalized their inputs, or another way would be to build a dashboard with a big save button to make it more obvious.

Hope this was helpful !
Hatim

Hi, 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).