Hi
Am USING Cognos security, Users will be added from cognos and a some user groups from cognos.
As i need a dimension which will be same elements as users ,i have created a TI process which will add group name into my GRP Dimension which am using in Cube.
Example : Client added is CognosAD\Marry and i will have element "Marry" in my GRP Dim and so on.....
ISSUE
I need to Identify CAM id As who logged in and need to show only element on his name.
Example: If CognosAS\Marry Logged in Cube must filter GRP Dimension element to "Marry"
Need advice on this how i can filter or apply security for Hiding other elements for marry??? in cube...
Thank you
Identify User Logged and Filter an element
- vinnusea
- Posts: 116
- Joined: Thu Sep 23, 2010 6:12 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- Location: San Diego ,CA
Identify User Logged and Filter an element
Thanks
Vinnusea
Vinnusea
-
- Posts: 40
- Joined: Fri Jan 29, 2010 1:55 am
- OLAP Product: Cognos TM1
- Version: 9.5
- Excel Version: 2007
- Contact:
Re: Identify User Logged and Filter an element
if i'm not wrong CAM security create CAMID as element and having an alias for username, by knowing that you can filter based on name or create element security
marry only read marry element
marry only read marry element
- vinnusea
- Posts: 116
- Joined: Thu Sep 23, 2010 6:12 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- Location: San Diego ,CA
Re: Identify User Logged and Filter an element
Yes i was also thinking the same to use }Clients in my Cube ,but if i use }Clients in my cube i will not be able to create Cell Security cube for this ..
So i need to build a dimension -Clients which is exactly similar to }Clients. And Dynamically Update this Clients.
Other idea was, if any body logs in can i able to capture his CAM ID and pass that name to any dummy cube?? if that is possible then i can write a rule saying if attribute of CAM id matches the name in Clients Dimension then show only that element.. Something like that.....
Please give me your idea how can i do it??
Thank you
So i need to build a dimension -Clients which is exactly similar to }Clients. And Dynamically Update this Clients.
Other idea was, if any body logs in can i able to capture his CAM ID and pass that name to any dummy cube?? if that is possible then i can write a rule saying if attribute of CAM id matches the name in Clients Dimension then show only that element.. Something like that.....
Please give me your idea how can i do it??
Thank you
Thanks
Vinnusea
Vinnusea
-
- MVP
- Posts: 195
- Joined: Wed Jul 22, 2009 10:35 pm
- OLAP Product: TM1
- Version: 9.5.2 FP3
- Excel Version: 2010
Re: Identify User Logged and Filter an element
Maybe this: http://forums.olapforums.com/viewtopic. ... bset#p4443
and this: http://forums.olapforums.com/viewtopic. ... bset#p4477
will help (both links refer to the same thread, just different replies).
and this: http://forums.olapforums.com/viewtopic. ... bset#p4477
will help (both links refer to the same thread, just different replies).