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

CWM2_OLAP_DIMENSION , 9 of 14


SET_DEFAULT_DISPLAY_HIERARCHY Procedure

This procedure sets the default hierarchy to be used for display purposes.

Syntax

SET_DEFAULT_DISPLAY_HIERARCHY  (
          dimension_owner     IN   VARCHAR2,
          dimension_name      IN   VARCHAR2,
          hierarchy_name      IN   VARCHAR2);

Parameters

Table 17-9 SET_DEFAULT_DISPLAY_HIERARCHY Procedure Parameters
Parameter Description

dimension_owner

Owner of the dimension.

dimension_name

Name of the dimension.

hierarchy_name

Name of one of the dimension's hierarchies.

Exceptions

Table 17-10 SET_DEFAULT_DISPLAY_HIERARCHY Procedure Exceptions
Exception Description

no_access_privileges

User does not have the necessary privileges. User must be the owner and have the OLAP_DBA role.

dimension_not_found

Cannot update dimension. Dimension does not exist within the OLAP 2 Catalog.

hierarchy_not_found

This hierarchy not found for this dimension.




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