CWM2_OLAP_PC_TRANSFORM , 7 of 7

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

If a table with the same name as the solved, level-based table already exists, the script will delete it.
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.
To define additional characteristics of the solved, level-based table, you can modify the generated script file before executing it.