VIEW: OLAPSYS.MRV$OLAP2_LISTDIMS

Source

View Text - Preformatted

select
  ld.owner owner,
  ld.dimension_name dimension_name,
  ld.plural_name plural_name,
  ld.display_name display_name,
  ld.shortdescription short_description,
  ld.description description,
  ld.descriptor_value descriptor_value,
  ld.table_owner table_owner,
  ld.table_name table_name,
  ld.column_name column_name,
  ld.column_position column_position,
  ld.data_type data_type,
  ld.data_length data_length,
  ld.data_precision data_precision,
  ld.level_name level_name
 from olapsys.cwm2$mrall_listdims ld,
      olapsys.olap_session_objects oso
 where oso.version_id = ld.version_id and
       oso.id = ld.id

View Text - HTML Formatted

SELECT LD.OWNER OWNER
, LD.DIMENSION_NAME DIMENSION_NAME
, LD.PLURAL_NAME PLURAL_NAME
, LD.DISPLAY_NAME DISPLAY_NAME
, LD.SHORTDESCRIPTION SHORT_DESCRIPTION
, LD.DESCRIPTION DESCRIPTION
, LD.DESCRIPTOR_VALUE DESCRIPTOR_VALUE
, LD.TABLE_OWNER TABLE_OWNER
, LD.TABLE_NAME TABLE_NAME
, LD.COLUMN_NAME COLUMN_NAME
, LD.COLUMN_POSITION COLUMN_POSITION
, LD.DATA_TYPE DATA_TYPE
, LD.DATA_LENGTH DATA_LENGTH
, LD.DATA_PRECISION DATA_PRECISION
, LD.LEVEL_NAME LEVEL_NAME
FROM OLAPSYS.CWM2$MRALL_LISTDIMS LD
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = LD.VERSION_ID AND OSO.ID = LD.ID