Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CUBES OLAP Cubes in the database accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)YOwner of the OLAP Cube
2CUBE_NAMEVARCHAR230(null)NName of the OLAP Cube
3AW_NAMEVARCHAR230(null)YName of the Analytic Workspace which owns the OLAP Cube
4CONSISTENT_SOLVE_SPECCLOB4000(null)YThe Consistent Solve Specification for the OLAP Cube
5DESCRIPTIONNVARCHAR2600(null)YLong Description of the OLAP Cube
6SPARSE_TYPEVARCHAR280(null)YText value indicating type of sparsity for the OLAP Cube
7PRECOMPUTE_CONDITIONCLOB4000(null)YCondition syntax representing precompute condition of the OLAP Cube
8PRECOMPUTE_PERCENTNUMBER22(null)YPrecompute percent of the OLAP Cube
9PRECOMPUTE_PERCENT_TOPNUMBER22(null)YTop precompute percent of the OLAP Cube
10PARTITION_DIMENSION_NAMEVARCHAR230(null)YName of the Cube Dimension for which there is a partition on the OLAP Cube
11PARTITION_HIERARCHY_NAMEVARCHAR230(null)YName of the Hierarchy for which there is a partition on the OLAP Cube
12PARTITION_LEVEL_NAMEVARCHAR230(null)YName of the HierarchyLevel for which there is a partition on the OLAP Cube

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:24
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here