SELECT AW.AWOWNER as AW_OWNER,
AW.AWNAME as AW_NAME,
AW.COL5 as CATALOG_ID,
AW.COL1 as CATALOG_NAME,
AW.COL4 as PARENT_CATALOG_NAME,
AW.COL2 as DESCRIPTION
FROM
TABLE(CAST(OLAP_TABLE('SYS.AWMD duration query', 'olapsys.ALL_OLAP2_AW_METADATA_T',
'ACTIVE_CATALOG ''ALL_CATALOGS'' ''ALL''',
'MEASURE AWOWNER FROM sys.awmd!CAT_AWOWNER
MEASURE AWNAME FROM sys.awmd!CAT_AWNAME
MEASURE COL5 FROM sys.awmd!CAT_CATALOG_ID
MEASURE COL1 FROM sys.awmd!CAT_MEASFOLDERNAME
MEASURE COL2 FROM sys.awmd!CAT_MEASFOLDERDESC
MEASURE COL4 FROM sys.awmd!CAT_PARENTFOLDERNAME
DIMENSION AWMDKEY FROM sys.awmd!AWMDKEY_CAT')
AS olapsys.ALL_OLAP2_AW_METADATA_T)) AW
SELECT AW.AWOWNER AS AW_OWNER
,
AW.AWNAME AS AW_NAME
,
AW.COL5 AS CATALOG_ID
,
AW.COL1 AS CATALOG_NAME
,
AW.COL4 AS PARENT_CATALOG_NAME
,
AW.COL2 AS DESCRIPTION
FROM
TABLE(CAST(OLAP_TABLE('SYS.AWMD DURATION QUERY'
, 'OLAPSYS.ALL_OLAP2_AW_METADATA_T'
,
'ACTIVE_CATALOG ''ALL_CATALOGS'' ''ALL'''
,
'MEASURE AWOWNER
FROM SYS.AWMD!CAT_AWOWNER
MEASURE AWNAME
FROM SYS.AWMD!CAT_AWNAME
MEASURE COL5
FROM SYS.AWMD!CAT_CATALOG_ID
MEASURE COL1
FROM SYS.AWMD!CAT_MEASFOLDERNAME
MEASURE COL2
FROM SYS.AWMD!CAT_MEASFOLDERDESC
MEASURE COL4
FROM SYS.AWMD!CAT_PARENTFOLDERNAME
DIMENSION AWMDKEY
FROM SYS.AWMD!AWMDKEY_CAT')
AS OLAPSYS.ALL_OLAP2_AW_METADATA_T)) AW
|
|
|