VIEW: SYS.KU$_CUBE_FACT_VIEW

Source

View Text - Preformatted

select ot.awseq#, ot.obj#, ao1.objname, oc.col#, oc.pcol#,
            (select col1.name from sys.col$ col1
             where col1.obj#=oc.obj# and col1.col#=oc.col#) colname,
            (select col2.name from sys.col$ col2
             where col2.obj#=oc.obj# and col2.col#=oc.pcol#) pcolname,
            oc.coltype,
            (select ao2.objname qdr
             from sys.aw_obj$ ao2,
             (select max(rowid) keep (dense_rank last order by gen#) rid
              from aw_obj$ group by awseq#, oid) aor2
             where ao2.oid = oc.qdroid and ao2.awseq#=ot.awseq#
               and ao2.rowid = aor2.rid) qdr, oc.qdrval, oc.hier#,
            oc.flags
     from sys.olap_tab$ ot, sys.olap_tab_col$ oc, sys.aw_obj$ ao1,
          (select max(rowid) keep (dense_rank last order by gen#) rid
           from aw_obj$ group by awseq#, oid) aor1
     where oc.obj# = ot.obj#
       and ao1.awseq#=ot.awseq# and ao1.rowid=aor1.rid and ao1.oid=oc.oid
     order by oc.col#

View Text - HTML Formatted

SELECT OT.AWSEQ#
, OT.OBJ#
, AO1.OBJNAME
, OC.COL#
, OC.PCOL#
, (SELECT COL1.NAME
FROM SYS.COL$ COL1
WHERE COL1.OBJ#=OC.OBJ#
AND COL1.COL#=OC.COL#) COLNAME
, (SELECT COL2.NAME
FROM SYS.COL$ COL2
WHERE COL2.OBJ#=OC.OBJ#
AND COL2.COL#=OC.PCOL#) PCOLNAME
, OC.COLTYPE
, (SELECT AO2.OBJNAME QDR
FROM SYS.AW_OBJ$ AO2
, (SELECT MAX(ROWID) KEEP (DENSE_RANK LAST ORDER BY GEN#) RID
FROM AW_OBJ$ GROUP BY AWSEQ#
, OID) AOR2
WHERE AO2.OID = OC.QDROID
AND AO2.AWSEQ#=OT.AWSEQ#
AND AO2.ROWID = AOR2.RID) QDR
, OC.QDRVAL
, OC.HIER#
, OC.FLAGS
FROM SYS.OLAP_TAB$ OT
, SYS.OLAP_TAB_COL$ OC
, SYS.AW_OBJ$ AO1
, (SELECT MAX(ROWID) KEEP (DENSE_RANK LAST ORDER BY GEN#) RID
FROM AW_OBJ$ GROUP BY AWSEQ#
, OID) AOR1
WHERE OC.OBJ# = OT.OBJ#
AND AO1.AWSEQ#=OT.AWSEQ#
AND AO1.ROWID=AOR1.RID
AND AO1.OID=OC.OID ORDER BY OC.COL#