TM1 security Group import Issue

Post Reply
Avinash.Tm1
Posts: 3
Joined: Mon May 30, 2016 7:52 am
OLAP Product: Cognos Tm1
Version: 10.2.2
Excel Version: 2010

TM1 security Group import Issue

Post by Avinash.Tm1 »

We have cognos 10.2.2 environment for Cognos BI and Tm1.
We have Tm1 security being imported from Cognos BI. So far Everything is running smooth.
Recently we had to create few new groups to be imported to Tm1,while importing these new groups to TM1 it is throwing an error saying "Error adding the group".
But the group is getting added to the Tm1,But in the clientgroups cube it doesnot show the group's display name instead it shows CAM Id.

If u need any more info please ask.

Can anyone help me on this?

Thank you.
User avatar
Elessar
Community Contributor
Posts: 413
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: TM1 security Group import Issue

Post by Elessar »

Hello!

I think you have different groups in different folders with one name. The CAMID in TM1 does contain the folder, but the alias "}TM1_Display_Value" (looks like "Cognos\GroupName" does not. TM1 tries to give one alias to different groups and throws the error.
The group names must be unique if you want to import them in TM1.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
Avinash.Tm1
Posts: 3
Joined: Mon May 30, 2016 7:52 am
OLAP Product: Cognos Tm1
Version: 10.2.2
Excel Version: 2010

Re: TM1 security Group import Issue

Post by Avinash.Tm1 »

Thanks for your reply Elessar.

Yes we have 2 folders for groups.
But at first few of the group names are same in both the folders,but later we have renamed the groups with unique names.
We renamed the groups once we faced the error while importing the first group.
We are still facing the issue even after having the unique names.
Please find the attachments.

Thank you.
Tm1 security  Groups
Tm1 security Groups
Capture.PNG (10.57 KiB) Viewed 4050 times
Chandugade
Posts: 4
Joined: Mon Jul 13, 2015 10:39 am
OLAP Product: TM1
Version: 10.2.0
Excel Version: 2013

Re: TM1 security Group import Issue

Post by Chandugade »

I try to give few solutions, try your luck it may work:

Sol1: Please check the rules once again, if there are any invalid rules we get this kind of issues.

Sol2: change security mode in tm1s.cfg from 5 to 1, restart TM1 services, add two new groups in Architect, go back to security mode 5, restart TM1 Services and then add additional new groups as normal.

Sol3: set GroupCreationLimit to a higher value in tm1s.cfg file.

Hope it may help you.

Cheers..
User avatar
Elessar
Community Contributor
Posts: 413
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: TM1 security Group import Issue

Post by Elessar »

Chandugade, Yes! 99% Sol1 is the reason. If you have a rule with error in "}Cube/Element/Dimensionsecurity" cube, TM1 will not let you add new groups.

Try to import a group, get the erorr and look into Message Log (tm1server.log). It will tell you which rule is corrupted.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
Avinash.Tm1
Posts: 3
Joined: Mon May 30, 2016 7:52 am
OLAP Product: Cognos Tm1
Version: 10.2.2
Excel Version: 2010

Re: TM1 security Group import Issue

Post by Avinash.Tm1 »

Thanks for your replies.

As Chandugade said there is an issue with few of our rule files.

When imported the groups by disabling the rule files, the groups got imported smoothly without any error.
Post Reply