BO4 - report top to list users and groups they belong to

[former_member272336]

Hi,

We were looking at audit universe from sdn forum and not sure how to create a report which lists the users and the groups they belong to.

Is this possible?

Any other/beter way to do this.

Would be a useful audit report?

Thanks

[Former Member · Accepted solution]

Hello,

Auditing may just help you to view users who have logged into the system and few others events accomplished by users with no refrence to the group.

You may suggest to add it to the future releases of BI as a new feature using the idea places.

I hope this heps.

Best regards,

Insaf

[former_member272336 · Accepted solution]

Thanks for all replies.

[former_member182521]

The best way is always to query the CMS database and get the upto date information. Auditing is not preferred as it always get the list who is atleast logged in once. I would suggest you to refer here for the required report.

http://www.forumtopics.com/busobj/viewtopic.php?t=204084&sid=ee4e3ad9665421bcb5d2fcba65019b74

If you still want to create a WebI report, you need to develop a SDK code which extracts repository information, build an universe and report on top of it.

You can also try these web applications as well

http://scn.sap.com/docs/DOC-6260

http://scn.sap.com/docs/DOC-6258

Try this and let me know how it goes

Regards

Mani

[Former Member]

Hi Philip,

Check the threads below, hope it might useful

http://scn.sap.com/thread/3226812

http://scn.sap.com/community/bi-platform/blog/2012/10/11/businessobjects-query-builder-queries

http://www.forumtopics.com/busobj/viewtopic.php?t=172575