[Home] [Help] [Dependency Information]
Object Name: | ALL_CUBES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Cubes in the database accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the OLAP Cube | |
CUBE_NAME | VARCHAR2 | (128) | Yes | Name of the OLAP Cube |
CUBE_ID | NUMBER | Yes | Dictionary Id of the OLAP Cube | |
AW_NAME | VARCHAR2 | (128) | Name of the Analytic Workspace which owns the OLAP Cube | |
CONSISTENT_SOLVE_SPEC | CLOB | (4000) | The Consistent Solve Specification for the OLAP Cube | |
DESCRIPTION | NVARCHAR2 | (600) | Long Description of the OLAP Cube | |
SPARSE_TYPE | VARCHAR2 | (200) | Text value indicating type of sparsity for the OLAP Cube | |
PRECOMPUTE_CONDITION | CLOB | (4000) | Condition syntax representing precompute condition of the OLAP Cube | |
PRECOMPUTE_PERCENT | NUMBER | Precompute percent of the OLAP Cube | ||
PRECOMPUTE_PERCENT_TOP | NUMBER | Top precompute percent of the OLAP Cube | ||
PARTITION_DIMENSION_NAME | VARCHAR2 | (128) | Name of the Cube Dimension for which there is a partition on the OLAP Cube | |
PARTITION_HIERARCHY_NAME | VARCHAR2 | (128) | Name of the Hierarchy for which there is a partition on the OLAP Cube | |
PARTITION_LEVEL_NAME | VARCHAR2 | (128) | Name of the HierarchyLevel for which there is a partition on the OLAP Cube | |
REFRESH_MVIEW_NAME | VARCHAR2 | (200) | Name of the refresh materialized view for the OLAP Cube | |
REWRITE_MVIEW_NAME | VARCHAR2 | (200) | Name of the rewrite materialized view for the OLAP Cube | |
DEFAULT_BUILD_SPEC | CLOB | (4000) | The Default Build Specification for the OLAP Cube | |
MEASURE_STORAGE | VARCHAR2 | (200) | The Measure Storage for the OLAP Cube | |
SQL_CUBE_STORAGE_TYPE | CLOB | (4000) | The SQL Cube Storage Type for the OLAP Cube | |
CUBE_STORAGE_TYPE | VARCHAR2 | (200) | The Cube Storage Type for the OLAP Cube |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CUBE_NAME
, CUBE_ID
, AW_NAME
, CONSISTENT_SOLVE_SPEC
, DESCRIPTION
, SPARSE_TYPE
, PRECOMPUTE_CONDITION
, PRECOMPUTE_PERCENT
, PRECOMPUTE_PERCENT_TOP
, PARTITION_DIMENSION_NAME
, PARTITION_HIERARCHY_NAME
, PARTITION_LEVEL_NAME
, REFRESH_MVIEW_NAME
, REWRITE_MVIEW_NAME
, DEFAULT_BUILD_SPEC
, MEASURE_STORAGE
, SQL_CUBE_STORAGE_TYPE
, CUBE_STORAGE_TYPE
FROM SYS.ALL_CUBES;
|
|
|