| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_OLAP2_HIER_CUSTOM_SORT shows the sort order for level columns within hierarchies. Custom sorting information is optional.
Custom sorting information specifies how to sort the members of a hierarchy based on columns in the dimension table. The specific columns in the dimension tables may be the same as the key columns or may be related attribute columns.
Custom sorting can specify that the column be sorted in ascending or descending order, with nulls first or nulls last. Custom sorting can be applied at multiple levels of a dimension.
| Column | Data Type | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension. |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension. |
HIERARCHY_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the hierarchy. |
TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension table. |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension table. |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column to be sorted. |
POSITION |
NUMBER |
NOT NULL |
Represents the position within a multi-column SORT_POSITION. In most cases, a single column represents SORT_POSITION, and the value of POSITION is 1. |
SORT_POSITION |
NUMBER |
NOT NULL |
Position within the sort order of the level to be sorted. |
SORT_ORDER |
VARCHAR2(4) |
NOT NULL |
Sort order. Can be either Ascending or Descending. |
NULL_ORDER |
VARCHAR2(5) |
NOT NULL |
Where to insert null values in the sort order. Can be either Nulls First or Nulls Last. |
