How to restrict a user not to enter a value in the active form
-
- 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
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.
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.
-
- MVP
- Posts: 3113
- 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
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.
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
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
-
- 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
Hello,
Actually i have a scenario like a word should not enter into the activeform, which will store in the dimension as well.
Actually i have a scenario like a word should not enter into the activeform, which will store in the dimension as well.
-
- MVP
- Posts: 3113
- 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
This is as clear as mud, sorry.
I *guess* you mean element security, but that is as best as anyone else's guess.
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
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
-
- 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
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.
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.
-
- 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
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.
-
- MVP
- Posts: 3113
- 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
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.
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
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
-
- 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
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.
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
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
-
- MVP
- Posts: 3113
- 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
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.
=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
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
-
- 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
Thank you for your feedback.
Is their any way to restrict a value not to enter the dimension using rule/Ti process.
Is their any way to restrict a value not to enter the dimension using rule/Ti process.
-
- MVP
- Posts: 3113
- 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
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
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