[Home] [Help]
VIEW: OLAPSYS.MRV$OLAP1_POP_CUBES
Source
View Text - Preformatted
select
cub.irid id
FROM
cwm$model sch,
cwm$cube cub
WHERE sch.irid = cub.datamodel_irid and
cwm$util.fact_table_visible(cub.irid) = 'Y'
View Text - HTML Formatted
SELECT
CUB.IRID ID
FROM
CWM$MODEL SCH
,
CWM$CUBE CUB
WHERE SCH.IRID = CUB.DATAMODEL_IRID AND
CWM$UTIL.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y'