Cognos 8 with EPM

[swordfish]

Hi friends,

I am in the process of implementing Cognos 8 with Peoplesoft EPM 8.9.  Cognos had a tool to bridge Peoplesoft EPM and Cognos called StratgyPlus v4.0 (3.x was older version). Does anyone have any idea if this tool is available with Cognos now?

Also this tool Syncs Peoplesoft security with Cognos (one of Strategplus's plus point). This security sync enables row level security of data in Cognos.

Any experiences on implementing row level security in Cognos with or without StrategyPlus......

Regards
SF

[goose]

We use row level security to limit access to records based on info we get out of active diretory for the user. For example suppliers can only see their own data based on there logon data in active directory.

[swordfish]

Thanks for the reply goose!

I have done row level security in Peoplesoft previously. Done a couple of LDAP integrations for Cognos as well. My current hurdle is to implement row level security (as per peoplesoft) in Cognos.

One thought I had was to import the tables that store security related info (4 tables in Peoplesoft) into my FM model. I am stuck at the next step.

Another thought I had was to create a schema for cognos (include the 4 security tables of Psft) in DB and do the security at DB level.

Am I on the right track?? Is there a way that Cognos inherits Peoplesoft security? I know it can be done very well with StrategyPlus but that utility is not available with Cognos anymore........

SF

[goose]

1. If you can pull the tables with security related data from PeopleSoft into your FM model or actual DB (DB might be faster) you must then also be able to model raltionships between them and your current tables or else security cannot be applied.

2. If you can do this then there must also be security related data in the session that you can relate to the imported PeopleSoft data.

Here is our row-level security works for suppiers:

1. Suppliers logon with their supplier ID as a username

2. In FM where have a filter on the supplier fact that says the supplier_id column must equal the Supplier ID which we get from the AD from the session parameters via a macro.

Does this mske sense?

Cheers