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