[Home] [Help] [Dependency Information]
Object Name: | ALL_CUBE_DIMENSIONALITY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cube Dimensionality in the database accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the OLAP Cube Dimensionality |
CUBE_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube of the Dimensionality |
DIMENSION_NAME | VARCHAR2 | (128) | Yes | Name of the Dimension of the OLAP Cube Dimensionality |
DIMENSIONALITY_NAME | VARCHAR2 | (200) | ||
DIMENSIONALITY_ID | NUMBER | Yes | ||
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) |
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
FROM SYS.ALL_CUBE_DIMENSIONALITY;
|
|
|