eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: SYS.DBA_CUBE_ATTR_VISIBILITY

Source

View Text - Preformatted


SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  null HIERARCHY_NAME,
  null LEVEL_NAME,
  'DIMENSION' FROM_TYPE,
  'DIMENSION' TO_TYPE
FROM
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 11 -- DIMENSION
  AND av.owning_dim_id = o.obj#
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  h.hierarchy_name HIERARCHY_NAME,
  null LEVEL_NAME,
  'DIMENSION' FROM_TYPE,
  'HIERARCHY' TO_TYPE
FROM
  olap_hierarchies$ h,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 11 -- DIMENSION
  AND av.owning_dim_id = o.obj#
  AND h.dim_obj# = o.obj#
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  null HIERARCHY_NAME,
  dl.level_name LEVEL_NAME,
  'DIMENSION' FROM_TYPE,
  'DIM_LEVEL' TO_TYPE
FROM
  olap_dim_levels$ dl,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 11 -- DIMENSION
  AND av.owning_dim_id = o.obj#
  AND dl.dim_obj# = o.obj#
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  h.hierarchy_name HIERARCHY_NAME,
  dl.level_name LEVEL_NAME,
  'DIMENSION' FROM_TYPE,
  'HIER_LEVEL' TO_TYPE
FROM
  olap_hierarchies$ h,
  olap_hier_levels$ hl,
  olap_dim_levels$ dl,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 11 -- DIMENSION
  AND av.owning_dim_id = o.obj#
  AND h.dim_obj# = o.obj#
  AND hl.hierarchy_id = h.hierarchy_id
  AND dl.level_id = hl.dim_level_id
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  h.hierarchy_name HIERARCHY_NAME,
  null LEVEL_NAME,
  'HIERARCHY' FROM_TYPE,
  'HIERARCHY' TO_TYPE
FROM
  olap_hierarchies$ h,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 13 -- HIERARCHY
  AND av.owning_dim_id = h.hierarchy_id
  AND h.dim_obj# = o.obj#
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  h.hierarchy_name HIERARCHY_NAME,
  dl.level_name LEVEL_NAME,
  'HIERARCHY' FROM_TYPE,
  'HIER_LEVEL' TO_TYPE
FROM
  olap_hierarchies$ h,
  olap_hier_levels$ hl,
  olap_dim_levels$ dl,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 13 -- HIERARCHY
  AND av.owning_dim_id = h.hierarchy_id
  AND h.dim_obj# = o.obj#
  AND hl.hierarchy_id = h.hierarchy_id
  AND dl.level_id = hl.dim_level_id
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  h.hierarchy_name HIERARCHY_NAME,
  dl.level_name LEVEL_NAME,
  'HIER_LEVEL' FROM_TYPE,
  'HIER_LEVEL' TO_TYPE
FROM
  olap_hierarchies$ h,
  olap_hier_levels$ hl,
  olap_dim_levels$ dl,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 14 -- HIER_LEVEL
  AND av.owning_dim_id = hl.hierarchy_level_id
  AND hl.hierarchy_id = h.hierarchy_id
  AND dl.level_id = hl.dim_level_id
  AND h.dim_obj# = o.obj#
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  null HIERARCHY_NAME,
  dl.level_name LEVEL_NAME,
  'DIM_LEVEL' FROM_TYPE,
  'DIM_LEVEL' TO_TYPE
FROM
  olap_dim_levels$ dl,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 12 -- DIM_LEVEL
  AND av.owning_dim_id = dl.level_id
  AND dl.dim_obj# = o.obj#
  AND o.owner# = u.user#
UNION ALL
SELECT
  u.name OWNER,
  o.name DIMENSION_NAME,
  a.attribute_name ATTRIBUTE_NAME,
  h.hierarchy_name HIERARCHY_NAME,
  dl.level_name LEVEL_NAME,
  'DIM_LEVEL' FROM_TYPE,
  'HIER_LEVEL' TO_TYPE
FROM
  olap_hierarchies$ h,
  olap_hier_levels$ hl,
  olap_dim_levels$ dl,
  olap_attributes$ a,
  olap_attribute_visibility$ av,
  obj$ o,
  user$ u
WHERE
  av.is_unique_key = 0
  AND av.attribute_id = a.attribute_id
  AND av.owning_dim_type = 12 -- DIM_LEVEL
  AND av.owning_dim_id = dl.level_id
  AND dl.level_id = hl.dim_level_id
  AND hl.hierarchy_id = h.hierarchy_id
  AND h.dim_obj# = o.obj#
  AND o.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, NULL HIERARCHY_NAME
, NULL LEVEL_NAME
, 'DIMENSION' FROM_TYPE
, 'DIMENSION' TO_TYPE FROM OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 11 -- DIMENSION
AND AV.OWNING_DIM_ID = O.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, NULL LEVEL_NAME
, 'DIMENSION' FROM_TYPE
, 'HIERARCHY' TO_TYPE FROM OLAP_HIERARCHIES$ H
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 11 -- DIMENSION
AND AV.OWNING_DIM_ID = O.OBJ#
AND H.DIM_OBJ# = O.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, NULL HIERARCHY_NAME
, DL.LEVEL_NAME LEVEL_NAME
, 'DIMENSION' FROM_TYPE
, 'DIM_LEVEL' TO_TYPE FROM OLAP_DIM_LEVELS$ DL
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 11 -- DIMENSION
AND AV.OWNING_DIM_ID = O.OBJ#
AND DL.DIM_OBJ# = O.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, DL.LEVEL_NAME LEVEL_NAME
, 'DIMENSION' FROM_TYPE
, 'HIER_LEVEL' TO_TYPE FROM OLAP_HIERARCHIES$ H
, OLAP_HIER_LEVELS$ HL
, OLAP_DIM_LEVELS$ DL
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 11 -- DIMENSION
AND AV.OWNING_DIM_ID = O.OBJ#
AND H.DIM_OBJ# = O.OBJ#
AND HL.HIERARCHY_ID = H.HIERARCHY_ID
AND DL.LEVEL_ID = HL.DIM_LEVEL_ID
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, NULL LEVEL_NAME
, 'HIERARCHY' FROM_TYPE
, 'HIERARCHY' TO_TYPE FROM OLAP_HIERARCHIES$ H
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 13 -- HIERARCHY
AND AV.OWNING_DIM_ID = H.HIERARCHY_ID
AND H.DIM_OBJ# = O.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, DL.LEVEL_NAME LEVEL_NAME
, 'HIERARCHY' FROM_TYPE
, 'HIER_LEVEL' TO_TYPE FROM OLAP_HIERARCHIES$ H
, OLAP_HIER_LEVELS$ HL
, OLAP_DIM_LEVELS$ DL
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 13 -- HIERARCHY
AND AV.OWNING_DIM_ID = H.HIERARCHY_ID
AND H.DIM_OBJ# = O.OBJ#
AND HL.HIERARCHY_ID = H.HIERARCHY_ID
AND DL.LEVEL_ID = HL.DIM_LEVEL_ID
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, DL.LEVEL_NAME LEVEL_NAME
, 'HIER_LEVEL' FROM_TYPE
, 'HIER_LEVEL' TO_TYPE FROM OLAP_HIERARCHIES$ H
, OLAP_HIER_LEVELS$ HL
, OLAP_DIM_LEVELS$ DL
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 14 -- HIER_LEVEL
AND AV.OWNING_DIM_ID = HL.HIERARCHY_LEVEL_ID
AND HL.HIERARCHY_ID = H.HIERARCHY_ID
AND DL.LEVEL_ID = HL.DIM_LEVEL_ID
AND H.DIM_OBJ# = O.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, NULL HIERARCHY_NAME
, DL.LEVEL_NAME LEVEL_NAME
, 'DIM_LEVEL' FROM_TYPE
, 'DIM_LEVEL' TO_TYPE FROM OLAP_DIM_LEVELS$ DL
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 12 -- DIM_LEVEL
AND AV.OWNING_DIM_ID = DL.LEVEL_ID
AND DL.DIM_OBJ# = O.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME OWNER
, O.NAME DIMENSION_NAME
, A.ATTRIBUTE_NAME ATTRIBUTE_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, DL.LEVEL_NAME LEVEL_NAME
, 'DIM_LEVEL' FROM_TYPE
, 'HIER_LEVEL' TO_TYPE FROM OLAP_HIERARCHIES$ H
, OLAP_HIER_LEVELS$ HL
, OLAP_DIM_LEVELS$ DL
, OLAP_ATTRIBUTES$ A
, OLAP_ATTRIBUTE_VISIBILITY$ AV
, OBJ$ O
, USER$ U WHERE AV.IS_UNIQUE_KEY = 0
AND AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND AV.OWNING_DIM_TYPE = 12 -- DIM_LEVEL
AND AV.OWNING_DIM_ID = DL.LEVEL_ID
AND DL.LEVEL_ID = HL.DIM_LEVEL_ID
AND HL.HIERARCHY_ID = H.HIERARCHY_ID
AND H.DIM_OBJ# = O.OBJ#
AND O.OWNER# = U.USER#