Viewing OLAP Catalog Metadata , 23 of 25

ALL_OLAP2_HIER_CUSTOM_SORT

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`.