COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: ivolkov@micromash.ru on 27 Feb 2017 07:01:52 AM

Title: Reading Filenet users' details from LDAP to include them in Cognos reports
Post by: ivolkov@micromash.ru on 27 Feb 2017 07:01:52 AM
Hi,
I am looking for an elegant way of reading arbitrary users' personal details (full name, room #, etc.) from LDAP server to include them in my reports in Cognos (Filenet usage audit reports, in particular).
Can anybody give me some clue how to prepare such reports?
Title: Re: Reading Filenet users' details from LDAP to include them in Cognos reports
Post by: AnalyticsWithJay on 27 Feb 2017 08:12:12 AM
Is this (https://www-304.ibm.com/support/docview.wss?uid=swg21341035) what you're looking for?
Title: Re: Reading Filenet users' details from LDAP to include them in Cognos reports
Post by: ivolkov@micromash.ru on 27 Feb 2017 08:28:02 AM
Quote from: CognoidJay on 27 Feb 2017 08:12:12 AM
Is this (https://www-304.ibm.com/support/docview.wss?uid=swg21341035) what you're looking for?

Thanks, I believe it is not.
Administrator runs Cognos report describing 1000 Filenet users' stats, and he has to see their full names, etc., and not his.
Title: Re: Reading Filenet users' details from LDAP to include them in Cognos reports
Post by: ivolkov@micromash.ru on 28 Feb 2017 04:05:05 AM
Quote from: CognoidJay on 27 Feb 2017 08:12:12 AM
Is this (https://www-304.ibm.com/support/docview.wss?uid=swg21341035) what you're looking for?

CognoidJay, am I right? ((((
Title: Re: Reading Filenet users' details from LDAP to include them in Cognos reports
Post by: AnalyticsWithJay on 28 Feb 2017 06:45:05 AM
Quote from: EliasVolkov on 28 Feb 2017 04:05:05 AM
CognoidJay, am I right? ((((

Yes, you're right. What I provided you allows you to leverage more of your LDAP attributes in your report, whereas you're looking to join filenet usage with LDAP user account info.

You will need to pull this information via ETL and prepare it in your data warehouse.

Title: Re: Reading Filenet users' details from LDAP to include them in Cognos reports
Post by: ivolkov@micromash.ru on 28 Feb 2017 06:52:44 AM
Quote from: CognoidJay on 28 Feb 2017 06:45:05 AM
Yes, you're right. What I provided you allows you to leverage more of your LDAP attributes in your report, whereas you're looking to join filenet usage with LDAP user account info.

You will need to pull this information via ETL and prepare it in your data warehouse.

Thanks a lot!