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.