Java code for user-wise report access list

[Former Member]

Dear All,

I have a very big requirement and I have no idea where to begin. I only have a limited experience with SAP BI's Java SDK and has mostly used it for just generating list of all reports with their folder path or list of all users in a group.

This time though I have a big ambition (or at least I think it would be a difficult one to pull off)

What I need

Is a list of all reports with all users who has access to it and the access level they have.

It needs to have following columns

Report Name, Full Report Path, User ID (and Name if possible), Access level

I am also trying to write a code for list of reports and the user groups that has to it.

What I have

I know how to retrieve the list of all reports and I know how to retrieve list of users. But what I don't know is how to connect them or to get the access level they have.

So if anyone can help me out, it would be great. It would be even more great if I could have a ready to use code! I know it is too much to ask, but as I said I am a novice to Java part and if you give me pieces, it would take me days to stitch em up and make a full code.

So if there are any kind ones out there, please help!

Thanks.

[Former Member]

Hi,

Refer to the blog at

The blog is to get the usergroup access levels on folder. You can change the two queries in the code to

String query = "SELECT  SI_ID,SI_NAME FROM  ci_systemobjects WHERE  SI_kind='user' ";

         IInfoObjects infoobjects = iStore.query(query);

        String universeQuery = "SELECT  SI_ID,SI_NAME FROM ci_infoobjects WHERE SI_Kind='crystalreport'";

         IInfoObjects universes = iStore.query(universeQuery);

Doing so you we get users access levels for all crystal reports.

You would need to check the login in the code and construct one according to your needs.

Hope this helps.

Thanks,

Prithvi