Line Item Sets

Line Item Sets (LISets) allow you to reference multiple line items at once for use in formulas and reports. LISets can be configured such that as new line items are added to the model the LISet is automatically extended without the need for a specific reference to each line item.

 

LISets are centrally created under Model Infrastructure and can be reused any number of times.

 

Creating a LISet

Go to Model Infrastructure/ Line Item Sets. Right-click the desired group and select Add line item set from the menu.

Title the LISet to something descriptive of its intended contents.

 

Click on Step 1'. Its details will open below. Click on the next step to add a new step. Continue until your set is complete.

Operation

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

 

Kinds of Matching

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

Object

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

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

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

Example:

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

Result: Adds all Revenue Line items

Negate?=Yes will add all non-Revenue Line items.

 

Textural

How to read the parameters -

Line items are added to the set by selecting:

  1. What? e.g. its Primary Line Item Every Financial Object has a "primary" line item defined by its type e.g. Basic Income's primary line item is Revenue..
  2. How? - Select between contain, equal, starts with, ends with.
  3. Matching String - Type in the text to be matched.

 

FO Parameter Type

If you want Line items to be added to the set based upon its FO Type . Drill down and select the Financial Object Type the specific line item parameter to be added.

Example:

Add any line item that is of the type Basic Income and select its revenue parameter.

Result: Adds all Basic Income revenue line items

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

 

Line Item Set

Another line item set can be included (or excluded) as long as it is not part of a circular definition.

Sub-model/Library

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

Data Store Import

Any line item 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, all line items in the FO are added to the set.

Tip: If you only want a specific line item to be included, you will need to add an additional step(s) to remove the unwanted line items.

Hub

If a Hub is used as the matching criteria, the line item that is supplied to the hub in 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 Line items 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):

  1. Add {b,e} = {a,b,c,e}
  2. Add Not {b,e} = {a,b,c,d,f,g,h, ... }
  3. Remove {b,e} = {a,c}
  4. 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

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

 

Set Report

To generate a Set Report for the Line Item, 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:

Line Item

Shared Layers

Report Specifications

Formula Layers

Adding and Configuring Constants and Line Items in FO Types