Security with PowerCubes and Relational Data Sources in Cognos 8

[ykud]

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

[Darek]

There is no other way.

[ykud]

I guess we'll write some vbs, synchronizing security in fm and transformer.

[Darek]

... 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.

[ykud]

... 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.  :)