Skip to Content
0

List of reports a user has access to using similar functionality of BI Platform tool

Jun 18, 2017 at 11:01 PM

49

avatar image
Former Member

bi-platform-report-user-security.jpg

Hi Team ,

I was looking into BI platform tool-> Landscape Tools->Security Analyzer -> Select Report Vs User security, we are getting the results in the right pane.

We are trying to achieve similar functionality through SDK and in the process of deriving SQL query which gives the "List of reports a user has access to in the entire repository (public and user's private folders) " . I assume that the template would be like " Select si_id,si_name ,xxxx ,yyy,zzz from CI_Infoobjects where userid ='testuser1' and right id = '3' and right status = 'Granted'.

Can someone help with the correct SQL used in the background to derive results as shown in the attached screen shot from promotion management tool.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Joe Peters Jun 19, 2017 at 01:32 PM
0

What you're looking for is the "IsAllowed" function. It won't provide exactly what you want to get, but it's pretty close. See Ted's answer the following thread for more info: https://archive.sap.com/discussions/thread/1454103

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 19, 2017 at 02:40 PM
0

Hi Joe,

Thank you for referring me to the link : https://archive.sap.com/discussions/thread/1454103 . I could get the list of reports a user has access to using Select TOP 10 SI_ID, SI_NAME, SI_CUID, SI_KIND From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHere SI_KIND='webi' And IsAllowed(1250620, 3) . But this is getting me results only from "public folders" and note getting the list of reports from private/favorites folders. Do you have any suggestion to include favorites in the search/result set ?

Thanks,

Srinivas

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Your query should include personal folders. It's possible that the account you are using to execute the query does not have permission to view the folders.

0