Reading Filenet users' details from LDAP to include them in Cognos reports

[ivolkov@micromash.ru]

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?

[AnalyticsWithJay]

Is this what you're looking for?

[ivolkov@micromash.ru]

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

[ivolkov@micromash.ru]

Is this what you're looking for?

CognoidJay, am I right? ((((

[AnalyticsWithJay]

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.

[ivolkov@micromash.ru]

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!