Business Objects provides a tool named Metadata Integrator to import relationship between universe and report.
You need configure CMS(Central Management Server) and target database in Metadata Integrator first, then run, then it will load those relationship into target database.
Below is window when data loading starts
Here is description of related tables:
| Table Name | Description |
| AL_CMS_REPORTS | Information that uniquely identifies Crystal Reports, Desktop Intelligence document, or Web Intelligence documents |
| AL_CMS_REPORTUSAGE | Tables, columns, Business Views, or Universes that a Crystal Report, Desktop Intelligence Document, or Web Intelligence Document uses |
| AL_CMS_FOLDER | Folder names in which a Crystal Report, Desktop Intelligence Document, or Web Intelligence Document resides |
| AL_CMS_UNV | Information that uniquely identifies Universes |
| AL_CMS_UNV_OBJ | Universe classes and the child objects, with the source column and table |
Example: How to get all reports name using one universe object
SELECT DISTINCT
F.FOLDER_NAME AS REPORT_FOLDER,
R.REPORT_TITLE AS REPORT_NAME,
FU.FOLDER_NAME AS UNV_FOLDER,
U.UNV_NAME,
R_U.UNV_CLASS,
R_U.UNV_OBJ
FROM DBO.AL_CMS_REPORTUSAGE R_U
INNER JOIN DBO.AL_CMS_REPORTS R ON (R_U.REPORT_CUID = R.REPORT_CUID)
INNER JOIN DBO.AL_CMS_UNV U ON R_U.UNV_CUID =U.UNV_CUID
INNER JOIN DBO.AL_CMS_FOLDER F ON R.FOLDER_CUID = F.FOLDER_CUID
INNER JOIN DBO.AL_CMS_FOLDER FU ON (U.FOLDER_CUID= FU.FOLDER_CUID)
WHERE R_U.UNV_OBJ =’OBJECT_NAME’
