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: Transformer

[MFGF]

Hi,

Yes, I'm afraid that you will need to define the security in both Transformer and Framework Manager in this instance.  The only other alternative would be to use DMR (Regular Dimensions and Measure Dimensions) defined in Framework Manager instead of using your PowerCube, but this may end up being more work than defining the security...

Regards,

MF.