/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
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
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)