Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: eladan on 17 Feb 2011 05:42:35 AM

Title: Report studio and Active Directory
Post by: eladan on 17 Feb 2011 05:42:35 AM
Is it possible to bring information from the Active Directory to my report?

For example:
Iv got a list of people. Correctly, their first + last name is wrote by hand. Instead, i would like to bring their first+last name from the Active directory to columns in my list.

Thanks :)
Title: Re: Report studio and Active Directory
Post by: MFGF on 17 Feb 2011 06:20:51 AM
Hi,
I am on my iPhone right now so This is purely from memory...

Try adding a Query Calculation into your list, and use the following syntax:

#sq($account.defaultName)#

Apologies if I got this wrong - I can't check just now.

Regards,

MF.
Title: Re: Report studio and Active Directory
Post by: eladan on 17 Feb 2011 06:51:17 AM
Thank you for the quick answer!

But unfortunately, it doesnt work..
When i validate, it gives me errors  :'(   
Title: Re: Report studio and Active Directory
Post by: CognosPaul on 17 Feb 2011 06:59:30 AM
Do you mean you want to use AD as another data source, and pull a list of users from it?
Title: Re: Report studio and Active Directory
Post by: eladan on 17 Feb 2011 07:02:55 AM
Hey,

Yes, AD already configured, i want to pull list of the users...

Title: Re: Report studio and Active Directory
Post by: CognosPaul on 24 Feb 2011 03:32:49 AM
I really don't know if this is possible.

AD stores it's database in NTDS.DIT, but I have no experience connecting to it as a data source.

My instinct is to recommend pulling your employee list from another source. AD is foremost an authentication provider. Running reports off it may over burden it. There may also be information security concerns when using AD as a data source.
Text only | Text with Images