Identify User Logged and Filter an element

Post Reply
User avatar
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

Post by vinnusea »

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
Thanks
Vinnusea
olapuser
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

Post by olapuser »

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
User avatar
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

Post by vinnusea »

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
Thanks
Vinnusea
jstrygner
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

Post by jstrygner »

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).
Post Reply