Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
Creating Fact Materialized Views With DBMS_ODM, 7 of 9
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 |
CREATECUBELEVELTUPLE ( cube_owner IN VARCHAR2, cube_name IN VARCHAR2);
Parameter | Description |
---|---|
|
Owner of the cube. |
|
Name of the cube. |
|
![]() Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|