SELECT AW.AWOWNER as AW_OWNER,
AW.AWNAME as AW_NAME,
AW.COL1 as CUBE_NAME,
AW.COL5 as HIERCOMBO_NUM,
AW.COL3 as HIERCOMBO_STR
FROM
TABLE(CAST(OLAP_TABLE('SYS.AWMD duration query',
'olapsys.ALL_OLAP2_AW_METADATA_T',
'ACTIVE_CATALOG ''ALL_AW_CUBE_ENABLED_HIERCOMBO'' ''ALL''',
'MEASURE AWOWNER FROM SYS.AWMD!AWOWNER
MEASURE AWNAME FROM SYS.AWMD!AWNAME
MEASURE COL1 FROM SYS.AWMD!CUBE_NAME
MEASURE COL5 FROM SYS.AWMD!HIERCOMBO_NUM
MEASURE COL3 FROM SYS.AWMD!HIERCOMBO_STR
DIMENSION AWMDKEY FROM SYS.AWMD!AWMDKEY')
AS olapsys.ALL_OLAP2_AW_METADATA_T)) AW
SELECT AW.AWOWNER AS AW_OWNER
,
AW.AWNAME AS AW_NAME
,
AW.COL1 AS CUBE_NAME
,
AW.COL5 AS HIERCOMBO_NUM
,
AW.COL3 AS HIERCOMBO_STR
FROM
TABLE(CAST(OLAP_TABLE('SYS.AWMD DURATION QUERY'
,
'OLAPSYS.ALL_OLAP2_AW_METADATA_T'
,
'ACTIVE_CATALOG ''ALL_AW_CUBE_ENABLED_HIERCOMBO'' ''ALL'''
,
'MEASURE AWOWNER
FROM SYS.AWMD!AWOWNER
MEASURE AWNAME
FROM SYS.AWMD!AWNAME
MEASURE COL1
FROM SYS.AWMD!CUBE_NAME
MEASURE COL5
FROM SYS.AWMD!HIERCOMBO_NUM
MEASURE COL3
FROM SYS.AWMD!HIERCOMBO_STR
DIMENSION AWMDKEY
FROM SYS.AWMD!AWMDKEY')
AS OLAPSYS.ALL_OLAP2_AW_METADATA_T)) AW
|
|
|