Universe Joins
This query provides a listing of all universe joins in your SAP BusinessObjects landscape.
Oracle/SQL Server
SELECT sl.cmsid ,sl.name ,sl.objectid ,uj2.joinexpression FROM unv2_joins uj2 ,unv2_universes u2 ,semanticlayer sl WHERE sl.objectid = u2.objectid AND sl.cmsid = u2.cmsid AND uj2.unv_universes_id = u2.id |
Note that when running this query through MetaQuery we can click "Show as Tree" and tree-ify the results like so:
It is "tree-ified" because we include "CMSID" and "OBJECTID" from the core table (SEMANTICLAYER) which instructs MetaMiner to treat it as a tree query.
