Thanks for the quick reply Joanne,
When I set Search base attribute in Pentaho = "ou=groups, dc=test,dc=comp,dc=net"
It returns ALL the groups hierarchy from LDAP
When I set it to one of the group, it returns all the direct members
"cn=MY_GROUP_NAME,ou=groups, dc=test,dc=comp,dc=net"
Now our requirement is to fetch group/user hierarchy of given group, "MY_GROUP_NAME"
Thanks
Nikesh