This query provides a listing of those reports believed to have no corresponding Universe in the CMS given for the universe cuid identified in the Web Intelligence dataprovider.
BI4, Oracle
-- Possible Orphaned Reports (No matching Universe found in CMS for dataprovider)
SELECT V_DOCUMENTS.NAME, v_documents.folderpathcomplete, WEBI1400_SQLCONTAINERS.id, WEBI1400_DATAPROVIDERS.ID, SEMANTICLAYER.CUID, WEBI1400_DATAPROVIDERS.UNIVERSENAME UNIVERSENAME_DP, NVl(SEMANTICLAYER.NAME,'POSSIBLE ORPHAN!') UNIVERSENAME_SL FROM V_DOCUMENTS INNER JOIN WEBI1400_DOCUMENTS ON (V_DOCUMENTS.CMSID=WEBI1400_DOCUMENTS.CMSID and V_DOCUMENTS.DOCUMENTS_OBJECTID=WEBI1400_DOCUMENTS.OBJECTID) INNER JOIN WEBI1400_DATAPROVIDERS ON (WEBI1400_DOCUMENTS.ID=WEBI1400_DATAPROVIDERS.WEBI1400DOCUMENT_ID) INNER JOIN WEBI1400_SQLCONTAINERS ON (WEBI1400_SQLCONTAINERS.WEBIDATAPROVIDER_ID=WEBI1400_DATAPROVIDERS.ID) left outer join SEMANTICLAYER ON (WEBI1400_DATAPROVIDERS.UNIVERSECUID=SEMANTICLAYER.CUID and WEBI1400_DOCUMENTS.CMSID = SEMANTICLAYER.CMSID)
|
XI3, Oracle
SELECT V_DOCUMENTS.NAME, v_documents.folderpathcomplete, WEBI1200_SQLCONTAINERS.id, WEBI1200_DATAPROVIDERS.ID, SEMANTICLAYER.CUID, NVl(SEMANTICLAYER.NAME,'POSSIBLE ORPHAN!') UNIVERSENAME_SL FROM V_DOCUMENTS INNER JOIN WEBI1200_DOCUMENTS ON (V_DOCUMENTS.CMSID=WEBI1200_DOCUMENTS.CMSID and V_DOCUMENTS.DOCUMENTS_OBJECTID=WEBI1200_DOCUMENTS.OBJECTID) INNER JOIN WEBI1200_DATAPROVIDERS ON (WEBI1200_DOCUMENTS.ID=WEBI1200_DATAPROVIDERS.WEBI1200_DOCUMENT_ID) INNER JOIN WEBI1200_SQLCONTAINERS ON (WEBI1200_SQLCONTAINERS.WEBI_DATAPROVIDERS_ID=WEBI1200_DATAPROVIDERS.ID) left outer join SEMANTICLAYER ON (WEBI1200_DATAPROVIDERS.UNIVERSECUID=SEMANTICLAYER.CUID and WEBI1200_DOCUMENTS.CMSID = SEMANTICLAYER.CMSID) |