Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
The COPYDFN command defines a new object in the analytical workspace and uses the same definition as a specified object in the current workspace or in an attached workspace.
COPYDFN copies the DEFINE, LD, and PROPERTY lines for any type of object, and it copies the formula (EQ) of a formula object, and the value name format (VNF) of a dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. COPYDFN also copies the text of a program or model. COPYDFN does not copy the PERMIT lines for any object, and it does not copy the compiled code of a formula, program, or model.
Syntax
COPYDFN newobject oldobject
Arguments
The name of the new object to define.
The name of the object whose definition you want to copy.
Examples
Example 11-25 Copying Programs
The following statements use COPYDFN to create a new program, called newprog
, which is a copy of an existing one called oldprog
. You could then edit newprog
to create a slightly different program. The oldprog
program has the following definition.
DEFINE oldprog PROGRAM LD Shows total sales for the top five months from high to low PROGRAM LIMIT district TO 'BOSTON' LIMIT month TO TOP 5 BASEDON TOTAL(sales, month) REPORT TOTAL(sales, month) END
The statements
COPYDFN newprog oldprog DESCRIBE newprog
produce the following definition for newprog
.
DEFINE newprog PROGRAM LD Shows total sales for the top five months from high to low PROGRAM LIMIT district TO 'BOSTON' LIMIT month TO TOP 5 BASEDON TOTAL(sales, month) REPORT TOTAL(sales, month) END