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

CREATE_SCRIPT Procedure

This procedure generates a script that converts a parent-child dimension table to an embedded-total dimension table.

Syntax

CREATE_SCRIPT (
          directory          IN   VARCHAR2,
          schema             IN   VARCHAR2,
          pc_table           IN   VARCHAR2,
          pc_parent          IN   VARCHAR2,
          pc_child           IN   VARCHAR2,
          slb_table          IN   VARCHAR2,
          slb_tablespace     IN   VARCHAR2,
          pc_root            IN   VARCHAR2   DEFAULT  NULL,
          number_of_levels   IN   NUMBER     DEFAULT  NULL,
          level_names        IN   VARCHAR2   DEFAULT  NULL,
          short_description  IN   VARCHAR2   DEFAULT  NULL,
          long_description   IN   VARCHAR2   DEFAULT  NULL,
          attribute_names     IN   VARCHAR2   DEFAULT  NULL);

Parameters

Table 25-2  CREATE_SCRIPT Procedure Parameters
Parameter Description

directory

Full path of the directory that will contain the generated script.

schema

Schema containing the parent-child table. This schema will also contain the solved, level-based table.

pc_table

Name of the parent-child table.

pc_parent

Name of the column in pc_table that contains the parent values .

pc_child

Name of the column in pc_table that contains the child values.

slb_table

Name of the solved, level-based table that will be created.

slb_tablespace

Name of the tablespace where the solved, level-based table will be created.

pc_root

One of the following:

null - Root of the parent-child hierarchy is identified by null in the parent column. (default)

condition - Root of the parent-child hierarchy is a condition, for example:

'long_des = "All Countries"'

number_of_levels

One of the following:

null - The number of levels in the solved, level-based table will be all the levels of the hierarchy in the parent-child table. (default)

number - The number of levels to be created in the solved, level-based table.

level_names

One of the following:

null - The column names in the solved, level-based table will be the source child column name concatenated with the level number. (default)

list - A comma-separated list of column names for the solved, level-based table.

short_description

One of the following:

null - There is no short description in the parent-child table. The highest level non-null child value in each row of the solved, level-based table will be used as the short description. This constitutes the ET key column (default)

column name - Name of the column in the parent-child table that contains the short description. This column will be copied from the parent-child table to the solved, level-based table.

long_description

One of the following:

null - There is no long description in the parent-child table. The short description will be used. (default)

column name - Name of the column in the parent-child table that contains the long description. This column will be copied from the parent-child table to the solved, level-based table.

attribute_names

One of the following:

null - There are no attributes in the parent-child table. (default)

list - A comma-separated list of attribute columns in the parent-child table. These columns will be copied from the parent-child table to the solved, level-based table

Usage Notes

  1. If a table with the same name as the solved, level-based table already exists, the script will delete it.
  2. You can reduce the time required to generate the script by specifying the number of levels in the number_of_levels parameter. If you do not specify a value for this parameter, the CREATE_SCRIPT procedure calculates all the levels from the parent-child table.
  3. To define additional characteristics of the solved, level-based table, you can modify the generated script file before executing it.