New security groups in TM1 on cloud

Post Reply
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

New security groups in TM1 on cloud

Post by Wim Gielis »

Hello all,

A TM1 model is transferred to IBM cloud with their offering. We log in with an IBM ID. IntegratedSecurityMode = 5.
If we want to extend the security groups, how do we do this ?
01.png
01.png (23.99 KiB) Viewed 3573 times
Thanks in advance !

Best regards,

Wim
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
tomok
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: New security groups in TM1 on cloud

Post by tomok »

We are cloud customers but we have all local groups that we copied over from our on-premise server. At the time we migrated (Sep 2019), you could not link up your AD groups with PA on the cloud so we stayed with local groups. When we want to create a new group we have a TI process that creates a local one for us and then we assign users to it. I don't know if you can synch up your AD groups with PA now yet or not. I've been too busy with other stuff to investigate.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
gtonkin
MVP
Posts: 1261
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: New security groups in TM1 on cloud

Post by gtonkin »

We do exactly what Tom describes and was told to do this by IBM i.e. use TI to add Groups. You can still allocate the traditional way or via TI though.
BR, George.

Learn something new: MDX Views
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: New security groups in TM1 on cloud

Post by Wim Gielis »

Thank you Tom, George. I'll go with the TI function.

Alternatively, I could change the IntegratedSecurityMode to 1 since we still have a regular admin user for the model that is going to the remote server.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
burnstripe
Regular Participant
Posts: 227
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: New security groups in TM1 on cloud

Post by burnstripe »

I'm pretty sure you can create groups from within paw/workspace. If I recall open a view on the control object }clientgroups scroll to the end of your groups and hopefully should see a little + symbol, click on this and add your group name.

If it's not here have right click on cubes and view the security properties and have a look for the + symbol on groups

Sorry can't be more specific, not got access to an environment this minute
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: New security groups in TM1 on cloud

Post by Wim Gielis »

Thanks, I will also have a look at it when I can. There is no model yet in PAW, only testing in TM1 Architect.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: New security groups in TM1 on cloud

Post by Wim Gielis »

burnstripe wrote: Mon Feb 01, 2021 10:24 pm I'm pretty sure you can create groups from within paw/workspace. If I recall open a view on the control object }clientgroups scroll to the end of your groups and hopefully should see a little + symbol, click on this and add your group name.

If it's not here have right click on cubes and view the security properties and have a look for the + symbol on groups

Sorry can't be more specific, not got access to an environment this minute
Hi,

With a view on the }ClientGroups cube, I could not find it but I found it when editing the cube settings. For security you can add a new group:
01.png
01.png (19.55 KiB) Viewed 3500 times
This is in a cloud environment that was set up by IBM last week, so very recent.

Thanks a lot.
Last edited by Wim Gielis on Tue Feb 02, 2021 1:45 pm, edited 1 time in total.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
User avatar
gtonkin
MVP
Posts: 1261
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: New security groups in TM1 on cloud

Post by gtonkin »

HI Wim,

Burnstripe is correct, you can click on the "meatballs" menu next to Cubes, Edit Settings.
The widget added to the canvas will have Cube Security on columns and you will see a plus sign (Create user group) on the right below the security shield, next to the bin.
BR, George.

Learn something new: MDX Views
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: New security groups in TM1 on cloud

Post by Wim Gielis »

Thanks George, I also found it now, based on the explanations ! I was editing my previous post to reflect this information.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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