Blanking data based on user group

[SynexusStuart]

All,

I need to put some security into Cognos (preferably in Framework Manager) which blanks data based on the users Cognos access (group).

Example,

If i was an HR manager I would see List 1 (in the attched spreadsheet)
If i was "John" I would see List 2.

I can add Data security so john cannot see any other staff at all but I need him to be able to see the names and IDs for those records but the other columns need to be obfuscated by XXXX.

I cannot do this in the report as we need this to be locked down in the package.

We do not have the user data in the DW as it needs to be managed by Cognos Groups so FM security is the only place we can do this.

Any ideas? Very urgent!!

Stuart

[MFGF]

You will need to define calculated items in FM which use an if-then-else construct along with a macro to determine the user (or group/role) in use, and present either the underlying column contents or a string of "XXXXXXXX". These items are then used in your package instead of the original columns.

Regards,

MF.

[SynexusStuart]

Hi MF,

Just came back and looked at this and found that in the mean time we used this exact solution.

It took a while to get there but we did.

Thanks though!

Stuart

[MFGF]

Hee hee. Are you admitting to thinking like a muppet? :)

Glad you got it sorted!

Sent from my iPad using Tapatalk HD

[SynexusStuart]

An isolated incident.

[MFGF]

That's a relief! It's a slippery slope one you start... :)