AddGroup for Active Directory Groups

Post Reply
tm123
Posts: 132
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

AddGroup for Active Directory Groups

Post by tm123 »

Hi,

We are using Security Mode=5, in a TM1 (Planning Analytics) model, and we need to automate the process of importing the Active Directory Groups in TM1. The issue I am facing is, that CAMID of Active Directory Groups is in a format CAMID("AD:g:cbfe2e706f26ef439470661399a7a8c3").

I have a CSV file with the list of Active Directory Group Names to be imported, but I don't have their respective CAMIDs (or GUID), and the AddGroup TI function required the CAMID as argument, otherwise, the group created will be just a regular TM1 Group.

I was hoping there is a hidden feature / hidden function that can accept the Active Directory Display Name as argument

Thanks
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: AddGroup for Active Directory Groups

Post by macsir »

There is no easy way to grab CAMID unless you look at Cognos BI SDK to do it for you https://www.ibm.com/developerworks/data ... ge565.html.
If it is not massive, then manually copy them from cognos server.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply