FO Sets (Financial Object Sets)

FO Sets allow you to specify which FOs are to be included in any given part in a Parts Dimension. FO Sets can be configured such that, as new FOs are added to the model, the FO Set is automatically extended without the need for a specific reference to each FO.

FO Sets can also be defined globally in Model Infrastructure and applied to all parts in a given Parts Dimension. This allows you to define a common set of FOs, avoiding the need to add them individually to each part.

When a Parts Dimension is created there are three parts by default: 'All', 'Part 1', and 'Part 2'. The 'All' parts set includes every financial object instance in the model and cannot be deleted. 'Part 1' and 'Part 2' are created for convenience and can be modified or deleted at any time.

 

Modifying a FO Set

Click on 'Part 1', 'Part 2', or any other part you added. Its details will open below. Re-title the part and type in any notes concerning the part in Annotations.

Click on FO Set next to Parts. The details of the FO Set will appear below. Click on Step 1 and its details will appear below.

 

Operation

A FO Set starts with no items in the set. FO Instances are added to the set (Operation = Add) , or removed from the set (Operation=Remove), if they match the criteria you specify.

Kinds of Matching

FOs can be added to the set using a variety of matching criteria

Object

How to read the parameters - Add any FO that matches the selection. Negate?=Yes will add any FO that does not match the selection.

FOs are added to the set by selecting/drilling down to groups of FOs or individual FOs in the following categories:

  • Income Statement - This selection will include all Income Statement FOs. Drill down further to select a specific group or instance.
  • Balance Sheet - This selection will include all Balance Sheet FOs. Drill down further to select a specific group or instance.
  • User Defined - This selection will include all User Defined FOs. Drill down further to select a specific group or instance.

Example:

Add any FO that matches the selection (Income Statement, Revenue).

Result: Adds all Revenue FOs

Negate?=Yes will add all non-Revenue FOs.

Textural

How to read the parameters -

FOs are added to the set by selecting:

  1. What? e.g. FO Attribute values
  2. How? - Select between contain, equal, starts with, ends with.
  3. Matching String - Type in the text to be matched.

FO Type

If you want FOs to be added to the set based upon its Financial Object type. Drill down and select the Financial Object Type to have all instances of it to be added/removed.

Example:

Add any FO that is of the type Basic Income.

Result: Adds all Basic Income FOs

Negate?=Yes will add all FOs that are not of the type Basic Income.

Submodel/Library

FOs will be added to the set if they are included in a specific Library or Model import.

Data Store Import

Any FO that contains imported data from a specific Data Store Import will be included in the set.

FO Attribute value

Select the FO Attribute and then type in a string A sequence of characters. that is to be matched. If a match is found between a FO and a FO Attribute value, the FO is added to the set.

Hub

If a Hub is used as the matching criteria, all the hub's connections will be added to the set.

 

Negate?

This selection is useful when there is more than one Step and you want to add or remove items from the result of the previous step (In the first Step, "Add" and "Negate: do" or "Remove" and "Negate: do not" will return the same set of items).

 

Working with Combinations of Operations and Negate

Combinations of Operations (Add - Remove) and Negate (No - Yes or Do - Do Not) modify the set of FOs by adding or removing items that either match or do not match a specified criteria.

 

Let's say you currently have the set {a,b,c} from previous steps:

  • Add means you are adding to the set, so that {a,b,c} will be in the resulting set no matter what. The set can only get bigger.
  • Remove means you are removing items from the set, so that you won't have more than {a,b,c}. The set can only get smaller.
  • Add Not x means to add everything that is Not x to the set.
  • Remove Not x means to remove everything that is Not x from the set.

 

Examples (Assumes {a,b,c} is the starting set):

  • Add {b,e} = {a,b,c,e}
  • Add Not {b,e} = {a,b,c,d,f,g,h, ... }
  • Remove {b,e} = {a,c}
  • Remove Not {b,e} = {b}

 

For the first step only, if you use Add, the initial set is the empty set, but if you use Remove, then the initial set is everything.

Examples

  • Step 1: Add {b,e} = {b,e}
  • Step 1: Remove Not {b,e} = {b,e}
  • Step 1: Remove {b,e} = {a,c,d,f,g,....}
  • Step 1: Add Not {b,e} = {a,c,d,f,g, ....}

 

Set Report

To generate an Set Report for the FO, click the "Set Report" button at the top of an FO Set panel or expand the FO Set group in the Navigation Tree, right click on the desired FO Set and select "Set Report". If this is the first time a Set Report is requested for your model, the system will automatically create a default Line Item Set Report Specification based on an All Years framework. The Set Report specification is located under the Standard Reports group in the Navigation Tree.

Changes can be made to how the default Set Report appears by making modifications to the Set Report Specification including choosing a different framework, choosing different styles, and many other options.

 

Related Links:

Financial Objects

Parts Dimensions

Frameworks