COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: dssd on 25 Sep 2013 12:52:27 PM

Title: Security
Post by: dssd on 25 Sep 2013 12:52:27 PM
Transformer cube security through Custom Views is thought to be high maintance...I was wondering why is it so??
Title: Re: Security
Post by: Grim on 26 Sep 2013 02:34:09 PM
It's not so bad. Just a pain if you're too granular in your security (IE. Not using groups). Also a pain if you change security providers.

Title: Re: Security
Post by: smadanek on 25 Nov 2013 01:49:08 PM
After many years away from Transformer cubes I have a small project to build a cube that requires security by one of the dimensions (organizational) with 5 levels.  I can not get the security filters to apply in the resulting MDC.  I am looking for what I am missing to make this work. 

The BI version is 10.1.0 FP1 running on windows 2003 server.  I have many woorking reporting applications using Framework Security filters in this environment.  We are using Access Manager 7.4 still running on an old SunOne LDAP.

I set up the cube views, related them to Access Manager Classes, and then set the 12 parent catagories as Apex.

I set my own permissions on the user classes I am using were limited to 3 user classes out of the 12 so I should only see the three catagories I have permission for.

But it does not work.  When I open the cube in (10.1.0 FP1) Analysis Studio I see and can navigate all catagories of all the levels of all of the organizational dimension which is the security dimension.

Thanks for any advice.
Title: Re: Security
Post by: MFGF on 13 Dec 2013 09:23:54 AM
Did you remember to drag the custom views onto your cube before building it? I almost always forget that last step! :)

MF.