VIEW: OLAPSYS.DBA$OLAP1_FACT_LEVEL_USES

Source

View Text - Preformatted

SELECT distinct
  sch.physicalname owner
, cub.physicalname cube_name
, cdu.dimension_owner
, cdu.dimension_name
, cdu.name dimension_alias
, flu.level_name
, fu.object_owner fact_table_owner
, fu.object_name fact_table_name
, flu.foreign_key_name
FROM
  dba_users u
, cwm$model sch
, cwm$cube cub
, cwm$cubedimensionuse cdu
, cwm$factleveluse flu
, cwm$facttablemap fm
, cwm$factuse fu
, cwm$dimension cd
, dba_users du
, sys.obj$ do
WHERE u.username = sch.physicalname
AND sch.irid = cub.datamodel_irid
AND cub.irid = cdu.cube_irid
AND cdu.irid = flu.cubedimensionuse_irid
AND fm.mapcontainer_irid = cub.irid
AND fu.operation_irid_1 = fm.irid
AND cdu.dimension_owner = du.username
AND cdu.dimension_name = do.name
AND du.user_id = do.owner#
AND do.obj# = cd.irid
AND do.type# = 43
AND cd.irid = cdu.abstractdimension_irid
with read only

View Text - HTML Formatted

SELECT DISTINCT SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CDU.DIMENSION_OWNER
, CDU.DIMENSION_NAME
, CDU.NAME DIMENSION_ALIAS
, FLU.LEVEL_NAME
, FU.OBJECT_OWNER FACT_TABLE_OWNER
, FU.OBJECT_NAME FACT_TABLE_NAME
, FLU.FOREIGN_KEY_NAME FROM DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, CWM$CUBEDIMENSIONUSE CDU
, CWM$FACTLEVELUSE FLU
, CWM$FACTTABLEMAP FM
, CWM$FACTUSE FU
, CWM$DIMENSION CD
, DBA_USERS DU
, SYS.OBJ$ DO WHERE U.USERNAME = SCH.PHYSICALNAME AND SCH.IRID = CUB.DATAMODEL_IRID AND CUB.IRID = CDU.CUBE_IRID AND CDU.IRID = FLU.CUBEDIMENSIONUSE_IRID AND FM.MAPCONTAINER_IRID = CUB.IRID AND FU.OPERATION_IRID_1 = FM.IRID AND CDU.DIMENSION_OWNER = DU.USERNAME AND CDU.DIMENSION_NAME = DO.NAME AND DU.USER_ID = DO.OWNER# AND DO.OBJ# = CD.IRID AND DO.TYPE# = 43 AND CD.IRID = CDU.ABSTRACTDIMENSION_IRID WITH READ ONLY