Advanced Query Building Business objects

Advanced Query Building in BO Query Builder

• Query Builder works on 3 tables CI_SYSTEMOBJECTS,CI_INFOOBJECTS,CI_APPOBJECTS

Different Queries on Query Builder
 

Query Builder

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 :

1. 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