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

Creating Fact Materialized Views With DBMS_ODM, 6 of 9


CREATEDIMLEVTUPLE Procedure

This procedure creates the table sys.olaptablevels, which lists all the levels of all of the dimensions of the cube. By default, all levels are selected for inclusion in the materialized view. You can edit the table to deselect any levels that you do not want to include.

Syntax

CREATE_DIMLEVTUPLE (
               cube_owner    IN varchar2,
               cube_name     IN varchar2);

Parameters

Table 30-2 CREATEDIMLEVTUPLE Procedure Parameters
Parameter Description

cube_owner

Owner of the cube.

cube_name

Name of the cube.


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