VIEW: OLAPSYS.ALL$OLAP2_CUBES

Source

View Text - Preformatted

select
  c.owner owner,
  c.name cube_name,
  c.invalid invalid,
  c.displayname display_name,
  c.shortdescription short_description,
  c.description description,
  nvl(c.MVSummaryCode, 'GS') mv_summarycode,
  decode(c.invalid, 'N', 'DEFAULT', 'O', 'OLAPI', 'INVALID') type_of_validation
from olapsys.CwM2$Cube c
  where (c.invalid = 'N' or c.invalid = 'O') and
  (cwm2$security.fact_table_visible(c.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47)))
with read only

View Text - HTML Formatted

SELECT C.OWNER OWNER
, C.NAME CUBE_NAME
, C.INVALID INVALID
, C.DISPLAYNAME DISPLAY_NAME
, C.SHORTDESCRIPTION SHORT_DESCRIPTION
, C.DESCRIPTION DESCRIPTION
, NVL(C.MVSUMMARYCODE
, 'GS') MV_SUMMARYCODE
, DECODE(C.INVALID
, 'N'
, 'DEFAULT'
, 'O'
, 'OLAPI'
, 'INVALID') TYPE_OF_VALIDATION FROM OLAPSYS.CWM2$CUBE C
WHERE (C.INVALID = 'N' OR C.INVALID = 'O') AND (CWM2$SECURITY.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) WITH READ ONLY