We can extend the Universe Join analysis to include complex joins, like so:
BI4, XI3 (Universes), Oracle
SELECT sl.cmsid ,sl.name ,sl.objectid ,to_char (uj2.joinexpression) 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 AND LOWER( to_char ( uj2.joinexpression ) ) LIKE '% and %' UNION SELECT sl.cmsid ,sl.name ,sl.objectid ,to_char (uj2.joinexpression) 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 AND LOWER( to_char ( uj2.joinexpression ) ) LIKE '% or %' |