IBM Support

Users not visible in Domain User Group from within Cognos

Troubleshooting


Problem

How to make users who are members of the built-in Domain User Group visible when viewed from Cognos?

Symptom

When browsing the Domain User Group from the Active Directory Namespace in Cognos, only Groups are listed yet users exist when viewed from the Active Directory Users and Computers Management Console.

Cause

See external link:

http://stackoverflow.com/questions/5754924/ldap-query-not-work-for-group-domain-users

Environment

Windows 2008 R2 - Active Directory.

Resolving The Problem

Change the Primary Group for each of the AD users from the default Domain User Group to any other group.

Manual Method:

1. Open Active Directory Users and Computers
2. Navigate to a user that is a member of the Domain User Group (which does not appear in the AD namespace within Cognos)
3. Right-Click - Properties - Member Of tab - Select a different Group and click on 'Set Primary Group' button.
4. Navigate to Cognos and Browse the Domain User Group and the user now appears.

Note: Please see attached document with steps and screenshot showing the issue and solution.

Scripting approach to changing the Primary Group:

See following links as examples:

http://www.tek-tips.com/viewthread.cfm?qid=943406

Powershell

http://social.technet.microsoft.com/Forums/lt/winserverManagement/thread/5a6d4cd2-d772-496b-8e56-f39d215f5176

Domain_Users_Group_List.docDomain_Users_Group_List.doc

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Security","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1","Edition":"All Editions"}]

Document Information

Modified date:
15 June 2018

UID

swg21598533