How to build a report for list of users against each group in XIR2

[Former Member]

How to build a report for list of users against each group in XIR2. Is it possible through Webi or Deski?

Please help me.

[former_member182521]

Hi Narendar,

There is no direct way to create a report (WebI or DeskI) to extract Users and Groups related information since they are stored in Repository database which is encrypted. You can still reference them using Business Objects Query builder

Below blog could help you.

http://scn.sap.com/blogs/manikandanelumalai/2011/01/17/business-objects-query-builder

Finally we can build a metadata universe using BO SDK using either JAVASDK or .NETSDK and the approach will be like this.

1. Create a Extraction program which extracts required data from the BO Repository using BO SDK.

2. Push this data into your custom database tables.

3. Build universe on top of this tables.

4. Create metadata reports (WebI & DeskI) using this universe.

Regards,

Mani

[former_member182521]

You can refer the SDK samples here. http://scn.sap.com/docs/DOC-27465.

For your requirement the code is here  http://scn.sap.com/docs/DOC-6258

You need to just deploy the code samples in your Web application server to get it working.

Regards,

Mani