Page 1 of 1

Identify User Logged and Filter an element

Posted: Thu Nov 18, 2010 9:47 pm
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

Re: Identify User Logged and Filter an element

Posted: Fri Nov 19, 2010 1:52 am
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

Re: Identify User Logged and Filter an element

Posted: Fri Nov 19, 2010 3:17 am
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

Re: Identify User Logged and Filter an element

Posted: Fri Nov 19, 2010 10:25 am
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).