see an overview of all the line items in a model and make amendments to those line items.
Each module has a role to play in the processing of data in a model: data input, export, mapping, or staging. Think about these purposes when developing a naming convention that will ensure your modules are unique and easily identifiable — Good Practice: Naming Conventions provides more information.
Select a module and click:
Open to open the module in a new tab
Insert Module to add a new module
Copy to copy an existing module
Delete to remove a module
Reorder to organize and sort your modules
Refresh to update the data from the server
to search for a module contained in your model
The columns in the Modules tab enable you to view and amend attributes for each module.
Select a functional area for the module.
Select the lists which will be the dimensions of the module.
Set the timescale for the module.
If the module had no time dimension and you select one here, the time dimension will be added as a page to the module.
If you change the timescale for a module, this does not automatically change the timescale for the line items in the module.
If the module has a time dimension and you select Not Applicable to remove it, then time dependent data will not be shown in the module view. However, you will still be able to open subsidiary views for line items that retain a time dimension.
Note that changing the dimensionality of a module may lead to data loss.
Select to have the model versions apply or not apply to the module.
If you change the applicability of versions to the module, this does not automatically change the applicability of versions to the line items in the module.
Select the default breakback setting for new line items added to the module (toggle between On or Off).
Read-off the number of cells contained in the module.
Read-off any other modules that reference the module.
Read-off the line items the module contains. (More details for line items is displayed on the Line Items tab.)
Open to open all modules associated with that functional area
Insert to add a new functional area
Delete to delete the functional area
Reorder to move and sort your functional areas
You can also assign a category to a functional area by selecting an option from the Category list.
Line Items tab
The Line Items
tab shows a list of all line items organized by module:
Click the module name and click Open to open it in a separate tab.
Click Export to export the grid to .csv, .txt, or pdf format.
You can add a formula, choose a parent, set the Is Summary flag and more.
Blueprint has greater detail about each option in the grid. You can use amend various attributes for individual line items and view information about each line item.
Note that some of the key settings at the module level are also shown on this tab, which you can use to ensure that the settings for these module attributes complement the settings you have made at the level of a module's line items:
You can use the tab columns to set various attributes for individual line items and to view key information relevant to each line item:
The line item formula. To enter a formula or edit an existing formula, double-click in the cell.
For number formatted line items, select another line item in the module as its parent.
Select the checkbox to make the line item the summary for other line items in the module.
Select and configure the line item formatting—number, boolean, date, text, time period, list, no data.
Select the lists which will be the dimensions for the line item.
If a line item has no specific list dimensions selected but has a dash at the left side of the Applies To cell, then the line item will inherit the default dimensionality.
If the Applies To cell is empty—no dash for inherit default—no lists will be applied to the line item as dimensions.
If you change the dimensionality of the line item so that it does not match the module's dimensionality, then a subsidiary view is created for the line item.
The dimensionality of the module is also shown and can be changed from this tab.
Set the timescale for a line item:
If a line item has a timescale selected and you select Not Applicable and the module still has a timescale applied, a subsidiary view will be created any data entered for the line item will be lost.
If a line item has a timescale selected but you remove the timescale for the module, then a subsidiary view will be created for the line items that still have a timescale defined.
If you make the line item timescale different to the module timescale, then a subsidiary view is created for the line item.
The timescale of the module is also shown and can be changed from this tab.
Select to have the model versions apply or not apply to a line item:
If the module has all versions applied, a subsidiary view will be created for any line items that do not have versions applied.
If the module does not have versions applied, a subsidiary view will be created for any line items that do have versions applied
The versions setting for the module is also shown and can be changed from this tab.
Start of Section
Select the checkbox for a line item to change the default dimensionality for any line items after this in the module:
Any line items with a dash under Applies To and that follow the Start of Section line item in the order of line items will pick-up their dimensionality from the Start of Section line item.
Make sure the order of line items in your module is correct when you use this setting—that you want only those line items after the Start of Section line item to inherit their dimensionality from it.
Select the checkbox, if you want to carry forward balances from a previous period for a line item:
An extra time period is added to the time scale for the line item.
If the line item contains a formula, you won't be able to to edit the cell for this extra period.
Select a summary method for the line item. Where the dimensionality includes both a list and time, you can set one summary method for the list values and a different summary method for time.
Select which versions you want a line item's formula to apply to:
All Versions except Actual
Select the checkbox, if you want the switchover date defined for model versions to be applied to a line item. A line item must have versions applied for the checkbox to be enabled.
You can set the switchover date for versions in Model Settings, Versions.