Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
CWM2_OLAP_TABLE_MAP, 7 of 18
This procedure specifies how to sort the members of a hierarchy within a column of a dimension table. The column may be the key column or it may be a related attribute column. Custom sorting can specify that the column be sorted in ascending or descending order, with nulls first or nulls last.
Custom sorting information is optional and can be applied at multiple levels of a dimension.
MAP_DIMTBL_HIERSORTKEY ( dimension_owner IN VARCHAR2, dimension_name IN VARCHAR2, hierarchy_name IN VARCHAR2, sortcol IN VARCHAR2);
|
![]() Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|