Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2)

Part Number A95295-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

OLAP Catalog (CWM2-Specific) Views , 23 of 25


ALL$OLAP2_HIER_CUSTOM_SORT

Each row provides information about custom sorting specified for a given dimension hierarchy. Custom sorting information is optional.

Custom sorting information specifies how to sort the members of a hierarchy based on columns in the associated 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.

Column Datatype NULL Description

DIMENSION_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 containing the column to be sorted.

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension table containing the column to be sorted.

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.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback