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.
2. After Log on you will direct to below query page.
3. Type simple query(SELECT * FROM CI_INFOOBJECTS) in query window. click on Submit Query.
4.Query Result Window appears as