VIEW: OLAPSYS.ALL$OLAP2_AW_PHYS_OBJ_PROP

Source

View Text - Preformatted

SELECT AW.AWOWNER as AW_OWNER,
       AW.AWNAME as AW_NAME,
       AW.AWOBJECT as AW_OBJECT_NAME,
       AW.COL1 as AW_PROP_NAME,
       AW.COL2 as AW_PROP_VALUE
FROM
TABLE(CAST (OLAP_TABLE('SYS.AWMD duration query', 'olapsys.ALL_OLAP2_AW_METADATA_T',
                       'ACTIVE_CATALOG ''ALL_OLAP2_AW_PHYS_OBJ_PROP'' ''ALL''',
                         'MEASURE AWOWNER FROM sys.awmd!PROPS_AWOWNER
                          MEASURE AWNAME FROM sys.awmd!PROPS_AWNAME
                          MEASURE AWOBJECT FROM sys.awmd!PROPS_AWOBJECT
                          MEASURE COL1 FROM sys.awmd!PROPS_AWOBJECTPROPNAME
                          MEASURE COL2 FROM sys.awmd!PROPS_AWOBJECTPROPVALUE
                          DIMENSION AWMDKEY FROM sys.awmd!AWMDKEY_PROPS')
                        AS olapsys.ALL_OLAP2_AW_METADATA_T)) AW

View Text - HTML Formatted

SELECT AW.AWOWNER AS AW_OWNER
, AW.AWNAME AS AW_NAME
, AW.AWOBJECT AS AW_OBJECT_NAME
, AW.COL1 AS AW_PROP_NAME
, AW.COL2 AS AW_PROP_VALUE FROM TABLE(CAST (OLAP_TABLE('SYS.AWMD DURATION QUERY'
, 'OLAPSYS.ALL_OLAP2_AW_METADATA_T'
, 'ACTIVE_CATALOG ''ALL_OLAP2_AW_PHYS_OBJ_PROP'' ''ALL'''
, 'MEASURE AWOWNER
FROM SYS.AWMD!PROPS_AWOWNER MEASURE AWNAME
FROM SYS.AWMD!PROPS_AWNAME MEASURE AWOBJECT
FROM SYS.AWMD!PROPS_AWOBJECT MEASURE COL1
FROM SYS.AWMD!PROPS_AWOBJECTPROPNAME MEASURE COL2
FROM SYS.AWMD!PROPS_AWOBJECTPROPVALUE DIMENSION AWMDKEY
FROM SYS.AWMD!AWMDKEY_PROPS') AS OLAPSYS.ALL_OLAP2_AW_METADATA_T)) AW