Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The COPYDFN program 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.
COPYDFN newobject oldobject
The name of the new object to define.
The name of the object whose definition you want to copy.
The following statements use COPYDFN to create a 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