How to restrict a user not to enter a value in the active form

Post Reply
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

How to restrict a user not to enter a value in the active form

Post by spartan »

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.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by Wim Gielis »

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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: How to restrict a user not to enter a value in the active form

Post by spartan »

Hello,
Actually i have a scenario like a word should not enter into the activeform, which will store in the dimension as well.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: How to restrict a user not to enter a value in the active form

Post by spartan »

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.
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by Wim Gielis »

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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by declanr »

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:

Code: Select all

=SumProduct(--ISNumber(Search(ForbiddenList,B10)))=0
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.
Declan Rodger
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by Wim Gielis »

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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: How to restrict a user not to enter a value in the active form

Post by spartan »

Thank you for your feedback.

Is their any way to restrict a value not to enter the dimension using rule/Ti process.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to restrict a user not to enter a value in the active form

Post by Wim Gielis »

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
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply