Package Name

Description

Clear

This package clears the data in the Fact and FAC2 table by importing zero values. The optimize process clears all values from the table. Running this package also clears comments from the comments table. You can use the import.xls transformation file with this package.

Copy

This package copies data between dimensions within the Planning and Consolidation application. See Copying Application Data.

Default Formulas

This package executes default formulas stored in your Default.LGF file.

Export

This package exports data values from the Planning and Consolidation cube (including calculated values) into an ASCII file. You are prompted to enter a name for the export file and for a data selection to export. You can use the export.xls transformation file with this package.

FX Restatement

This package is used for currency translation. A sample logic file, FXTrans.lgf, is provided as an empty file. For more information, see Currency Conversions.

Import

This package imports one or more ASCII files into the current application. You are prompted for one or more import files and associated conversion files. The signs of the amounts are reversed based on the Account type. You can use the import.xls transformation file with this package.

Move

This package lets you move any selection of data within an application. You are prompted for source and destination data selections for all dimensions. The package clears records in the fact table in the destination before it moves records from the source fact table. When the records have been moved to the destination, the package clears the records in the source table.