Line-Items
Basic Overview
Line-items are the instance of change to your base model. They affect a single node and can filter its content to apply even more specific changes.
By creating and combining line-items, you can build your simulation on a granular level. Line-items contain changes to the values of a node. These changes are stated either as a relative change (%) or as absolutes. Additionally, a line-item can consist of multiple variants, which are alternative versions of the same line-item based on the same node. This can be useful for certain exclusive assumptions, like “pessimistic” or “optimistic” market growth.
Like assumptions, line-items can be duplicated.
Creating a Line-Item
To add a line-item to your assumption, use the assumptions three-dot menu.
In the first step to create a line-item, you can choose between a relative or an absolute line-item.
After that, select a node and provide a name to the line-item.
Absolute Line-Item:
Used to enter absolute values as the change to your base data
Has a fixed dimensionality which cannot be changed
Relative Line-Item:
Used to enter relative values as the change to your base data
The dimensionality of a relative line-item can be adjusted
In a relative line-item it is possible to select a hierarchically higher level in the dimensionality, which will aggregate the lower level values into the new level
E.g. The line-item is based on ‘Months’ in the ‘Time’ dimension. By changing the dimensionality and selecting ‘Year’ from the ‘Time’ dimension, all the values from ‘01-2023’ till ‘12-2023’ will be aggregated to ‘2023’.
Line-Item Data & Details
To see the data of a line-item, click on the name the line-item.
The data view will open on the right side of the screen. In the columns of the data table are the levels of your line-item, the ‘Base’ that comes from the model, the ‘Change’ column, the ‘Result’ column, and a column where you can enter a comment or description for each row.
Setting filters for the columns on that screen can be used to temporarily focus the view onto the data. After the next browser refresh or after leaving the data view, these filters have been resetted.
To see the details of your line-item, click on the “Details” button in the upper right corner. On that screen, you can see more details of your line-item.
Manage Levels and Filters
To either set permanent filters onto your line-item or to change the dimensionality of your relative line-item, use the “Manage levels and filter” button in the details view.
In this dialog the left column shows the levels of the dimensionality of your line-item. For relative line-items it is possible to delete or add levels.
The right side of that dialog relates to filters set on the levels that affect the view onto the data of a line-item. The filters set here are permanent.
To set a filter on one of the levels in the line-item, click on the level first and then adjust the filters to your desired view. To set filters on a level, it has to be in the dimensionality first.
