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

VIEW: SYS.ALL_CUBE_DIMENSIONS

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

OLAP Cube Dimensions in the database accessible by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the OLAP Cube Dimension
DIMENSION_NAME VARCHAR2 (128) Yes Name of the OLAP Cube Dimension
DIMENSION_ID NUMBER
Yes Dictionary Id of the OLAP Cube Dimension
DIMENSION_TYPE VARCHAR2 (17)
Type of the OLAP Cube Dimension
AW_NAME VARCHAR2 (128)
Name of the Analytic Workspace which owns the OLAP Cube Dimension
DEFAULT_HIERARCHY_NAME VARCHAR2 (128)
Default Hierarchy name of the OLAP Cube Dimension
DESCRIPTION NVARCHAR2 (600)
Long Description of the OLAP Cube Dimension
HIERARCHY_CONSISTENCY_RULE VARCHAR2 (200)
Hierarchy consistency rule of the OLAP Cube Dimension
ADD_UNIQUE_KEY_PREFIX VARCHAR2 (3)
Add_Unique_Key_Prefix flag of the OLAP Cube Dimension
CUSTOM_ORDER CLOB (4000)
Custom Order of the OLAP Cube Dimension
Query Text

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


SELECT OWNER
,      DIMENSION_NAME
,      DIMENSION_ID
,      DIMENSION_TYPE
,      AW_NAME
,      DEFAULT_HIERARCHY_NAME
,      DESCRIPTION
,      HIERARCHY_CONSISTENCY_RULE
,      ADD_UNIQUE_KEY_PREFIX
,      CUSTOM_ORDER
FROM SYS.ALL_CUBE_DIMENSIONS;

Dependencies

[top of page]

SYS.ALL_CUBE_DIMENSIONS references the following:

SchemaSYS
TableAW$
ViewNLS_SESSION_PARAMETERS
TableOBJ$
TableOBJAUTH$
TableOLAP_CUBE_DIMENSIONS$
TableOLAP_DESCRIPTIONS$
TableOLAP_HIERARCHIES$
TableOLAP_IMPL_OPTIONS$
TableOLAP_SYNTAX$
TableUSER$
SYS.ALL_CUBE_DIMENSIONS is referenced by following:

SchemaPUBLIC
SynonymALL_CUBE_DIMENSIONS
SchemaSYS
Package BodyDBMS_CUBE - show dependent code
Package BodyDBMS_CUBE_ADVISE - show dependent code
Package BodyDBMS_CUBE_UTIL - show dependent code