SAP Knowledge Base Article - Public

1454264 - How To Query The CMS For Connection Information

Symptom

How do I query the CMS for connection information?

Environment

BusinessObjects Enterprise XIR3.1

Resolution

Launch the Query Builder (Start > Programs > BusinessObjects XI3.1 > BusinessObjects Enterprise > Query Builder

In the Select window query

SELECT SI_NAME, SI_ID, SI_FILES, SI_DATACONNECTION
FROM CI_APPOBJECTS
WHERE SI_KIND = ‘universe’

The query above lists all of the Universe’s and their associated Universe Connections within the BOE XI R2 system by specifying the following information:

SI_NAME: The name of the Universe.
SI_ID: The unique ID of the Universe.
SI_FILES: The physical location and name of Universe File in FRS.
SI_DATACONNECTION: The data connections assigned to the universe object. The value listed will be the SI_ID of the Universe Connection.

Next:

SELECT * FROM CI_APPOBJECTS

WHERE SI_ID='enter the number of the of the SI_DATACONNECTION returned in Query 1'

Keywords

KBA , BI-BIP-SL , Semantic Layer , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008