RemoveClientFromGroup - All ?

Post Reply
User avatar
yyi
Community Contributor
Posts: 122
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

RemoveClientFromGroup - All ?

Post by yyi »

Hi All, Is there a way to do this cleanly in one go rather than
inspecting each group per client with any changes :?:

Since there is always more removal than assigning to do, so
to assign after 1st removing all..


Thanks
Yeon
lotsaram
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: RemoveClientFromGroup - All ?

Post by lotsaram »

If you are using RemoveClientFromGroup then you are already in TI, ... and then surely if there is a need to remove the client from ALL groups then it is just a matter of an extra 4 or 5 total lines of code to do a while loop through the }Groups dimension? (maybe an extra line or 2 to accommodate testing and error handling). Development time effort measured in minutes not hours.

As for processing time to action, even for a mammoth }Groups dimension this is going to be something that TI handles in hundredths of a second.
User avatar
yyi
Community Contributor
Posts: 122
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: RemoveClientFromGroup - All ?

Post by yyi »

Just realised a quick method;

Code: Select all

ViewZeroOut('}ClientGroups', 'All_Groups');
This should work fine in prolog I'm thinking..
Yeon
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: RemoveClientFromGroup - All ?

Post by jim wood »

This shouldn't work as it will try to remove the admin clients as well. When I tried this the server crashed and I had to rebuild the security control cubes. The way I did was to create a client excluding the admin users and use that as data source for element deletion,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: RemoveClientFromGroup - All ?

Post by tomok »

jim wood wrote:This shouldn't work as it will try to remove the admin clients as well. When I tried this the server crashed and I had to rebuild the security control cubes. The way I did was to create a client excluding the admin users and use that as data source for element deletion,
Jim.
Jim, he's not deleting clients or groups, just removing clients from groups. Since this is nothing more than string data in a cube, I don't know why it wouldn't work. It's worth a quick test.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: RemoveClientFromGroup - All ?

Post by jim wood »

Ah good call. It's the day after the night before........
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: RemoveClientFromGroup - All ?

Post by qml »

Still, attempting to remove Admin user from Admin group might cause issues, but I've never tested it myself.
Kamil Arendt
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: RemoveClientFromGroup - All ?

Post by tomok »

qml wrote:Still, attempting to remove Admin user from Admin group might cause issues, but I've never tested it myself.
I've tried it before and you can't, it's hard-coded into TM1 somehow. Imagine the nightmare if you could so easily remove it. :!:
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: RemoveClientFromGroup - All ?

Post by qml »

I know you can't actually do it, that's why I said "attempt", but as history teaches there is a non-zero chance of a similar (i.e. not foreseen by the development team) attempt ending in a server crash.
Kamil Arendt
Post Reply