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?
ElementSecurityPut - Not recognising Group created in BI
-
- 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
Whatever possessed you to put a function that writes data to a cube on the Metadata tab?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.
-
- 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
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.
-
- 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
Hi,
I had the same issue but solved it by writing the code like this:
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.
I had the same issue but solved it by writing the code like this:
Code: Select all
ElementSecurityPut('Write','Project','ProjectCode','CAMID("::Everyone")');
I checked what the group name was in the }Groups dimension and copied the name into my TI-process.
-
- 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
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.
Thanks again.