Show TOC

Load Process Chain ExamplesLocate this document in the navigation structure

The Load process chain has many useful data dump and data retrieval functions as follows:
  • Processing the Application

    You can import data when you process the application or you can process the application without importing data.

  • Importing Into Cube

    You can import a correctly-formatted ascii text file directly into the database.

  • Exporting from Cube

    You can export an ascii text file that contains data from you Planning and Consolidation database

  • TASK Commands in the Load Process Chain

    You can use the following TASK commands in the Load process chain.

The syntax is as follows: 

TASK(TASKNAME,NAME,DTSTask_EvDTSDumpLoad.clsEvDTSDumpLoad_1)
		  TASK(TASKNAME,DESCRIPTION,TASKNAME) TASK(TASKNAME,APPSET,apshell)
		  TASK(TASKNAME,APP,finance) TASK(TASKNAME,USER,tonyd)
		  TASK(TASKNAME,DATATRANSFERMODE,1) TASK(TASKNAME,PROCESSMODE, 2)
		  TASK(TASKNAME,PROCESSCUBE,1) TASK(TASKNAME,PROCESSCUBE_FAC2,)
		  TASK(TASKNAME,FILE,C:\...\Webfolders\ApShell\Finance\DataManager\DataFiles\Examples\Import.txt)
		  TASK(TASKNAME,SQL,) TASK(TASKNAME,MDX,) TASK(TASKNAME,MAXMEMBERS,)
		  TASK(TASKNAME,SELECTION,) TASK(TASKNAME,CLEARDATA,0)
		  TASK(TASKNAME,TIMEIDFORMAT,0)
		  TASK(TASKNAME,SELECTIONFROMTASK,"CATEGORY,TIME,ENTITY")
		  TASK(TASKNAME,DIMLIST,"CATEGORY,TIME,ACCOUNT,ENTITY,DATASRC,INTCO,RPTCURRENCY")
		  TASK(TASKNAME,RUNTHELOGIC,0) TASK(TASKNAME,GETMEASURE,)
		  TASK(TASKNAME,MACHINENAME,) TASK(TASKNAME,VALIDATETMPFILE,)
		  TASK(TASKNAME,DMMCOPY,)