DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_CUBE_ATTR_VISIBILITY

Object Details
Object Name: DBA_CUBE_ATTR_VISIBILITY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

OLAP Attributes visible for Dimensions, Hierarchies, and Levels

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of OLAP Attribute
DIMENSION_NAME VARCHAR2 (128)
Name of the OLAP Cube Dimension that owns the OLAP Attribute
ATTRIBUTE_NAME VARCHAR2 (128)
Name of the OLAP Attribute
HIERARCHY_NAME VARCHAR2 (128)
Name of the OLAP Hierarchy for which the Attribute is visible
LEVEL_NAME VARCHAR2 (128)
Name of the OLAP Level for which the Attribute is visible
FROM_TYPE VARCHAR2 (10)
Object type on which the visibility has been explicitly set
TO_TYPE VARCHAR2 (10)
Object type on which the visibility has been implicitly derived
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      DIMENSION_NAME
,      ATTRIBUTE_NAME
,      HIERARCHY_NAME
,      LEVEL_NAME
,      FROM_TYPE
,      TO_TYPE
FROM SYS.DBA_CUBE_ATTR_VISIBILITY;

Dependencies

[top of page]

SYS.DBA_CUBE_ATTR_VISIBILITY references the following:

SchemaSYS
TableOBJ$
TableOLAP_ATTRIBUTES$
TableOLAP_ATTRIBUTE_VISIBILITY$
TableOLAP_DIM_LEVELS$
TableOLAP_HIERARCHIES$
TableOLAP_HIER_LEVELS$
TableUSER$
SYS.DBA_CUBE_ATTR_VISIBILITY is referenced by following:

SchemaPUBLIC
SynonymDBA_CUBE_ATTR_VISIBILITY