Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
29,566

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 

2 Comments