Sap Bo Query Builder
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.
Sap bo query builder. March 2 2017 at 4 18 pm hi amit first bo 6 5 and bo xi has different architecture and you cannot use same query builder in bo 6 5. Will query builder of sap bo 3 1 work in bo 6 5 sp4. General queries to get bo repository information. A little known and little discussed tool included in the sap businessobjects suite is something called query builder.
In cmc folders choose folder user security choose usergroup view security. This will be handy for those who searching for query builder queries. Hello techies some of the query builder queries to explore the businessobjects repository. 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.
This provides the principal and objects folder to which the access is enabled. Thanks and regards amit. I am executing the below query but separately but. 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.
Below are the list bo 6 5 repository tables. Dear all i need the list of bo users and the user groups to which the users are part of. This query should you return the scheduled instances. But i never know if the query builder is able to process more complex queries i always used a java sdk to know more.
Can anyone please help me with the query that i should execute in query builder to get the user and the group. 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. Please feel free to post your comments queries and will try to answer your queries.