Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

CREATECUBELEVELTUPLE Procedure

This procedure creates the table sys.olaptableveltuples, which lists all the level combinations to be included in the materialized view for the cube.

The table sys.olaptableveltuples is created based on the table sys.olaptablevels, which was generated by the CREATEDIMLEVTUPLE Procedure.


Important:

If you do not want to include all level combinations in the materialized view for the cube, you must edit the table sys.olaptablevels before executing the CREATECUBELEVELTUPLE procedure.


Syntax

CREATECUBELEVELTUPLE (
               cube_owner     IN   VARCHAR2,
               cube_name      IN   VARCHAR2);

Parameters

Table 30-3  CREATECUBELEVELTUPLE Procedure Parameters
Parameter Description

cube_owner

Owner of the cube.

cube_name

Name of the cube.