Package

Description

Admin_Makedim

Creates dimension members using a SQL table and schedules the processing of dimension members. For example, if a new member ID is added, this process updates the fac2 table with the updated list.

Admin_Optimize

Optimizes applications with lite, incremental, or full option.

AdminTask_LogicValidation

Validates the logic file.

AdminTask_Process

Processes the application with incremental or full option.

Append

Appends an ASCII file into the current application.

AuditBackup

Backs up audit data.

AuditClear

Clears audit data.

AuditPurge

Purges audit data.

AuditRestore

Restores audit data.

ClearComment

Clears comments from the comments table.

Clear from Fact Table

Removes the data from the Fact and FAC2 tables. The optimize process synchronizes the Fact and FAC2 tables with the cube. Running this package also clears comments from the comments table.

Clear the Journal Tables

Clears the Journals table and creates an output file.

Copy Application

Copies the application database.

Copy from Fact Table

Copies the Fact table.

Export the Journal tables

Exports the Journals table to an output file.

Import Access into Fact Table

Imports the Microsoft Access database into the Fact table. You can use the import.xls transformation file with this package.

Import Access

Imports the Microsoft Access database into the Fac2 table. You can use the import.xls transformation file with this package.

Import Access2007

Imports the MS Access 2007 database into the fac2 table.

Import Category by Time into Fact Table

Imports Category by Time data into the fact table. You can use the Category_By_Time.xls transformation file with this package.

Import Category by Time

Imports Category by Time data into the Fac2 table. You can use the Category_By_Time.xls transformation file with this package.

Import Dimension

Available for the purposes of backward compatibility.

Import Excel2007 into Fact Table

Imports contents of a Microsoft Excel file into the fact table. You can use the import.xls transformation file with this package.

Import Excel2007

Imports the contents of a Microsoft Excel 2007 file into the Fac2 table. You can use the import.xls transformation file with this package.

Import SQL into Fact Table

Imports a Microsoft SQL Server database into the Fact table.

When running this package, you are prompted for the SQL database and table to import.

Import SQL

Imports a Microsoft SQL Server database into the Fac2 table. You can use the import.xls transformation file with this package.

When running this package, you are prompted for the SQL database to import.

ImportUsingFTP

Allows you to import an ASCII file to download from an FTP site into the current application. You can use Microsoft SQL to modify the server name in the package. After you modify the server name, you can run this sample package at any time.

ImportAndSendmail

Imports an ASCII file and sends the result to specific user.

Move from Fact Table

Moves data from the fact table.

OwnershipCalculation

Performs calculations typical of a statutory consolidation application. It is located in the Rate application in Apshell.

Restore the Journal table

Restores Journals tables from an output file.

Scenario Modeling

Allows you to use scenario modeling for forecasting purposes. This package calls a logic file, which is designed for your specific needs.