TM1 Forum

Hello All,

I have a scenario, where a user should not enter a value in the dimension through a active form.

Is it possible through a rule.

Thank you in advance.

Usually I would think of the regular security (cube, element, cell level).
Or is it 1 particular active form that you want to secure in a websheet ? In that case, right-click the application (websheet) in the Server Explorer and in the context menu properties you can indicate that write back to to the websheet is not allowed. By default is is allowed.

Hello,
Actually i have a scenario like a word should not enter into the activeform, which will store in the dimension as well.

This is as clear as mud, sorry.
I *guess* you mean element security, but that is as best as anyone else's guess.

Hello Wim,

Sorry for my explaination.

Actually i have a scenario like, users should not enter a value ABC in the tm1 web sheet(from this sheet the entered values will be stored in the dimension) except ABC all other values are allowed. Now the thing us i want to restrict only ABC word entering from websheet.

Is this possible with a rule or any other possibilities.

So you have a text field that users can enter text in but there is one specific text string that no one should be allowed to enter???? That is quite a bizzare requirement and not surprisingly, IBM does not give you the capability to do that in an active form. The only way to restrict text input to specific items is through a picklist but what you are asking for is an anti-picklist.

I would then assume some kind of TI process capturing the data input, and maintaining / updating the target dimension.
Exclude the specified value in the Metadata tab of the process with an Itemskip for example.

Or, use different measures. An input measure for the users, and a validated measure where the ABC value is not allowed and circumvented.

Indeed, bizarre requirement.

In excel you can do it with data validation.

Set a named range of text you don’t want to be allowed.
Set data validation as custom on the dbrw cells you want restricted and put something like below: Where ForbiddenList is the named range of banned strings (if it’s only 1 string you want to avoid then you can just put that as plain text directly in the formula) and B10 is the first cell of the range that you apply the validation to.

I don’t think this will work if the excel sheet is viewed through TM1 Web though, it’s been a while since I’ve played about with data validation and tm1 web but I remember it being quite limited. If that’s the case maybe someone else will be able to spend some time tweaking the logic.

Alternatives in the formula approach of Declan:

=COUNTIF( ForbiddenList, B10 ) = 0

Or use a more TM1-like way of validating the input:

=DIMIX( ADimWithForbiddenList, B10 ) = 0

Something along these lines could be worked out.

Thank you for your feedback.

Is their any way to restrict a value not to enter the dimension using rule/Ti process.

spartan wrote: ↑Tue Mar 26, 2019 11:56 amIs their any way to restrict a value not to enter the dimension using rule/Ti process.

Did you read the first 2 lines of this post:
https://www.tm1forum.com/viewtopic.php? ... 125#p72114