select
c.owner owner,
c.name cube_name,
d.owner dimension_owner,
d.name dimension_name,
(case when h.hidden = 'N'
then h.name else null end) hierarchy_name,
fdhm.irid dim_hier_combo_id,
f.name aggregation_name,
fkdhm.aggorder aggregation_order
from olapsys.CwM2$Cube c,
olapsys.CwM2$Dimension d,
olapsys.CwM2$CubeDimensionUse cdu,
olapsys.CwM2$FactDimHierMap fdhm,
olapsys.CwM2$FactDimHierTplsDtl fdhtd,
olapsys.CwM2$FactKeyDimHierMap fkdhm,
olapsys.CwM2$Hierarchy h,
olapsys.cwm$Function f
where c.irid = cdu.cube_irid and
d.irid = cdu.dimension_irid and
h.dimension_irid = d.irid and
fdhm.cube_irid = c.irid and
fkdhm.factDimHier_IRID = fdhm.irid and
fkdhm.dimension_irid = d.irid and
fdhm.irid = fdhtd.factdimhier_irid and
h.irid = fdhtd.hier_irid and
fkdhm.aggoperator_irid = f.irid
with read only
SELECT
C.OWNER OWNER
,
C.NAME CUBE_NAME
,
D.OWNER DIMENSION_OWNER
,
D.NAME DIMENSION_NAME
,
(CASE WHEN H.HIDDEN = 'N'
THEN H.NAME ELSE NULL END) HIERARCHY_NAME
,
FDHM.IRID DIM_HIER_COMBO_ID
,
F.NAME AGGREGATION_NAME
,
FKDHM.AGGORDER AGGREGATION_ORDER
FROM OLAPSYS.CWM2$CUBE C
,
OLAPSYS.CWM2$DIMENSION D
,
OLAPSYS.CWM2$CUBEDIMENSIONUSE CDU
,
OLAPSYS.CWM2$FACTDIMHIERMAP FDHM
,
OLAPSYS.CWM2$FACTDIMHIERTPLSDTL FDHTD
,
OLAPSYS.CWM2$FACTKEYDIMHIERMAP FKDHM
,
OLAPSYS.CWM2$HIERARCHY H
,
OLAPSYS.CWM$FUNCTION F
WHERE C.IRID = CDU.CUBE_IRID AND
D.IRID = CDU.DIMENSION_IRID AND
H.DIMENSION_IRID = D.IRID AND
FDHM.CUBE_IRID = C.IRID AND
FKDHM.FACTDIMHIER_IRID = FDHM.IRID AND
FKDHM.DIMENSION_IRID = D.IRID AND
FDHM.IRID = FDHTD.FACTDIMHIER_IRID AND
H.IRID = FDHTD.HIER_IRID AND
FKDHM.AGGOPERATOR_IRID = F.IRID
WITH READ ONLY
|
|
|