I have a client with a SecurityAdmin that needs to administer 9 TM1 instances across 3 servers.
Users login via intregrated login and come from three different domains.
To facilitate the multiple domains and username variants, we have attributes on the }Clients dimension.
I then use a rule to test if the SignOn and Domain attributes are non-blank then derive UniqueID based on the client/signon and domain.
This works well unless you are SecurityAdmin as you can add the user but cannot update the attributes due to the restrictions imposed on SecurityAdmin.
SecurityAdmin is able to run TI's either - whether or not Security Access is checked or not.
Creating and additional group with permissions to access client attributes or a custom cube which is then used to rule derive UniqueID also does not work as the privileges do not inherit/are limited.
I was considering a process that the user could execute outside of TM1 to do a TM1RunTi with credentials allowing update only of the relevant cube but this would obviously mean creating password files, TI's etc. etc.
I fully understand why security has been implemented like it has been but looking for some leeway to facilitate update of attributes.
Have I missed something?
Any ideas?
edit: forgot to mention that they use a domain ID e.g. WXYZ0123 as the Client name rather than a fully qualified name e.g. WXYZ0123@DOMAIN
SecurityAdmin - bending the rules
- mattgoff
- MVP
- Posts: 518
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: SecurityAdmin - bending the rules
We also use a rule to assemble the UniqueID field, but instead of an attribute we've added an element to the }ClientProperties dimension ("ClientDomain") which is joined with the TM1 username (which is the same as the non-qualified domain username) by a rule to make the UniqueID. We don't make use of the SecurityAdmin account, so I don't fully understand the restrictions, but perhaps this would not be blocked. You have to use TI to insert the element-- the GUI won't allow it.
If that cell is also not writeable to SecurityAdmin, could you move away from the rule-assembled UniqueID and enter it manually? I have to assume that field is directly accessible to SecurityAdmin.
As a last resort, is there a reason why you couldn't move to using fully-qualified usernames as your TM1 usernames?
If that cell is also not writeable to SecurityAdmin, could you move away from the rule-assembled UniqueID and enter it manually? I have to assume that field is directly accessible to SecurityAdmin.
As a last resort, is there a reason why you couldn't move to using fully-qualified usernames as your TM1 usernames?
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
- gtonkin
- MVP
- Posts: 1265
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: SecurityAdmin - bending the rules
Thank you for the suggestions.
I considered tweaking the system dimensions but reluctant as I am unsure of future upgrade impacts but definitely something to consider testing from at least a write-back point of view.
With regards to going to a fully qualified name, no other reasons come to mind other than the work involved trying to migrate I.e. Potentially create new users, rather than just "swapping alias", renaming user folders to retain subs, views etc. Definitely plausible.
I considered tweaking the system dimensions but reluctant as I am unsure of future upgrade impacts but definitely something to consider testing from at least a write-back point of view.
With regards to going to a fully qualified name, no other reasons come to mind other than the work involved trying to migrate I.e. Potentially create new users, rather than just "swapping alias", renaming user folders to retain subs, views etc. Definitely plausible.
- gtonkin
- MVP
- Posts: 1265
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: SecurityAdmin - bending the rules
Have implemented a solution per Matgoff's post i.e. add new measures to }ClientProperties.
SecurityAdmin can write directly to this cube without any need for processes etc. Have saved a view with what they need.
Will post back if I encounter anything untoward.
SecurityAdmin can write directly to this cube without any need for processes etc. Have saved a view with what they need.
Will post back if I encounter anything untoward.