ElementSecurityPut - Not recognising Group created in BI

Post Reply
ViRa
Regular Participant
Posts: 155
Joined: Tue May 14, 2013 1:53 pm
OLAP Product: Cognos BI, TM1
Version: 9.5.2 - 10.1.1
Excel Version: Excel 2003

ElementSecurityPut - Not recognising Group created in BI

Post by ViRa »

Hi all,

The data server I'm working on has integrated security mode 5 and hence the user groups are the ones created in BI. I have such group with its CAM namespace name\groupname. When I add this group name (with or without the CAM namespace) in the argument list for ElementSecurityPut function in Metadata tab, I get the error saying the group is not found.

I've enabled the 'Security Access' for the process and have set the process rights to Read for the Group. I'm stuck at this error which is not letting me try the ElementSecurityPut().

Can somebody please assist me on what I'm missing?
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: ElementSecurityPut - Not recognising Group created in BI

Post by tomok »

ViRa wrote:When I add this group name (with or without the CAM namespace) in the argument list for ElementSecurityPut function in Metadata tab, I get the error saying the group is not found.
Whatever possessed you to put a function that writes data to a cube on the Metadata tab?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
ViRa
Regular Participant
Posts: 155
Joined: Tue May 14, 2013 1:53 pm
OLAP Product: Cognos BI, TM1
Version: 9.5.2 - 10.1.1
Excel Version: Excel 2003

Re: ElementSecurityPut - Not recognising Group created in BI

Post by ViRa »

Ok, my bad. I tried in Epilog and Data tabs too; the group is still not found. I tried adding the CellPutS function for the control cube in a separate TI process and the group was recognized in that TI process. Just want to know why the same is not being found in the regular cube.
jacobtis
Posts: 1
Joined: Mon Sep 09, 2013 8:20 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: ElementSecurityPut - Not recognising Group created in BI

Post by jacobtis »

Hi,

I had the same issue but solved it by writing the code like this:

Code: Select all

ElementSecurityPut('Write','Project','ProjectCode','CAMID("::Everyone")'); 
This sets Write access for all my project codes in the project dimension to group Everyone. The code is on the data tab.

I checked what the group name was in the }Groups dimension and copied the name into my TI-process.
ViRa
Regular Participant
Posts: 155
Joined: Tue May 14, 2013 1:53 pm
OLAP Product: Cognos BI, TM1
Version: 9.5.2 - 10.1.1
Excel Version: Excel 2003

Re: ElementSecurityPut - Not recognising Group created in BI

Post by ViRa »

Thanks a lot Jacobtis!! This really helped...! I was entering the alias group name and hence was not being recognized. As per your suggestion, I copied the group name the }Groups dimension and the function works now.

Thanks again.
Post Reply