CMC - Cannot export "Check Relationship" query results to CSV - XIR3

[Former Member]

Hi

I'm trying to export the users belonging to a particular user group in CMC to a .CSV file.

In order to do this, I go to "Users and Groups" tab and right-click on the desired group under the Group Hierarchy link.

I select the >Tools Option and then > Check Relationships.

The query generates all users assigned to that group but the EXPORT to .csv icon remains disabled.

The EXPORT to .csv icon only seems to become enabled if I select Create Security Query, which does not seem to do what I need it to do.

Is this lack of functionality for the Relationship Query by design or is this something like a user access level configuration issue?

Is there an alternative approach to this?

Thank you

- Ment.

[david_lai]

Hi Ment,

You can use query builder to accomplish what you need and copy and paste the results to excel.

1.     http://<BOBJServer>:8080/AdminTools

2.     Login with admin id.

3.     Run the following query

select si_name from CI_systemobjects where

Children("SI_NAME='UserGroup-User'","SI_NAME='Administrators'")

4. This will return the names of users belonging to the user group.

If you need more information about the user you can run

select * from CI_systemobjects where

Children("SI_NAME='UserGroup-User'","SI_NAME='Administrators'")

Then pick and choose the attributes that you are interested in

Thanks

David

[Former Member]

Still the same issue on BO 4.0 SP8
'Relationship Query' does not allow export to CSV option. However, it works fine for 'Security Query'.

Is this an issues or is it intentional? Please can you suggest a work around?

Is there any plan to change this in upcoming versions?

Thanks!
Best Regards,
Rig

[Former Member]

Still not available in BI 4.1 SP6. Lazy SAP fix it soon