ALL_CUBE_DIMENSIONALITY
describes the dimension order for the OLAP cubes accessible to the current user.
Related Views
DBA_CUBE_DIMENSIONALITY
describes the dimension order for all OLAP cubes in the database.
USER_CUBE_DIMENSIONALITY
describes the dimension order for the OLAP cubes owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the cube |
|
|
|
Name of a cube, such as |
|
|
|
Name of a dimension of the cube, such as |
|
|
The name of a dimensionality of the cube. For example, a cube dimensioned by the |
|
|
|
|
ID of the cube dimensionality |
|
|
|
Order number of the dimension in the cube |
|
|
Indicates whether the dimension is sparse in the cube ( |
|
|
|
Specifies the prefix that will be added to the column names in the Materialized Views to ensure uniqueness. If the user does not specify an |
See Also: