Sap Bo Query Builder
A little known and little discussed tool included in the sap businessobjects suite is something called query builder.
Sap bo query builder. Dear all i need the list of bo users and the user groups to which the users are part of. General queries to get bo repository information. 1735539 query to list all universes for which a user has edit objects rights via query builder requirements dependencies if using a 3rd party web application server or you are manually deploying web applications then you will need to deploy the web application admintools. I have covered as much as possible to get the bo universe reports server schedule database results using query builder.
Using query builder one can easily query the businessobjects repository and get the required information which cannot be found even in cmc. To explain more in detail businessobjects repository made up of set of tables to hold the information about the bi content such as universes reports users schedules etc. Below are the list bo 6 5 repository tables. Please feel free to post your comments queries and will try to answer your queries.
In cmc folders choose folder user security choose usergroup view security. I am executing the below query but separately but. Can anyone please help me with the query that i should execute in query builder to get the user and the group. Hello techies some of the query builder queries to explore the businessobjects repository.
Thanks and regards amit. This will be handy for those who searching for query builder queries. But i never know if the query builder is able to process more complex queries i always used a java sdk to know more. This simple webapp can be used to query your businessobjects repository to get all kinds of information not readily available in other places such as the central management console.
Select from ci infoobjects where si recurring 1 and si schedule status 9 you should query the instances and get know what are the parrents. This query should you return the scheduled instances. This provides the principal and objects folder to which the access is enabled.