Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: ykud on 15 Mar 2007 08:23:35 AM

Title: Security with PowerCubes and Relational Data Sources in Cognos 8
Post by: ykud on 15 Mar 2007 08:23:35 AM
I have a PowerCube built on a relational table (on a subset).
Client wants to drill-through from Analysis Studio to relational table to get detailed data.
Question arises when model security is discussed.
Do I have to define security 2 times, once for PowerCube (in Transformer, using Cube Views, Apexing etc) and another time for relational table (in FrameWork Manager, using security filters)?
The filtered dimension (Managers) appears in both sources, so if I implement security only in PowerCube, user can still see forbidden data in QueryStudio,
Am I right about implementing security 2 times? Is there any other way?
Or maybe scripts to ease the process...

xpost: Cognos8
Title: Re: Security with PowerCubes and Relational Data Sources in Cognos 8
Post by: Darek on 04 Apr 2007 05:55:12 PM
There is no other way.
Title: Re: Security with PowerCubes and Relational Data Sources in Cognos 8
Post by: ykud on 05 Apr 2007 12:02:08 AM
I guess we'll write some vbs, synchronizing security in fm and transformer.
Title: Re: Security with PowerCubes and Relational Data Sources in Cognos 8
Post by: Darek on 05 Apr 2007 09:44:24 AM
... or you will have a table which will be used to secure your FM by leveraging $account.defaultName and to drive a VBS to secure a PYI.
Title: Re: Security with PowerCubes and Relational Data Sources in Cognos 8
Post by: ykud on 05 Apr 2007 10:41:59 AM
Quote from: Darek on 05 Apr 2007 09:44:24 AM
... or you will have a table which will be used to secure your FM by leveraging $account.defaultName and to drive a VBS to secure a PYI.
Ìîre like a set of linked tables, defining user access to various parts of data.  :)
Text only | Text with Images