BusinessObjects Query builder – Basics
Virtual table | Table description | Table Objects |
---|---|---|
CI_SYSTEMOBJECTS | Contains InfoObjects that the BI Platform uses | User, User Group, Server, Server Group,Folder, Connection, Calendar,Event |
CI_APPOBJECTS | Holds InfoObjects that are used by documents | Universe |
CI_INFOOBJECTS | Contains InfoObjects that are consumed by the end user | WebI, Crystal Report, FullClient, PowerPoint, Pdf, Excel, Word, Rtf, Txt,Program, Shortcut |
Accessing Query Builder
Query Builder can be found at the below URL http://MyServer:Port/AdminTools
Make sure you are using a user credentials that is part of Administrator user group in order to gain access to all the repository objects. Please note using Query Builder we can only query the information stored in the CMS database not from the File repository files.
Simple queries to use against the repository
To list all the Users
SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND=’USER’
To list all the Universes
SELECT * FROM CI_APPOBJECTS WHERE SI_KIND=’UNIVERSE’
To list all the WebI reports
SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’WEBI’
Query Builder Blog series
Basics
BusinessObjects Query builder – Basics
BusinessObjects Query builder – Best practices & Usability
Sample Queries
BusinessObjects Query builder queries
BusinessObjects Query builder queries – Part II
BusinessObjects Query builder queries – Part III
BusinessObjects Query builder queries – Part IV
BusinessObjects Query builder – Exploring Visualization Objects
BusinessObjects Query builder – Exploring Monitoring Objects
BusinessObjects Query builder – Exploring Lumira & Design studio Objects
Use cases
BusinessObjects Environment assessment using Query builder
Hi Mani,
I need to find ithe list of universes where ,a specific TABLE is being used.
Is it possible in Query builder?
Regds,
Samson
Is there a way to easily export data from the Query Builder?
there isn't, the tool is not built for exporting, however CMS DB driver now allows you to build universes on top of repository and report of them.
Hi Bryant-
There is one tool called BI clever. Use the below link to easily export the data.
http://biclever.com/blog/bi-on-bi/
These query builder posts have been extremely beneficial after being thrown into the SAP BOBJ admin world. I am curious if it is possible to filter on child objects. As an example SI_EXTENDED_PROCESSINFO.SI_PROMPT_DEFAULT_VALUES
SI_EXTENDED_PROCESSINFO
> SI_PROMPT_DEFAULT_VALUES