VIEW: OLAPSYS.MRV$OLAP2_DIM_LEVEL_ATTR_MAPS

Source

View Text - Preformatted

select
  dlam.owner owner,
  dlam.dimension_name dimension_name,
  dlam.hierarchy_name hierarchy_name,
  dlam.attribute_name attribute_name,
  dlam.lvl_attribute_name lvl_attribute_name,
  dlam.level_name level_name,
  dlam.table_owner table_owner,
  dlam.table_name table_name,
  dlam.column_name column_name,
  dlam.dtype dtype,
  dlam.data_length data_length,
  dlam.data_precision data_precision,
  dlam.olap_api_data_type olap_api_data_type
 from olapsys.cwm2$mrall_dim_level_attr_maps dlam,
      olapsys.olap_session_objects oso
 where oso.version_id = dlam.version_id and
       oso.id = dlam.id

View Text - HTML Formatted

SELECT DLAM.OWNER OWNER
, DLAM.DIMENSION_NAME DIMENSION_NAME
, DLAM.HIERARCHY_NAME HIERARCHY_NAME
, DLAM.ATTRIBUTE_NAME ATTRIBUTE_NAME
, DLAM.LVL_ATTRIBUTE_NAME LVL_ATTRIBUTE_NAME
, DLAM.LEVEL_NAME LEVEL_NAME
, DLAM.TABLE_OWNER TABLE_OWNER
, DLAM.TABLE_NAME TABLE_NAME
, DLAM.COLUMN_NAME COLUMN_NAME
, DLAM.DTYPE DTYPE
, DLAM.DATA_LENGTH DATA_LENGTH
, DLAM.DATA_PRECISION DATA_PRECISION
, DLAM.OLAP_API_DATA_TYPE OLAP_API_DATA_TYPE
FROM OLAPSYS.CWM2$MRALL_DIM_LEVEL_ATTR_MAPS DLAM
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = DLAM.VERSION_ID AND OSO.ID = DLAM.ID