Financials configuration

In order to send data from a Dataflow document to Planning Space Financials for calculations, you first need to configure it in the document's template.

To do so:

  1. Open the template and click the Financials Configuration button in the Templates tab of the ribbon. The Financials Configuration window will be displayed.
  2. PS-Dataflow-Template-Financials-Configuration-1

  3. Click the Add Regime button Add regime button and select a regime in the pop-up window. The selected regime will appear in the table.
  4. Select the terms preset which will be used for this regime by clicking in the Default Regime Terms Preset column to open a drop-down list. The list of presets available is taken from the selected regime.
  5. PS-Dataflow-Template-Financials-Configuration-2

  6. You can add as many regimes as required. One regime can be set as the Default Regime by using the checkbox.
  7. Now you need to map Dataflow variables to variables in the selected Financials regime(s). The Inputs tab is used to map variables which will be used as inputs for Financials calculations, and the Outputs tab is used to map variables which will store calculation results. Both tabs work in the same way, and the columns are explained in the table below. If a variable has exactly the same name, data type and unit type in both Dataflow and Financials, it will be mapped automatically.
  8. Note: You can create a mapping for variables with Custom units providing that the Custom unit definitions are identical for each variable in Dataflow and in the Financials regime.

    PS-Dataflow-Template-Financials-Configuration-3

    Column Description
    Regime Regime(s) in which the variable will be mapped. By default, Financials variables are mapped in all regimes which is indicated by the <Generic> setting; in the image above, all variables will be linked for all regimes. To map a variable from one regime only, click Click here to add a new item and select a regime from the list: this will add another row to the table where you can map that variable.
    Financials Variable On the Inputs tab, this list includes user-entered variables in the selected regime(s). On the Outputs tab, it shows all variables whose source is set to None in the selected regime(s).
    Dataflow Variable Dataflow variables corresponding to the Financials variables. In each row, the list of Dataflow variables is filtered: Dataflow variables must have the same data type as Financials variables, and must be used in the opened template.
  9. Once you have finished the variables mapping, you can export it into a XML file for reuse: click the Export button Export button at the top of the dialog and save the file. To import a mapping file, click the Import button Import button.
  10. To save the changes, click OK. The configuration will be stored in the History of changes.