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

VIEW: SYS.CDB_CUBE_DIMENSIONALITY

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

OLAP Cube Dimensionality in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the OLAP Cube Dimensionality
CUBE_NAME VARCHAR2 (30) Yes Name of the OLAP Cube of the Dimensionality
DIMENSION_NAME VARCHAR2 (30) Yes Name of the Dimension of the OLAP Cube Dimensionality
DIMENSIONALITY_NAME VARCHAR2 (200)
Name of the OLAP Cube Dimensionality
DIMENSIONALITY_ID NUMBER
Yes Dictionary Id of the OLAP Cube Dimensionality
ORDER_NUM NUMBER
Yes Order number of the OLAP Cube Dimensionality
IS_SPARSE NUMBER

Indication of whether or not the Dimension is Sparse in the Cube
ET_ATTR_PREFIX VARCHAR2 (200)
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      CUBE_NAME
,      DIMENSION_NAME
,      DIMENSIONALITY_NAME
,      DIMENSIONALITY_ID
,      ORDER_NUM
,      IS_SPARSE
,      ET_ATTR_PREFIX
,      CON_ID
FROM SYS.CDB_CUBE_DIMENSIONALITY;

Dependencies

[top of page]

SYS.CDB_CUBE_DIMENSIONALITY does not reference any database object

SYS.CDB_CUBE_DIMENSIONALITY is referenced by following:

SchemaPUBLIC
SynonymCDB_CUBE_DIMENSIONALITY