Skip to Content

Querying CMS tables for users' security, history & favorites

Hello,

We are running BOBJ over a BW environment, and we've been asked to help design a Webdynpro interface that reads a user's security credentials in both BW and BOBJ servers and pulls in all reports, Bex or BOBJ, that they have access to.

To do this, we would need to query the CMS tables for:

  • All reports a user is authorized to view
  • Groups a user is associated with
  • User's History
  • User's Favorites

Does anyone have suggestions? I've researched Query Builder, but I'm not sure if it can help us, as it accesses three virtual tables instead of the physical tables in the CMS. The option I am guessing we will need to use is SDK.

I'm fairly new to both BW and BOBJ, so any advice is appreciated.

Thanks

Scott

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 16, 2014 at 10:01 AM

    Hello Scott,

    Did you check the possibility of using Audit universe and reports? Please check below link for some useful sample files.

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

    Regards,

    Nikhil Joy

    Add comment
    10|10000 characters needed characters exceeded

    • Nikhil,

      Thanks for your reply. Although a lot of information seems to be avialable via Audit queries, the information we need is not based on event tracking. We are 85% to where we need to be now via Query Builder/ SDK. I have been able to get to most questions we had to answer via Query Builder, and these queries can be replicated in SDK to have usable results.