VIEW: OLAPSYS.ALL$OLAP2_AW_CATALOG_MEASURES

Source

View Text - Preformatted

SELECT AW.AWOWNER as AW_OWNER,
       AW.AWNAME as AW_NAME,
       AW.COL5 as CATALOG_ID,
       AW.COL4 as CATALOG_NAME,
       AW.COL1 as ENTITY_OWNER,
       AW.COL2 as ENTITY_NAME,
       AW.COL3 as CHILD_ENTITY_NAME
FROM
TABLE(CAST(OLAP_TABLE('SYS.AWMD duration query', 'olapsys.ALL_OLAP2_AW_METADATA_T',
                       'ACTIVE_CATALOG ''ALL_CATALOG_MEASURES'' ''ALL''',
                       'MEASURE AWOWNER FROM sys.awmd!CATM_AWOWNER
                        MEASURE AWNAME FROM sys.awmd!CATM_AWNAME
                        MEASURE COL5 FROM sys.awmd!CATM_CATALOG_ID
                        MEASURE COL1 FROM sys.awmd!CATM_AWOWNER
                        MEASURE COL2 FROM sys.awmd!CATM_CUBE_NAME
                        MEASURE COL3 FROM sys.awmd!CATM_MEASURE_NAME
                        MEASURE COL4 FROM sys.awmd!CATM_MEASFOLDERNAME
                        DIMENSION AWMDKEY FROM sys.awmd!AWMDKEY_CATM')
                        AS olapsys.ALL_OLAP2_AW_METADATA_T)) AW

View Text - HTML Formatted

SELECT AW.AWOWNER AS AW_OWNER
, AW.AWNAME AS AW_NAME
, AW.COL5 AS CATALOG_ID
, AW.COL4 AS CATALOG_NAME
, AW.COL1 AS ENTITY_OWNER
, AW.COL2 AS ENTITY_NAME
, AW.COL3 AS CHILD_ENTITY_NAME FROM TABLE(CAST(OLAP_TABLE('SYS.AWMD DURATION QUERY'
, 'OLAPSYS.ALL_OLAP2_AW_METADATA_T'
, 'ACTIVE_CATALOG ''ALL_CATALOG_MEASURES'' ''ALL'''
, 'MEASURE AWOWNER
FROM SYS.AWMD!CATM_AWOWNER MEASURE AWNAME
FROM SYS.AWMD!CATM_AWNAME MEASURE COL5
FROM SYS.AWMD!CATM_CATALOG_ID MEASURE COL1
FROM SYS.AWMD!CATM_AWOWNER MEASURE COL2
FROM SYS.AWMD!CATM_CUBE_NAME MEASURE COL3
FROM SYS.AWMD!CATM_MEASURE_NAME MEASURE COL4
FROM SYS.AWMD!CATM_MEASFOLDERNAME DIMENSION AWMDKEY
FROM SYS.AWMD!AWMDKEY_CATM') AS OLAPSYS.ALL_OLAP2_AW_METADATA_T)) AW