Query Builder:
Query Builder is one of most important tool for BO Administrator/Consultant.
"Query Builder connects administrator to Central Management Service(CMS) system repository & its objects.It provides detailed information of all repository Objects."
Query Builder mainly works on 3 Parts
| Information Type | Table Name | Description |
| System Objects | CI_SYSTEMOBJCTS | Consists information of User, UserGroup, Server, FavoritesFolder,Folder, Connection, Calendar, Event, Inbox, LicenseKey, Service, Servicecontainer etc. |
| Application Objects | CI_APPOBJECTS | Consists information of objects that is used by documents such as Universe |
| Information/Infoview Objects | CI_INFOOBJECTS | Consists information of each & every object of infoview like reports, folders |
URL:
BO XI R2
http://[ServerIP]:[Port]/businessobjects/enterprise115/adminlaunch/query/ie.jsp
BO XI R3
http://[ServerIP]:[Port]/AdminTools/querybuilder/ie.jsp
BOBI 4.0
http://[ServerIP]:[Port]/AdminTools/querybuilder/ie.jsp
Steps to Build Query :
- Go To URL address as above mentioned. Log on with your credentials.
- After Log on you will direct to below query page.
- Type simple query(SELECT * FROM CI_INFOOBJECTS) in query window. click on Submit Query.
- Query Result Window appears as
