eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: OLAPSYS.DBA$OLAP_FACT_LEVEL_USES

Source

View Text - Preformatted


SELECT
  sch.name owner
, cub.name 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
  cwm$factuse fu
, cwm$facttablemap fm
, cwm$model sch
, cwm$cube  cub
, dba_users u
, cwm$cubedimensionuse cdu
, cwm$factleveluse flu
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
WITH READ ONLY

View Text - HTML Formatted

SELECT SCH.NAME OWNER
, CUB.NAME 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 CWM$FACTUSE FU
, CWM$FACTTABLEMAP FM
, CWM$MODEL SCH
, CWM$CUBE CUB
, DBA_USERS U
, CWM$CUBEDIMENSIONUSE CDU
, CWM$FACTLEVELUSE FLU 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 WITH READ ONLY