Setting up a financial statement template

Admin |

Relate an account to a parent FST item

Dimensions tile > Account tile > > FST & KPI > > FST Items

  1. Select the desired FST item.
  2. In Description, insert the desired description.
  3. In Item Type, select Parent Item, then click Save.
  4. Click the Relationships link and add the desired accounts to the FST item.
  5. Click Save.

Insert a description on a description-type FST item

Dimensions tile > Account tile > > FST & KPI > > FST Items

  1. Select the desired FST item.
  2. In Description, insert the desired description.
  3. In Item Type, select Description, then click Save.

Define a standard formula on an FST item

Only when Item type is set to Standard formula.

  1. Click : the formula management fields will appear.
  2. In Add item from, select a financial statement template, an account or a node of accounts to be inserted into the formula.
  3. In the formula definition area, type [: a list of FST items or accounts available to the relationship will appear.
  4. Double click the desired FST item or account: the argument will appear in the definition area.
  5. Repeat the previous steps for every desired argument.
  6. Create the formula logic using the desired logical connectors and functions

Note: click Guide for more details on formula syntax, or consult the dedicated page in the manual (see Standard formula syntax). 7. Click Save.

Override a formula for cube on an FST item

IMPORTANT: to define a formula for cube, an FST item containing a standard formula from which to override the formula for MSService cubes must have already been created. For more details, see Formula for cube.

  1. Click > Set formula for cube: a popup progress bar will open showing the progress of the data processing launched on the entire financial statement template. Wait for the data processing complete message.
  2. Click > FST items and select the desired FST item.
  3. In the formula for cube definition area, check the syntax of the formula calculated by the data processing.
  4. To edit the formula, select Override formula for cube and make the desired changes.
  5. Click Save.

Note: when the formula for cube is edited manually, the edited formula is not edited by the subsequent running of data processing to calculate formulas for cube.

Define a multidimensional formula

  1. Select a row with Item type: MD Formula.

  2. In the Formula definition area, insert the multidimensional formula.

How to exclude individual items from a financial statement template

Dimensions tile > Account tile > > FST&KPI > > FST Items > Relationships

Normally, all the accounts that belong to the account nodes inserted in an FST item will be included in the relative financial statement template. To exclude some specific items, proceed as follows:

  1. In the table, select the account not to be included.
  2. In the Attributes tab, select the Exclude action, then click Save: the account is no longer related to the FST item.

How to check the accounts present in the FST items

Dimensions tile > Account tile > > FST&KPI > > FST Items > Relationships

To check which accounts have been inserted in an FST item after a formula has been applied, it is useful to follow the procedure below.

Select the desired FST item, then click Definition result: the Definition results page will open, showing all the accounts that have actually been inserted in the FST item.