Show TOC

Function documentationLogic Task Usage Locate this document in the navigation structure

 

Logic is a Microsoft SSID version of the Planning and Consolidation Logic module that can be used from within the Data Manager module. This allows you to use the full power of the Logic module in a batch setting. The functionality of this package is similar to the functionality of the Logic Debugger in the Admin module. The main difference is that this package is set to affect the data in the database by default, while the Logic Debugger is set to run in simulation mode by default. Logic is especially useful when importing data directly into long term storage (the fact table), which bypasses default formulas by default. See Running a Package.

You can use Logic for the following tasks:

  • Calculations that can only be executed in batch mode after the appropriate data has been entered into the application database (the cube). This might be applicable in the following scenarios:

    • You run an elimination procedure after all Intercompany declarations have been entered by all companies.

    • You encounter a situation in which currency conversion must be re-executed after some exchange rates have been modified.

  • To maximize performance, it may be better to wait until all data is verified as correct before running logic on it.

Note Note

You can use MODIFYSCRIPT Package Variable tasks to manipulate the values of the Logic task. Alternatively, EvDTSModifyPkg tasks are given in the description of the Logic interface, below. For more information about MODIFYSCRIPT, see MODIFYSCRIPT Package Variable Task Usage.

End of the note.