Hello,
Is it possible to copy sufficient files from one TM1 server to another so as to enable a user to be able to log in to both servers independently but using the same user name and password.
I have one cube server that contains headcount and salary information to which I need to provide restricted access to people who are admin in our main server. What I wondered was can I copy sufficient client files from the main server to the headcount server each morning so that the passwords remain in synch?
Thanks for any help you may be able to provide.
Copy clients & passwords
-
- Community Contributor
- Posts: 103
- Joined: Mon Sep 05, 2011 11:04 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: Copy clients & passwords
Hi,
If it's just the passwords that need copying over, then just the }Clientproperties.cub would do it.
If you need to copy over new users, then }Clients.dim
new group - }Groups.dim
and for user group assignments - }ClientGroups.cub
If it's just the passwords that need copying over, then just the }Clientproperties.cub would do it.
If you need to copy over new users, then }Clients.dim
new group - }Groups.dim
and for user group assignments - }ClientGroups.cub
-
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: Copy clients & passwords
Brilliant, thank you.
-
- MVP
- Posts: 2836
- 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: Copy clients & passwords
You need to make sure 1) it's a one-way copy only and 2) you do all your user maintenance (and this also means users changing their passwords) on the main server only.
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Copy clients & passwords
Do you plan to copy the client properties cube wholesale or just export selective content? be aware that the encrypted password values in the client properties cube can contain non-printable break characters that aren't handled at all well within TI variables and depending on version can reliably crash the server on export or import if such values are encountered (which is entirely random as it all depends what passwords users have set.)
You say you're using CAM so simple integrated login is out, but wouldn't you be better served linking CAM to LDAP and having all passwords centrally managed in one place rather than the work-around setup you're proposing?
You say you're using CAM so simple integrated login is out, but wouldn't you be better served linking CAM to LDAP and having all passwords centrally managed in one place rather than the work-around setup you're proposing?
-
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: Copy clients & passwords
I would prefer to use integrated security but unforetunately we dont have a very joined up network yet so its not really practical at the moment.
Copying the }Clientproperties.cub & }Clients.dim as suggested seems to be doing the trick.
Copying the }Clientproperties.cub & }Clients.dim as suggested seems to be doing the trick.