[Home] [Help] [Dependency Information]
Object Name: | CDB_CUBE_DIMENSIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cube Dimensions in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the OLAP Cube Dimension |
DIMENSION_NAME | VARCHAR2 | (30) | 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 | |
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_CUBE_DIMENSIONS;
SYS.CDB_CUBE_DIMENSIONS does not reference any database object
SYS.CDB_CUBE_DIMENSIONS is referenced by following:
|
|
|