DBA Data[Home] [Help]

VIEW: OLAPSYS.MRV$OLAP2_POP_DIMENSIONS

Source

View Text - Preformatted

select
 d.irid id
FROM
 cwm2$dimension d
WHERE cwm2$security.dimension_tables_visible(d.irid) = 'Y'
View Text - HTML Formatted

SELECT D.IRID ID FROM CWM2$DIMENSION D WHERE CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(D.IRID) = 'Y'